sr manager of application development resume example

Instructed courses ranging from entry level object oriented programming with the utilization of flow charts, to full on objective languages utilizing ASP.net with C#.net as the back code. Additionally, helped instruct the implementation of database structure, T-SQL code, and design elements into websites. Actively teach HTML and CSS basics to students. Heavily involved in the instruction of computer security, disaster recovery, computer forensics and offensive security for enterprise environments. I have taught for 3 years focusing largely on object development languages (C#.net, VB.net, JAVA and C+), as well as scripting languages (TSQL, PLSQL, VBScript, JavaScript, PHP) and presentation layers (ASP.net and HTML). My primary areas of focus are in object oriented programming using either C#.net or VB.net as well as the implementation of these languages in the ASP.net framework, database development and design utilizing Oracle databases, as well as SQL Server databases. Multi-year track record of success in instruction. Building unique course plans to meet student's needs. Focusing on delivering quality material that is relevant to current working environments.

Developed team strategies around the required growth of the organization in the coming years. Build performance metrics, defined team expectations and deliverables based on project requests from various internal entities. Work hand in hand with development and systems resources to build strategies for new software and hardware migrations. Dealt directly with vendors on outsourced resources and deliverable expectations. Defined business requirements into technical documentation to map where and how business requests would be applicable to projects coming into the pipeline. Began technology revitalization project with a goal to over hall data tier and overall data base design and solution. Managed the migration of half of our production reporting environment out of Rackspace/physical hardware into a centrally controlled VMWare server farm. Developed and managed requirements to migrate encryption key algorithms from legacy 64 bit to 128 bit standard to meet PCI requirements. Built performance standards for internal team member's yearly goals. Developed release requirements for database applicable code.

Actively direct a team of database administrators providing database programming, administration and application support for Microsoft SQL Server, MySQL, PostgreSQL and Oracle. Provided architectural guidance for environment design, table structures, reporting solutions (SSRS, Tableau and Pentaho), and directed/prototyped Cloud base services such as AWS and Azure that would be used within the various business units within the organization. Mentored subordinates in policies and procedures of the organization and developed database centric policies around script execution, design, backup and recovery, and installation practices. Wrote security procedures to define access to production database servers and how the promotion of code would go within the data tier of the application. Managed the stream of incoming requested tasks and assigned them out to the team based on a weighted priority and skill sets available from team members. Developed internal back office tools utilizing SSRS as a framework for database maintenance that could be handed off to the client services teams within the organization. Built a centralized backup solution that coincided with the establishment of a full disaster recovery process. Designed and implemented a geographically dispersed AlwaysOn 5 node cluster that was the back end to of the business unit largest back end components. Built and deployed prototype staging environments utilizing PostgreSQL and AWS (Amazon Wed Services). Maintained Tableau reporting interface with PostgreSQL backend on Ubuntu Linux. Prototyped various No-SQL solutions in early phases of development of big data solutions (MongoDB and Cassandra). Developed, from the ground up, revitalization of overall data tier architecture in conjunction with development teams and infrastructure teams. Designed and lead a team of database administrators in the migration of a business unit into a new data center. Developed comprehensive security policies, disaster recovery policies and maintenance practices. Build enterprise database solutions utilizing MySQL and SQL Server to perform various roles in the environment from operational reporting to high impact OLTP utilizing various high availability technologies such as AlwaysOn, Clustering, and Mirroring. Maintained a 5 node AlwaysOn cluster, and designed the access procedures for code coming into the listener for accessing read only nodes. Maintained 2 production 2 node clusters maintaining mid-sized SQL Server implementations. Lead a team of 8 database administrators of various skill levels and provided leadership and guidance in daily operations as well as project priority based on the businesses ever changing mission. Developed year over performance plan to improve team mission and goals. Helped to facilitate a collaborative team, and expanded it beyond direct reports to external teams to facilitate interdepartmental communication and support. Built operational processes to support critical applications and core operational functions. Helped refine the service management process by building IT specific processes for application and script approval and sign-off prior to execution. Designed SSIS based ETL solution for data warehousing project being internally built for new product offerings.

Developed and maintained all facets of database life cycle, from patching, tuning, maintaining, developing and migrating. To strategic planning, expanding, and preparing for disaster recovery scenarios. Integral in defining the standardization to which all databases within the environment are maintained to and designed to handle both short term and long term growth within the company. Helped to develop our Business Intelligence solution from the ground up through both the building of test cases, but also through live demonstrations with interdepartmental communications. Develop key strategies used in the event of a business emergency to transition from our primary location to our secondary location in order to keep business going. Secure all points of entry into the database environment through the utilization of both Windows based authentication, SQL Server based authentication, Solar Winds system log monitoring, and error notifications. Further integrated production database systems into VMWare environments to support the business initiative to become more physically minimalistic. Maintained the production clustered environment, and further turned its XML heavy data loads. Additionally, I manage 3 database developers. I direct tasks for report writing, delegate tasks among the developers, track project progress, and help maintain overall efficacy of our SQL development group. Supported SSIS and C#.net middleware layer that transported screen cap data from AS400 systems into proprietary CRM solutions. Finally I help to define and maintain our development cycle for our Data warehousing/Business intelligence project through work with an external contractor, as well as designing the environment and data structures needed to facilitate the business need. Deployed a key database environment used as a part of the Low Income Energy Program for the state of Kansas. Additionally provided subject matter expertise on system related performance increases we could make in order to have a more optimized environment. Re-engineered the publisher subscriber database replication process to be more centrally controlled and defined. Established upgrade and patching procedures that were non-existent prior to my tenure. Developed long term migration plans for the environment as a whole. Tuned and optimized database environments within the VMWare substructure. Developed and optimized a high availability solution, in order to facilitate hands free fail overs in disaster scenarios.

Performed MSSQL functions as a consultant for the USDA that included the installation, configuration and maintenance associated with the MSSQL 2000, 2005 and 2008 environments present in the web farm. Created and provided feedback on proposed system changes. Reviewed developer scripts prior to system implementation and provided feedback on any major impacts that where caused by them. Established various maintenance plans to monitor system performance and to automate backups. Worked lightly within a clustered system, providing troubleshooting and general maintenance as well as a few minor installations as well as providing support for various other high availability options, from log shipping, and a few mirrored databases. Facilitated the transitions from MSSQL 2000 to 2005 and at a later date transitioned to MSSQL2008, by troubleshooting issues that arose as well as bringing existing databases online in the new environment. Most migrations were handled in a side by side installation a few were direct upgrades. Installed a SQL 2005 cluster utilizing a 2 node set up under VMWare, and then later transitioned it to a MSSQL mirror after finding some compatibility issues with clustered environments and VMWare. Migrated in house applications from SQL 2000 to SQL 2008. Regularly support software development, from requests for testing and development databases to pushing scripts created by development teams. Installed the hosting monitor application on thirty one instances of MSSQL 2000 and 2005 which provides feedback to the database administrator on the overall health and integrity of the instance and server. Transitioned fifteen plus databases from MSSQL 2000 to 2005 by doing a side by side upgrade so that the database could be tested on the new system without interfering with the existing databases until it was verified there where not software conflicts. Performed midrange client support by facilitating any database or instance changes needed to meet the requirements of the customer in a live environment. Restored a system post a patching failure that left the system in a state of inoperability due to high CPU taxing. Corrected this by installing a parallel instance of SQL so that the development team could still test on the fully patched version without affecting the performance of the primary system. Installed SQL 2005 into a VMware cluster and managed the performance under the virtual environment. Migrated 99% of the data center from SQL 2000 to SQL 2005, and 15% from SQL 2000/2005 to SQL 2008 Built and maintained SQL environments on VMWare ESX-I for quick turnaround clients. Created and maintained SQL mirror solutions for internal BMC Remedy environments.

Installed, configured and maintained MSSQL based servers in several system configurations, from Windows server 2000, to 2003 with a back bone built in SQL 2000 and, or 2005. Found ingenious ways to correct several table specific issues while building a more optimized data structure for communications within the database flow. Built system queries to find corrupted tables and attempted to restore the data from torn pages. Provided additional system integrity by establishing back up procedures using Symantec’s VERITAS and Backup Exec produces, additionally, when required, configured the site for differential backups based on the required up time of the site. Installed and maintained server and client hardware through maintenance action agreements with the client. Supplied phone based support when needed to correct client issues. Built several new client networks from the ground up starting with server construction all the way through to site implementation. Maintained an almost 100% server up time for 253 clients throughout the United States through various monitoring systems and fail safes: VERITAS, Database Mirroring and Secondary backups. Created and maintained an engineering database used to track the issue and reception of parts from customers and technicians. Repaired 2 databases that were not properly truncating their log files by changing the maintenance action plans, ultimately saving 10 years of medical research and preventing a full system failure.

Directed a twenty-member team in developing the most efficient database system for $25 million in tools and equipment that directly maintained the B-2 Stealth Bomber. Provided 24 hour on call support for the site as well as scheduled a 7 day a week rotation of work required on the database. Monitored all traffic to and from the network, to ensure that all data is maintained, and stored for future use. Provided a liaison service between new users when questions arose about the database and any issues that were going on within the system. Trained staff on new network features and SQL procedures to build a better understanding of system use and integrity. Monitored and helped optimize databases in their newly implemented tool allocation systems. Provided feedback to the development team on ways to improve the data structure and even areas to look at overhauling. Achieved 99.3% average database up time. Identified and corrected internal logic errors which saved $1.1 million and brought about faster, more reliable system. Played an integral role in creating and establishing one of the first fully functional SQL TAS databases in the Air Force.