SQL Database Administrator Resume BOWIE MD - Hire IT People

SUMMARY:

Over 5 years’ experience in Managing and administering Large Databases, System Analysis, Support of MS SQL Server 2005/2008/2008 R 2/2012/2014/2016. In production, Test, Development, Replication and Cluster Server Environments.
Solid experience on High availability (Always - On) SQL Server solutions, including Replication Models (Snapshot/Transactional), Mirroring, HADR Setup Configuration
Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2008/2008R2, SQL Server 2012, SQL Server 2014 and SQL 2016
Experience in Disaster Recovery Planning, Execution and Testing at remote site.
Experience in using SQL Server Tools like Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler, Database Tuning Advisor, and SQL Query Analyzer.
Expert in setting up maintenance plans, creating jobs, database mail.
Expert in E.T.L TOOLS (S.S.I.S, B.C.P, Import & Export Wizard).
Setting Up Transparent Data Encryption.
Implementation of SQL Logins, Roles and Authentication Modes.
Experience in Upgrade/Migration of MS SQL Server, and from, 2016.
Good Knowledge of System Administration 2008/2012 R2 Server
Experienced in Creating Technical Documentations and Process archiving and Change Management.
Experience in Supporting and Maintaining Large Database and Troubleshooting their problems.
Excellent analytical, communication and interpersonal skills.

PROFESSIONAL EXPERIENCE:

Confidential, BOWIE MD

SQL Database Administrator

Responsibilities:

I was responsible for installing, configuring and maintaining SQL failover clustering for Production Environment.
Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various users.
Maintained Database Located in MD4 and LD4.
Weekly Refreshing Database for analysis and Developers Update
Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
Installed and administered 2-Node cluster Active /Passive on Microsoft Windows Server
Securing Database with Transparent Data Encryption TDE
Rebuilding the indexes at regular intervals for better performance
Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
Monitored and modified Performance using execution plans and Index tuning.
Perform SQL Server service pack and Windows Service pack upgrades.
Working with customers on Application rollouts and server migrations.
Extensively worked on Enterprise Manager for managing the database.
Troubleshoot performance problems and fine-tuning of databases.

Environment: SQL Server 2008, SQL Server 2012, SQL 2014, SQL 2016, windows server 2012 R2

Confidential

SQL Database Administrator

Implemented Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
Performed Regular Backup and Maintenance Jobs across the 15 Database Managed
Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
Installed and administered 3-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
Rebuilding / Monitoring the indexes at regular intervals for better performance.
Recovering the databases from backup indisasters.ImplementingPoint-In-Time Recovery solutions.
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
Involved in Source Data Analysis, analysis and designing mappings for data extraction using log shipping.
Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).

Environment: SQL Server 2008, SQL Server 2012, SQL 2014, SQL 2016, windows server 2012 R2