SUMMARY

• Over 7 years of database management experience in SQL server database administration and development in all versions between SQL Server 2008 and 2019,IT professional wif hands - on experience configuring, maintaining, monitoring, and administering Microsoft SQL Server databases and Maintenance, Performance Tuning, Security, various database recovery techniques on. Some of my expertise and highlights include:
• Installing, Configuring & Upgrading Microsoft SQL Server 2008/2008R 2/2 /2017/2019.
• I has Implemented & Managed Database High Availability group as well backup strategies for disaster recovery.
• I has extensive experience in Database Performance Tuning & Query Optimization
• Experience in configuring & administering the standby servers through Log shipping and mirroring.
• Installing, configuring, administering of MSSQL server and securing production servers.
• Perform and oversee day-to-day database activities related to check SQL server error logs, backups, restores, and integrity checks, optimizations, refreshing re indexing, performance tuning and troubleshooting.
• Using T-SQL for creating databases, tables, stored procedures, triggers, indices and other objects wifin the databases based on requirements from developers.
• Management of Database Space, Growth Monitoring of Data & Transaction log files.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Troubleshoot and resolve issues relating to database integrity, database performance (deadlock, locking, blocking, etc.,) server performance (CPU, memory, I/O).
• Experience & Responsible for multiple migrations and upgrades (In place and side by side) from SQL Server to SQL Server 2008\2008R2\2012\2014, 2016/2019.
• Experience in configuring backup strategy and in case of database failure, to recovery the database point in time.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Extensively worked on Dynamic Management views (DMVs) and Dynamic Management Functions (DMFs).
• Created maintenance plans to perform Index De-Fragmentation, Re-Indexing and update the Index Statistics.
• Experience in Service Packs, Security Patches & Hot fixes install and management (schedule-install).
• Experience in generating Reports (SSRS) in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools.
• Responsible for installing, configuring SQL server cluster and troubleshooting issues wif SQL Cluster.
• Extensively involved in Replication and implemented Snapshot, Merge and Transactional Replications.
• Migration to Azure SQL DB, Managed instance, Azure VM.
• Expertise in Database Administration on Production environments wif server configuration, performance tuning and maintenance wif outstanding troubleshooting techniques and capabilities.
• Applied service packs and cumulative updates on a production server after proper testing in non-production server.

TECHNICAL SKILLS

SQL Server Versions: MSSQL Server 2019,2017, 2016, 2014, 2012, 2008r2, 2008

Native Tools: SSMS, SSDT, BIDS, SSCM, BCP, SQLCMD

Languages: T-SQ, SQL & Power shell

BI & Modeling Tool: SSIS, SSRS & SSAS

Operating System: Windows Server 2016/2012R2/2008

Third Party Tools: RedGate, Service now, Spot light, Fog light

PROFESSIONAL EXPERIENCE

SQL DBA

Confidential - Houston, Texas

Responsibilities:

• Installed, Configured, Administered, maintained and utilize policies and procedures for ensuring the integrity, validity and consistency of the database.
• Microsoft SQL Server Administration and Maintenance
• Work wif the development team to resolve bug-fixes and assist in relevant testing through various environments
• Conduct performance reviews and contribute to performance feedback for all levels of staff
• Monitor SQL server and database performance and proactively address potential performance issues
• Review, design, and develop data models in conjunction wif application development teams
• Extensive knowledge of PowerShell
• Provide solutions for database issues including capacity, redundancy, replication, and performance
• Assist in developing strategic technical/architectural plans for the SQL database and web applications infrastructure
• Help establish, publish and monitor adherence to security standards for access to the databases
• Day to day production support including checking daily logs, backup/recovery procedures, disaster recovery, periodic maintenance
• Design, implement, maintain security administration reports as required
• Developed strategies for data acquisitions, archive recovery, implementation of data access and table maintenance of SQL databases.
• Participated in capacity planning and review database changes for system impact.
• Developed and created the new database objects including tables,views, index, stored procedures and functions, advanced queries.
• Developed and implemented database performance monitoring processes and analyze monitoring data for performance optimization opportunities.
• Experienced and proficiency in setting up backup recovery strategies supporting high availability and disaster recovery.
• Performedbackup using backup compression and data compression in SQL server databases on clustered environment.
• Maintained referential, domain and column integrity using constraints.
• Design, write or re-engineer database scripts to enhance functionality of system
• Work closely wif other departments in the definition, implementation and deployment of new initiatives
• Provide 24/7 support for various database servers. Respond in a timely manner to all alerts. Assist related MTS groups in debugging production issues
• Fulfill user requests in a timely manner. Adhere to change control processes; ensure that proper authorization is supplied for changes
• Expert-level knowledge in Microsoft SQL Server database administration, and all related products (Reporting Services, Analysis Services, Integration Services)
• Expert-level knowledge of high availability solutions (such as clustering) and database systems architectural design
• Ability to define and implement solutions wif minimal guidance.
• Responsible for training and mentoring lower level DBA teams.

SQL DBA

Confidential, Houston, TX

Responsibilities:

• Involved in installation, upgrade, configuration and migration of SQL server in clustered and non-clustered production environments of SQL server.
• Implementation of new instances and databases,
• Performing performance tuning/query optimization, and supporting day to day operations
• Provide third level technical support for SQL database administration, applications and databases services
• Assist in developing strategic technical/architectural plans for the SQL database and web applications infrastructure
• Escalate calls to development team, product managers and third party vendors as required
• Assist in developing and implementing a workable support model for SQL database/app environment
• Communicate changes to IT Services and internal client via Change Request and user notification applications
• Ability to troubleshoot, analyze and provide solutions to complex issues wifin an enterprise environment
• Advanced knowledge of SQL Architecture or design
• SQL Consolidation planning
• SQL Health & Risk Review SQL Discovery
• SQL upgrades
• Installation & Configurations
• Responsible for ensuring our SOX compliance software and internal auditing systems are up to date.
• SQL Server Performance Tuning and Query optimization- SQL Profiler, Query Execution plan, indexing strategies.
• SQL Server High Availability and Disaster Recovery solutions- Always On Availability Groups, Failover Clustering, Mirroring, Log Shipping, Replication
• Creating Stored Proc 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 2008 to SQL 2012
• Automating database maintenance and file cleanup tasks on 60 instances of SQL Server 2008/2012
• 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
• Supporting the projects during the UAT, SAT and troubleshooting the data issues from database end.
• Using ticketing tools like remedy and Service Now to support day to day activities.
• Performed Database Refresh tasks from Production to Development and Staging Servers.
• Involved in Performance Tuning of the SQL Server for Web based Production and Development environments.
• Documented the security standards and roles depending on Development, and Production environments.
• Part of our on call support team every other month for 7 days.

SQL DBA

Confidential, Austin, Texas

Responsibilities:

• Upgraded/migration Database from SQL Server from lower to higher versions.
• Implemented techniques and performed special tasks wifin the context of database performance and tuning. Created, upgraded, maintained, while working closely and coordinating wif hardware, network, and OS administrators.
• Installed & configured database software, associated database tools and performance monitoring software.
• Experienced on both production environment and non-production environment support
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify that database changes perform wifout adverse consequences.
• Estimated disk storage requirements for database software, database files & database administration needs.
• Participated in meetings impacting databases physical design.
• Automated the SQL Server Job
• Developed, tested & implemented a robust database backup and recovery strategy
• Provided appropriate access to client so that they will has access to their respective needed server and database objects.
• Managing Databases and SQL Server Instance Security by using Active Directory.
• Resolve blockings, locks, and deadlocks using Activity Monitor, DMV’s and SQL profiler.
• Update statistics using query analyzer, enterprise manager on the existing servers.
• Schedule and scripting DBCC commands to run daily and weekly basis in order to identify the health and performance of SQL server databases.
• Monitored SQL server logs to ensure whether thebackup operations,batch commands and scriptshave completed successfully
• Responsible for migrating virtual machines live from one server toa bother using VMware’s Vmotion.