PROFESSIONAL EXPERIENCE

SQL Server Production DBA

Confidential

Responsibilities:

• Tracking and resolving performance database issues related to Production, QA and Development Healthcare VA Government environment
• Build out New Table Schema and Performance related Indexing rebuild
• Performance Tuned Databases with fragmented or orphaned
• Created Support plans for QA, DEV, and Prod environments
• Support Backups with Actifo Backups Support Program

SQL Server Production DBA

Confidential

Responsibilities:

• Worked within our team to support DOD Tricare Dental Program with was under the Confidential /Optum Technology Support Contract
• Tracking and resolving all database issues related to Production, QA and Development Healthcare Government environments
• Writing PowerShell scripts for monitoring and reporting on the health of all the databases and systems in within the Gov’t Confidential Organization;
• Used CyberArk to access Work Bench Servers
• HPSA/HPSM for Server diagnostic and Support with SQL 2014
• Data Warehousing Design and Support

Production DBA

Confidential

Responsibilities:

• Tracking and resolving all database issues related to Production, QA and Development environments
• Installed and upgraded the database server(s) and application tools
• Maintenance, retrieval, and scheduling of archived data
• Generating reports through direct querying of all active databases, as needed.
• Creating, maintaining, and updating database documentation

Production DBA

Confidential

Responsibilities:

• DUP Mon Server Installation and Upgrades Script (SQL Server 2012)
• RDS Web Migration to SCATDB01 Script (From SQL 2000 to SQL 2008)
• Mesa BBAnalytic Script (SQL Server 2012)
• Canvas ILM Logons Script (SQL Server 2012)
• MetaSys Server Installation and Upgrades (SQL Server 2012)
• HelpDeskWorldWide DB Server Upgrades (SQL Server 2012)
• BIADB Server Upgrades (SQL Server 2008 - 2012)
• RDS FTSE Created Database Migration from (SQL 2005) to (SQL Server 2012)
• STCATDB1 Database created and maintained (SQL Server 2012)
• ILM Login Creation and Schema Creation (SQL Server 2012)
• Prepared, and participated in quarterly DR tests with our IT and application support teams.

Production/Developer DBA

Confidential

Responsibilities:

• Installed and maintained SQL Server databases, including: ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Updated database by reviewing, planning, testing, installing database security patches and service packs.
• Designed, documented, and promoted security "best practices", policies, standards and protocols.
• Worked in Active/Active, Active / Passive Cluster environment as a High availability solution
• Data Warehousing Design and Support

Production DBA

Confidential

Responsibilities:

• Updated database by reviewing, planning, testing, installing database security patches and service packs.
• Designed, documented, and promoted security "best practices", policies, standards and protocols.
• Migrated application code and objects from development/test environments to Production.
• Worked on Development, Network, SAN, and Systems teams to perform application and database warehousing and Production tuning
• Checked Database Health by using DBCC Commands and DMVS
• Data Warehousing Design and Support

LEAD DBA

Confidential

Responsibilities:

• Led a team of offshore DBAs in installing and maintaining Boardwalk approved application software and systems that integrate with Boardwalk's database systems.
• Designed, documented, and promoted security "best practices", policies, standards and protocols.
• Worked with development and systems teams to perform application and database tuning
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Migrated Databases from SQL Server 2008 to SQL Server 2012
• Data Warehousing Design and Support

Production DBA

Confidential

Responsibilities:

• Automate the rebaselining of DBs in the non-Production environments
• Tested applications for performance, data integrity and validation issues
• Database Backup Procedures, Restoration Procedures, and Disaster Recovery procedures
• Testing and implemented procedures.
• Worked daily with executive level staff I.E. Business Analyst, Vendors, Directors, and Project Managers for drive out Software Life Cycles
• Optimize DB logical and physical schema
• Data Warehousing Design and Support

Production DBA

Confidential

Responsibilities:

• SQL Server DBA Production Support - Health Care Domain 24*7*365
• Designed and Implemented Database Backup Restore Strategy
• Planned Database Maintenance & Administrative Tasks
• Configuring Replication / Data Synchronization
• Tuning SQL Server Performance
• Optimize DB logical and physical schema
• Data Warehousing Design and Life Cycle Support

Production DBA

Confidential

Responsibilities:

• SQL Server DBA Production Support - E-Commerce Domain
• Designed and Implemented Database Backup Restore Strategy
• Auditing for SQL Server Security
• Configuring Replication / Data Synchronization
• Implementing and Maintaining Log Shipping Database Clustering
• Monitoring with DDL Triggers SQL Server Profiler PowerShell Event Notifications
• Data Warehousing Design and Life Cycle Support

Production DBA

Confidential

Responsibilities:

• Designed, documented, and promoted security "best practices", policies, standards and protocols.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development Life-Cycle.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in
• Optimize DB interaction with OS, file system, storage, and network
• Data Warehousing Design and Life Cycle Support

Production DBA

Confidential

Responsibilities:

• Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.
• Migrating Databases from SQL Server 2005 to SQL Server 2008
• Worked with table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Installed and configured more than 2GB RAM in SQL Server 2005
• Performed the migration of SQL Server 2000 to SQL Server 2005
• Configured the servers on 32 bit and 64 bit clustered and standalone server environments
• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Data Warehousing Design and Life Cycle Support