SUMMARY:

• A professional SQL DBA with 5+ years of industry experience in Administration, Installations,
• Configuration and optimization, tuning system performance, monitoring SQL server agent jobs, troubleshooting and resolving related issues. A DBA with experience in designing, optimizing and maintaining High Availability solutions such as SQL SERVER Failover Clustering, Database mirroring, AlwaysOn Availability Groups, Database Replication and Transaction log shipping. An expect with an in depth understanding of Disaster Recovery Strategies (Backup and Restore with Focus on RPO, RTO and Retention Periods), Indexing and Statistics, Database Migrations, SQL Server Profiler and Database Engine Tuning Advisor, Server - side traces, SSRS and SSIS.

TECHNICAL SKILLS:

• Installing and Upgrading SQL Server
• Backing up and Restoring SQL databases
• Configuration and Optimization of SQL Server
• Performance Tuning and Monitoring
• SQL Server HA Solutions (Replication, Mirroring, Log Shipping and Always On AG)
• SQL Servers (2005, 2008, 2008R2 and 2012, 2014 and 2016)
• Windows servers: 2003, 2003r2, 2008, 2008r2, 2012 and 2016
• 3rd party Monitoring Tools: SolarWinds (Database Performance Analyzer)
• Migrations

EXPERIENCE:

SQL Server DBA

Confidential, ATLANTA-GA

• Ensures database servers meet PepsiCo/ATL Gatorade standards by utilizing automated support tools.
• Works with PepsiCo staff, Affiliated Merchandizers and other State Agencies to get to the root of problems that involve SQL servers
• Managing and Troubleshooting of Database Security issues for the company Staff Database Administrators and Users; (granting and revoking database access for the company Database Administrators and users).
• Resolves SQL Server incident tickets within defined SLA’s
• Monitor and tracks tickets and Change Requests to ensure high quality customer service.
• Configuration and Management of SQL clusters within the COV domain.
• Teaming with architectural team in building, configuring, optimizing and deployment of new servers.
• Works with clients, Microsoft and other staff when technical issues arise, opening Microsoft cases on as needed basis.
• Performs In-place and Parallel upgrades of SQL Server as well as patches, service packs and cumulative updates on servers as and when needed.
• Manage and monitor installed systems and SQL infrastructure for the company and its affiliated State Agencies
• Migration of databases and dependencies to New platforms of PepsiCo
• Install, configure, test and maintain operating systems, application software and system management tools
• Work with data services group in providing a 24/7 coverage for the environment.
• Creating documentations for future references.
• Performance of routine preventative maintenance on database servers, diagnose and propose solutions to recurring server issues
• Works with Team to remediate database issues and monitor database performance
• Works with Project Management to execute new projects.

SQL Server DBA

Confidential

• Configuration and Management of SQL clusters.
• Management of Database Security.
• Teaming with architectural team in building, configuring, optimizing and deployment of new servers.
• Troubleshoot and Resolve database Integrity issues, Performance issues, blocking, deadlocking,
• Detect and Troubleshoot Server Related CPU, Memory, I/O, Disk space and Other Resource contention Issues.
• Granting and revoking database access to users.
• Creating documentations for future references.
• Teaming with all Information systems teams and various internal departments to aid in the development process of systems and procedures.
• Performance of routine preventative maintenance on database servers, diagnose and propose solutions to recurring server issues
• Install, configure, test and maintain operating systems, application software and system management tools
• Migrating databases and dependencies to New platforms
• Work with data services group in providing a 24/7 coverage for the environment.

SQL Server DBA

Confidential

• Part of a team that monitor a SQL server environment of about 75 servers.
• Part of a team that designs, builds and maintains SQL servers in conformity to business needs.
• Troubleshooting and resolving User database connectivity issues.
• Performance tuning of Server and database issues.
• Creating and managing indexes and statistics for performance boosting.
• Setting up High Availability Solutions like database mirroring, Log shipping, Replication, AlwaysOn
• Responsible for the data Storage and Security.
• Manage and monitor all installed systems and infrastructure.
• Perform Patches on all SQL database servers.
• Upgraded 2008R2 Versions to 2012 enterprise.
• Upgraded lower versions (2000, 2005, and 2008) to higher versions (2008r2, 2012 and 2014).
• In Charge of Disaster Recovery (Backup and Restore) Strategy
• Routine Migration Responsibilities.
• Using third Party tools such as Idera SQL diagnostic Manager in monitoring Server health.
• Implementing Operational Automation tasks.
• Ensuring that there is proper backup support in place for all production databases.
• Disk capacity planning
• Database planning, designing and testing.
• Server and Database Auditing
• Troubleshooting SQL Codes, Stored Procs., Functions, Table-load related issues, triggers etc.
• Provision of trend analysis to Management to enable them to make Informed Decisions regarding Resource Management.