SUMMARY

• Over 6 years of experience in Database Administration, System Analysis, Design, development, and Support of MS SQL Server 2019/2016/2014/2012/2008 R2 in Production, Test, Development, Stage Environments.
• Expertise in Database Administration on Production Servers with Server Configuration, Performance Tuning, and maintenance with outstanding troubleshooting capabilities
• Experience on High Availability /Disaster Recovery (HADR) solutions; Failover Clusters and Always on Availability Groups, Replication, Log Shipping and Mirroring
• Experience in Upgrade/Migration
• Experienced in Backup and Recovery, query Optimization
• Experienced in monitoring the health and performance of SQL servers as well as home grown applications using SQL Server native tools and several other third - party solutions
• Created various SSIS Packages to serve company needs
• Expert in using Extended Events/PerfMon/SQL Profiler/ Scripts and other third-party tools to resolve bottlenecks, dead locks, and slow running queries
• Responsible for securing SQL Server, user management, assigning permissions and roles.
• Strong System Administration background in Windows.
• Expert in problem solving, analysis and conflict resolutions

TECHNICAL SKILLS

Databases: MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, MS Access

Cloud: AWS, AZURE

ETL Tools: MS SQL Server Integration Services (SSIS)

Reporting Tools: MS SQL Server Reporting Services (SSRS), Report builder

Programming Languages: T-SQL, PowerShell, CMD

Operating Systems: Windows 2016/2012server

Other Tools: MS SQL Server Migration Assistant (SSMA) and ODBC/DB Link, MS Always On, MS Azure, MS SQL Server Clustering and Performance Tuning, Red Gate, Service Desk, Jira, Splunk

PROFESSIONAL EXPERIENCE

Azure Synapse\SQL DBA

Confidential

Responsibilities:

• Provide Customer support
• Provide technical support to client to manage health Data
• Database refresh
• Migration from on premises to Azure
• Implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications.
• Ensuring operational readiness (security, health, and performance), executing data loads in development and production environment
• Capable of working independently and collaboratively.
• Verify that the design and execution of database server configuration, and maintenance fulfill SLA goals.
• Responsible for creating, modifying, and managing tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
• Administer, maintain, develop, and recommend policies and procedures for ensuring the security and integrity of the company’s databases and systems
• Extensive experience setting up and troubleshooting SQL Server Availability Groups.
• Experience Agile Scrum Project management methodology.
• Proactively monitored the production database(s) and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization
• Managing SQL Server Database both on-perm and Azure

Azure Database Administrator

Responsibilities:

• Assist team with Migration from on-premises to on Azure, IaaS.
• Managing SQL Server Databases both on-prem and Azure using (IaaS) for production environment.
• Database refreshes and cloning using Delphix and native SQL backup and restore.
• Hands on experience with schemas, loading data, data retrieval and reporting.
• Azure managed databases (SQL server, MySQL, Cosmos DB)
• Root Cause Analysis (RCA) of Incident, Monitoring of Production, Dev, and Test on-prem and Azure environment of SQL Server and analyzed the root cause and factors impacted database performance.
• Involve with database upgrades, patching, and migrations in windows environments.
• Working in Database related day-to-day Activities.
• Create SQL Server logins, database users, assigning permissions, moving security between servers, and implementing database encryption TDE, dynamic data masking (DDM).
• Creating Alerts for growth and usage of mission critical database files
• Creating SOP’s and performing monitoring task with team.
• Ensuring solution and operations reliability.
• Designing and planning a cloud solution architecture
• Working in an Automation team that delivers a high availability service.
• Excellent in Performance Tuning including monitoring, troubleshooting, and optimizing performance of the databases as well as high availability service.
• 24 X 7 Production Database on Call Support.

Confidential, Dallas, TX

Responsibilities:

• Proficiency in SQL server database Backup/Recovery, Refresh, Maintenance, Export/Import/ Performance monitoring/tuning, Security management, SQL Programming, with work experience on different version on SQL server database example 2008,2012,2014,2016,2019
• Configure and maintained High Availability (HADR) solutions, Failover Clusters and Always on Availability Groups, Replication, Log Shipping and Mirroring.
• Applying patches and Perform database upgrades/migrations
• Troubleshoot complex systems to identify bottlenecks (SQL, IO, hardware, query related, etc.); Resolve database related issues.
• Provide production support in time sensitive situations in addition to providing support for multiple high-profile applications/projects.
• T/SQL, SQL, DML, DDL and DCL Experience, Manage connectivity to other RDBMS.
• Assist clients with fine tuning indexing and tune queries.
• Generate performance and efficiency metrics and offer expert advice to clients.
• Perform regular security and access reviews.
• Azure/SQL Server DBA Experience in an IaaS/PaaS environment
• Implementing and maintaining data security protocols for sensitive data & PII.
• Azure/SQL Server monitoring and performance tuning, installation, administration, and maintenance
• Working of Agile methodology.
• Perform day-to-day operations (includes monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and tuning, etc.).
• Effectively prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision.
• Drive results and leverage past experiences to improve the environment and related processes.
• Stay current on technology and industry standards; work with leadership to develop strategic plans and roadmaps.

Database Administrator

Responsibilities:

• Maintain the integrity, security, and availability of database(s)
• Establish and maintain database user accounts
• Administer, maintain, and Implement policies and procedures for ensuring the security and integrity of the database
• Organize and format data for efficient query and storage processes
• Provide server administration with a variety of database products that include MySQL, SQL Server,
• Perform disaster recovery, performance analysis and tuning, index maintenance, and monitoring
• Develop policies and procedures for ensuring the security and integrity of the database(s)
• Perform database and software life-cycle activities to ensure highest level of system performance and availability
• Support data modeling activities by way of prototype database implementations
• Direct the monitoring, administrating, and implementing performance on database systems as well as database performance optimization, developing/changing database indexes, redesigning database structure and reloading data into a database
• Direct the installation of database management systems, databases, tables, and views
• Directs the administration and use of current and emerging database tools, strategies, and technologies

Database Administrator

Responsibilities:

• tuning of database objects and server to ensure efficient data retrieval.
• Scheduled jobs to automate different tasks such as monitoring database health, disk space, job alerts, index monitoring, stats monitoring. Experience with the creation of backup scripts and the various backup strategies
• Rebuild, reorganize Indexes, and update statistics at regular intervals for superior performance.
• Monitored Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
• Document the process and create To-do lists for installation, upgrade, and migration steps.
• Applied strong notion of recovery time object (RTO) recovery point object (RPO) mechanism for database management as (Full, Differential, and T-Log) backup and recovery procedures on all environments.
• Create SQL Server logins, database users, assigning permissions, moving security between servers, and implementing database encryption TDE, dynamic data masking (DDM).
• Trouble shoot and resolve database connectivity issues
• Follow Change Management processes to implement database configuration changes
• Proactively monitor and respond to MSSQL database Alerts.
• Proactively address technical production issues.