PROFESSIONAL SUMMARY:

• Eight+ years of IT experience in SQL Database Administration in Production, Staging, Testing, Design, and development & support of MS SQL Servers 2008 /2008R2, 2005, 2000 in both clustered and none clustered environment.
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2005/2000/2008/2012/2014.
• Experience in upgrading SQL Server from version 2005 to 2008R2 and 2008/2008R2 to 2014.
• Good experience with SQL Server 2005 and 2008 online Indexing and Recoveries features.
• Good experience with implementing Data Recovery solution, High Availability of database servers using Database mirroring and replications and Log Shipping.
• Experience in Data Migration Management.
• Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Created maintenance plans to perform index de - fragmentation, re-indexing and update the index statistics.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Experience in applying patches and service packs to keep the database at current patch level.
• Good experience with Analysis Services, Reporting Services, and SQL Server Clustering.

TECHNICAL SKILLS:

Operating Systems: Windows 2000/2003 Server, Windows 95/98/2003XP/NT/OS 2008/2012R2

Databases: MS SQL Server 2000/2005, 2008/2008R2, 2014 Oracle 11g

Languages: T-SQL, PL/SQL, SQL

SQL Server Tools: Management Studio, 2008/2008R2, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Log Shipping, Database Tuning Wizard, Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS).

Report Tools: MS Reporting Services, SQL Server Analysis Services

Data Migration: SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard

Database Modeling & Other Tools: Normalization, Entity Related Diagram, SQL Diag, SQL Trace and ETL.

PROFESSIONAL EXPERIENCE:

Confidential, Washington, D.C

SQL Server DBA

Responsibilities:

• Apply security service packs and implement DISA Mandated STIGS against both testing and production SQL instances.
• Configure Reports to run against back-end production Databases.
• Involved in capacity planning, sizing and database growth projections. Fine tune databases to increase performance.
• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
• Setup backup and restoration jobs for development and QA environments.
• Troubleshoot all reports related errors for customers. Conduct SQL DBA daily health checks against the Databases to avoid downtime.
• Maintains the disaster recovery solution at the remote site for the production databases using Cluster.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.

Confidential, College Park, MD

SQL Server DBA

Responsibilities:

• Microsoft SQL Server Database Migration from MS SQL 2008R2 to MS SQL 2014.
• Creation and scheduling of Maintenance plans (database and log backups and cleanups), Created tables and performed data imports and restores for successful migration.
• Managing data resource by shrinking data files and log files.
• Good Knowledge of using SSRS (SQL Server Reporting Services).
• Installed and configured SQL Server in SQL Server 2008/2008R2 using Window Server 2008R2.
• Performed Production Support and On-call duties.
• Monitored the database instances daily to make sure they are up and running. Troubleshoot if they are not online.
• Recreate database and view indexes to improve query performance.
• Restoring corrupted databases from backup locations to production or staging servers.
• Migrating databases from production Servers to Development Servers for Testing.
• Implementing Tuning tools, such as Database Tuning Advisor to improve performance.
• Setting database mirroring for High Availability Solutions.
• Installed and configured SQL Server in SQL Server 2008/2008R2 using Window Server 2008R2.
• Performed server installation and configurations for SQL Server 2005 and SQL Server 2008.
• Performed installation of SQL Server Service Packs.
• Upgraded databases from SQL Server 2000 to SQL Server 2005 and 2008.
• Involved in capacity planning, sizing and database growth projections.
• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
• Setup backup and restoration jobs for development and QA environments.
• Created transactional replication for the reporting applications.
• Implemented disaster recovery solution at the remote site for the production databases using Log Shipping.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.

Confidential

SQL Server DBA

Responsibilities:

• Migrated databases (schemas) from oracle 11g to MS SQL 2008R2 using Microsoft SQL Server Migration Assistant (MSSMA).
• Mitigated Defense Information System Agency (DISA) Security Technical Information Guard (STIG) ACAS and appdetective findings.
• Responsible for mitigating, documenting all the MS related findings. Database support, troubleshooting, planning and migration. Resource planning and coordination for application migrations with project managers, application and web app teams.
• Monitoring of database size and disk space in Production, Staging & Development environments.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training.
• Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers.
• Failover cluster testing and resolution on HP servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Creation and scheduling of Maintenance plans (database and log backups and cleanups), Created tables and performed data imports and restores for successful migration.
• Managing data resource by shrinking data files and log files.
• Good Knowledge of using SSRS (SQL Server Reporting Services).
• Installed and configured SQL Server Cluster server in SQL Server 2008/2008R2 using Window Servers.
• Performed Production support and on Call duties.
• Implement DISA rules and write a Database Security Plan.
• Documented upgrading procedures from Oracle to SQL Server.
• Created monitoring scripts to alert for production issues and scheduled monitoring tasks on the database.
• Migrated Databases from Oracle to SQL Server 2008/2008R2.

Environment: Active Directory, VM Ware, MS Cluster, SQL Server 2005, 2008 and 2008R2, Windows 2003/2008/2008 R2 Servers, T-SQL, Oracle Oracle 11g

Confidential

SQL Server DBA

Responsibilities:

• Performed server installation and configurations for SQL Server 2005 and SQL Server 2008. Migrating data from a bare metal server to a cluster environment.
• Performed installation of SQL Server Service Packs.
• Upgraded databases from SQL Server 2000 to SQL Server 2005 and 2008.
• Involved in capacity planning, sizing and database growth projections.
• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
• Setup backup and restoration jobs for development and QA environments.
• Created transactional replication for the reporting applications.
• Implemented disaster recovery solution at the remote site for the production databases using Log Shipping and mirroring.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Used System monitors to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions.
• Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions.
• Responsible for Database support, troubleshooting, planning and migration. Resource planning and coordination for application migrations with project managers, application and web app teams. Project involved guidance and adherence to standardized procedures for planned data center consolidation for worldwide centers using in-house corporate and third party applications based on SQL 2000 in upgrade project to SQL 2005.
• Monitoring of database size and disk space in Production, Staging & Development environments.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training.
• Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Failover cluster testing and resolution on HP servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.

Environment: SQL Server 2000, SQL Server 2005, 2008 and 2008R2, Windows 2000/2003 Servers, T-SQL, Oracle PL/SQL, Oracle 11g.