SUMMARY

• I am a skilled SQL SERVER DBA professional with 6+ years of experience in SQL SERVER Database Administration, accomplished projects as per user requirements (SLA) and highly effective team - oriented able to collaborate with cross-functional personnel at all levels.

TECHNICAL SKILLS

RDBMS: Microsoft SQL Server 2005/2008/2012/2014/2016 Integration Service, Analysis Service,Reporting Service

SQL Server Technologies & Tools: Management Studio, SQL Profiler, ETL, Database Tuning Advisor (DTA)

Scripting Language: DOS/PowerShell & T-SQL

Case Tools: MS Office, MS Access, MS Excel, MS Outlook, MS Visio, MS Project.

ETL Tool: SSIS, SSRSPlatforms Windows, Linux, UNIX, Mac OS

PROFESSIONAL EXPERIENCE

SQL Server DBA

Confidential - Seattle, WA

Responsibilities:

• Installing, Configuring, Upgraded & migrating SQL Server /Applied Service Packs
• Migrating from versions to SQL SERVER 2014/2016
• Supporting both production environment and non-production environment
• Set up security and access profiles and procedures for a database system.
• Responsible for establishing and maintaining sound backup and recovery policies and procedures
• Designing and handling of Disaster recovery and high availability solutions (Failover Clustering, Alwayson, DB Mirroring, Log shipping and Replication)
• Responsible for capacity planning
• Performing trouble shooting and taking care of SQL Server Performance issues and errors using native tools like Profiler, Perfmon, system stored procedures, dynamic management views, custom stored procedures and third party tools
• Performing database maintenance
• Check the fragmentation and rebuild/ reorganize the indexes
• Automating & monitoring application related jobs and data replication activities
• Works in close coordination with different Teams (like Network Team and other application Teams) as well with Stakeholders and customers.
• Researches, investigates and give a recommendation of best practices for information and application services, and contribute to work plans.
• Writes documentation to a database including data standards, procedures and metadata.

SQL Server DBA

Confidential

Responsibilities:

• Standardizing SQL Server deployments on 21 Shipboard Data-Centers for upgrade to SQL 2012
• Creating Stored Procedures and SQL Agents jobs for rebuilding/reorganizing indexes, and file usage reports
• Automating and scheduling backups, index maintenance and file usage reporting
• Writing T-SQL scripts for migrating databases and security from SQL 2005 to SQL 2012
• Automating database maintenance and file cleanup tasks on 60 instances of SQL Server 2005/2008
• Migrating databases and security settings from test systems to four-node production SQL Server cluster
• Creating Database Maintenance plans, SQL Agent jobs, stored procedures and SSIS packages
• Provided system deployment diagrams, build instructions, operations and troubleshooting

SQL Server DBA

Confidential - St. Louis, MO

Responsibilities:

• Installed and configured MS SQL Server 2005, 2008 and 2012
• Experienced in SQL Server Migrations of various versions (2005, 2008, 2012)
• Experienced in both production environment and non-production environment support
• Configured and monitored the High availability solutions (SQL server Clustering,SQL server AlwaysOn, SQL server Database Mirroring,SQL server Log-Shipping andSQL server Replication Technologies)
• Analyzed and defined capacity planning for maintenance of the different Database Backups and Restore scenarios
• Set up linked servers and troubleshooting any issues related to ODBC connectivity.
• Configured Database maintenance plan as per the capacity planning and priority/severity of the Database and defining the required retention period for the backup storage.
• Provided appropriate access to the client so that they will have access to their respective needed server and database objects.
• Developed & maintained T-SQL scripts, utility jobs or implement needed software for database maintenance.
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
• Set up security and access profiles and procedures for database system administrators.
• Experienced to work in coordination with different Teams (like Network Team and other application Teams) as well with Stakeholders and customers.
• Experienced in monitoring and troubleshooting performance issues and optimized TSQL queries, stored procedures, functions etc.
• Experienced on Incident Management, Problem Management and Change Management
• Supported the research, investigations and recommendation of best practices for information and application services, and contribute to work plans.
• Check for the failed jobs, investigate the route cause and resolve the issue.
• Wrote documentation for a database including data standards, procedures and metadata.

SQL Server DBA

Confidential

Responsibilities:

• Installed, configured, monitored, upgraded, patched and tuned SQL Server 2005, 2008 and 2008R2 servers.
• Worked on troubleshooting the database issues and code issues.
• Experienced in both production environment and non-production environment support
• Performed Performance Tuning of the database, Stored Procedures and SQL queries.
• Designed and implemented Logical and physical database design upon requirement, also the patching the critical servers\instances.
• Involved in designing, configuring, monitoring and troubleshooting replication methodologies, log shipping and mirroring on critical databases and quickly resolving issues.
• Involved in Day-to-day activities such as Agent Jobs, Backups and Recovery, Services, Index, Database growth, health and consistency check, Data maintenance (partitioning, archiving and purging), issue\ problem maintenance and management, Incident management, Security maintenance etc.
• Monitor and tune all aspects of SQL Server infrastructure like Disk, CPU, Memory, SQL Code etc., by using Perfmon, Profiler, Dynamic management views
• Involved and implemented the Disaster recovery process to the critical databases and Instances as per MSFT standards.
• Configured SQL Server clustering and application services clustering.
• Managed internal and external MS SQL database security.
• Created stored procedures, functions, views, triggers, replication code, reports etc.
• Designed and implemented Operational automation tasks using SQL Server Job using DOS/PowerShell/T-SQL scripting
• Backup and restore the database using DOS/PowerShell/T-SQL scripting
• Developed & maintained using DOS/PowerShell/T-SQL scripts, utility jobs or implement needed software for database maintenance.
• Designed and developed SSIS packages for data extraction, data comparison and validation from multiple data sources and generate excel reports and SSRS reports.
• Involved and worked with the Change management, Release management for the smooth releases and of application\server\db installation or db patch\upgrade.
• Manage SQL Server security, application users, assist developers and users for access issues.
• Worked as a team player in resolving issues, documentation etc.
• Security Administration: a creation of users, Roles and granting appropriate privileges.