Data Services Manager Resume Profile
Database management
DBA with solid experience maintaining a multiple database environment with high availability and performance of MS SQL Server databases supporting web-based customer facing and back-office applications. DBA skills include:
MS SQL Server 2008, 2008r2, 2012 Performance Tuning Monitoring Data Modeling | SSMS, SSIS Data Analysis Database-Backed Web Development |
Professional Experience
Confidential SQL Server DBA |
- As Database Administrator I manage multiple MS SQL Server databases up to 1.5TB. Enhance database performance and handle performance tuning. Configure and deploy new database servers.
- Maintain Development, QA, Staging and Production Database environments supporting and automating release rollouts for application development teams.
- Responsible for database backups in line with the company's disaster recovery strategy and retention policy.
- Maintain multiple 2-node SQL cluster environments. Often testing fail over during maintenance windows for upgrades. Maintain log shipping within the environment.
- Continued to develop and test the disaster recovery plan for production databases, delivering solution that guaranteed recovery, performance and high availability
- Maintain company's performance standards using trend analysis and performance monitoring tools such as Spotlight to proactively project resource requirements.
- As Database Developer I am responsible for driving and guiding the high level architecture, conceptual/detailed design, development and release production management of databases to support the business solutions. I work with developers, technical leads, project managers and program managers to establish a repeatable product design and build for our customers.
- Project: Web based application to handle special payment arrangements through dental offices
- Design of complex relational databases to support this business application in a cloud-based environment including some NoSQL.
- Work on an agile team that successfully delivered a usable product to the client in 4 months. Client was able to process 500k of payments within the first 2 months of operation.
- Optimization of developers' TSQL queries, stored procedures and functions. Responsible for database performance tuning using MS SQL trace tools, query plans and Red Gate SQL Developer toolkit.
- Design the database architecture to support encryption in order to meet HIPAA compliance standards.
- Develop supporting application and process documentation to client and internal application standards through an ongoing data dictionary and wiki.
Confidential Data Services Manager |
Manage MS SQL Server database administration assignments for interactive marketing. Enhance database performance and handle performance tuning.
Key responsibilities:
- Served as DBA in the upgrade of our production servers from MS SQL Server 2000 to MS SQL Server 2008. Created and maintained the upgrade plan and coordinated the resources. Upgrade was successfully completed without the need for rollback.
- Managed the database schema and responsible for approving and implementing any changes.
- Created several procedures using T SQL to maintain proper data quality.
- Designed and managed ETL processes to meet the daily data needs in an ever evolving interactive marketing environment.
- Developed stored procedures to be used by programmers/developers to access database in several web-based applications.
- Developed and tested disaster-recovery plan for production databases, delivering solution that guaranteed recovery performance and high availability.
- Managed the data services team which included junior DBAs and developers
Confidential Programmer Consultant II |
Programmer/analyst on large web-based application development projects across the US.
Key projects:
Tools: Visual Basic, Crystal Reports
- Project: Developed a client/server application that was a Central Customer Repository CCR. The CCR supported the company's sales and analysis by providing all customer information in one place. Denver, CO
- Project: Developed modules that facilitated a data migration project for a large media company. Modules had to handle capture and enhancement and quality checks, written in Visual Basic merge purge, data. Princeton, NJ