Sql Server Database Administrator
Resume:
MS SQL Server DBA
Rajani K Chowdari **********@*****.***
SUMMARY
SQL Server Database Administrator with 8 years of experience managing and optimizing SQL Server environments. Proven expertise in production system support, database migrations, upgrades, and team leadership. Adept at improving system performance, reducing licensing costs, and ensuring high availability for mission-critical systems. Azure-900 certified with strong team management skills.
Technical Skills
Databases: Server 2022/2019/2016/2014/2012/2008 R2 /2008 /2005/ MS-SQL Server 7.0
SQL Server Tools
Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyser, Export & Import (DTS),PSSDIAG, Extended events.
Operating System
Windows 2000 Advanced Server/Server 2012/Server 2008/Server 2003/Professional/ NT 4.0, Win XP Prof/Standard, Win 98.
Reporting Tools
MS SQL Server Reporting Services
AWeb Servers
IIS 5 and 6
Tools
MS outlook, Commvault, Tivoli and TDP backup tools, Service Now ticketing tool, truesight monitoring tool, Foglight monitoring tool .
PROFESSIONAL EXPERIENCE:
NTTDATA, PLANO Jan 2018 – Current
SQL Server DBA
NTT DATA Corporation is a multinational system integration company and a partially owned subsidiary of Nippon Telegraph and Telephone. Japan Telegraph and Telephone Public Corporation, a predecessor of NTT, started Data Communications business in 1967.
Responsibilities:
Install and configure SQL Server 2014/2016/2019 on WINDOWS 2012/2016 Servers in Clustered and Standalone environments to support Production, QA, and Development environments.
Experience managing an operational database team, managing resources, and setting goals.
Led a team with many successful projects and provided efficient strategies to consolidate database servers and decommission several servers reducing licensing costs.
Training and assisting team members with installing and configuring SQL Server 2014/2016/2019/2022 Servers in Clustered and Standalone environments, 2-node cluster setup with always-on and Patch Management.
Manage team members to provide prod support, 24 x7 support, and on-call management.
As a team we completed many migration projects and successfully upgraded 2008 and SQL Server 2012 instances to 2014 and 2016 and 2016 to 2019 and eliminate servers that reached the End of support date.
Respond to alerts, support the Team to troubleshoot the root cause, and take a proactive approach to problems such as CPU, Memory, blocking, deadlock issues, and query performance issues.
Expertise in escalating incidents to other team functions (Network teams, storage teams, and application teams) and vendors (such as Microsoft, Quest…) as needed to ensure timely resolution.
Provide high emphasis on Dev Code DBA skills to troubleshoot production incidents. Troubleshoot ticket incidents and resolve and Handle prod escalations outside of normal business hours.
Create and debug complex stored procedures and triggers
Ensure SQL environment backup, recovery, refresh, and disaster recovery infrastructure remain in compliance through ongoing monitoring, testing, and problem resolution.
Migrated On-Premises SQL Server databases to Azure SQL Database, Used Microsoft Data Migration Assistant to Migrate SQL Server to an Azure SQL Database managed instance (Azure infrastructure as a service (IaaS).
Understanding of ETL (Extract, Transform, and Load) to troubleshoot and resolve file-loading failures
Strong production experience in managing MS SQL Server 2012/2014/2016/2019/2022 clustered environment / High Availability for mission-critical systems.
Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning, and Data Normalization. Expertise in capacity planning, performance tuning and Optimization, disaster recovery (DR), and troubleshooting performance issues.
Involved in the development of automated daily, weekly, and monthly system maintenance tasks such as database backup, integrity verification, replication verification, and indexing updates. Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduling DTS/SSIS Packages.
Worked for various Clients like Medstar, Avmed, Humana, Tetnet and BCBS.
RealPage, Richardson Feb 2016 – Dec 2017
SQL Server DBA
Realpage is a leading provider of property management software solutions for the multifamily, commercial, single-family and vacation rental housing industries. Our solutions enable property owners and managers to increase revenues and reduce operating costs. Realpage products assist approximately 12,000 customers with managing the operations of over 11 million rental housing units and over 200 million square feet of commercial office, retail, industrial and mixed-use properties.
Responsibilities:
SQL Server DBA support in a production environment that stresses incident ownership and resolving SQL issues within the SQL 2012, 2016 hosted on a Windows environment.
Installed SQL Server 2012 / 2014/2016 standalone and clusters on Windows 2012\2016 advanced servers, applied latest services packs and security fixes. Configured always-on for several environments.
Upgraded / Migrated SQL Server 2008 databases to SQL Server 2012 / SQL Server 2014 /SQL Server 2016.
Standard DBA functions including database backups; restoring databases; analysis space, performance monitoring; database problem determination and resolution.
Maintenance of existing databases; implementation and maintenance of security and database monitoring activities.
Responsible for tickets assigned to SQL DBA and resolving the tickets within SLA.
Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Rules and Defaults.
Provide dedicated support to all Production, QA & Development MS SQL Server Environments.
Worked in Performance Tuning and Query Optimization using advanced options like extended events and Management data warehouse.
Worked on Log shipping, Replication, and Clustering strategies and resolving issues.
Involved in database and log backups & restoration, backup strategies, and scheduling.
Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creating user groups, and granting privileges to users and groups.
Performance Monitoring of Production Databases as and when required.
Implementing the Data Changes, Scripts, and new releases onto the Production Servers.
Managing Security issues in Production environments.
Worked with different teams like firewall and storage teams to fix issues.
Provide On-Call support and 24x7 production support.
AIG, Fort Worth, TX Feb 2014 – Feb 2016
SQL Server DBA.
American International Group, Inc. (AIG) is a leading international insurance organization serving customers in more than 100 countries and jurisdictions. AIG companies serve commercial, institutional, and individual customers through one of the most extensive worldwide property-casualty networks of any insurer. In addition, AIG companies are leading providers of life insurance and retirement services in the United States.
Responsibilities:
Installed SQL Server 2012 / 2014 standalone and clusters on Windows 2012 advanced servers, applied services packs and security fixes.
Upgraded / Migrated SQL Server 2008 databases to SQL Server 2012 / SQL Server 2014.
Standard DBA functions including: database backups; restore databases; analyze space, performance monitoring; database problem determination and resolution;
Maintenance of existing databases; implementation and maintenance of security and database monitoring activities.
Provide fanatical support to the clients for their hosting solutions.
Responsible for tickets assigned to SQL DBA and resolving the tickets within SLA.
Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Rules and Defaults.
Involved in writing the documentation of the support guide.
Worked in Performance Tuning and Query Optimization using advanced options like extended events and Management data warehouse.
Create and analyze indexes.
Assist Developers in writing and tuning procedures.
Involved in fixing SSIS services issues.
Involved in annual DR strategies involving Always-on, Log shipping, Replication, and Clustering.
Day-to-day administration of multiple mission-critical database servers in development, testing, and production environments.
Involved in database and log backups & restoration, backup strategies, scheduling local backups, and using backup tools.
Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creating AD user groups, and granting privileges to users and groups.
Implementing and troubleshooting snapshot & transactional Replication.
Performance Monitoring of Production Databases as and when required.
Implementing the Data Changes, Scripts, and new releases onto the Production Servers.
Managing Security issues in Production environments.
Documenting the Standard Operating Procedures and best practices and maintaining Operational Handbooks.
Technical team lead for a major project of the company.
Provide dedicated support to all Production, QA & Development MS SQL Server Environments and on-call support.
Contact this candidate