| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate PAVITHRA YADAV
SENIOR SQL DATABASE ADMINISTRATOR
Email: EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLEPROFESSIONAL SUMMARYIT professional with over 7+ years of experience in MS SQL DBA support, specializing in SQL Server installation, configuration, patching, upgrades, and administration in both clustered and non-clustered environments. Proven track record of managing and troubleshooting SQL Server AWS migrations, high availability setups, and performance tuning in 24x7 production environments. Demonstrated expertise in utilizing various SQL Server tools and cloud technologies, with a strong emphasis on OLTP & OLAP, Backup and recovery strategies, security and disaster recovery.Seasoned Oracle Database Administrator with distinguished experience in managing and maintaining sophisticated Oracle RDS DBMS implementations. Demonstrated proficiency in database architecture, performance optimization, backup and recovery strategies, and cloud infrastructure management, particularly within AWS environments. Adept at delivering high-quality, robust database solutions that align with business objectives and enhance operational efficiency.
Extensive experience in SQL Server installation and configuration in complex environments. Proficient in managing high-availability solutions such as Always On, clustering, Data Modelling, replication, mirroring, and log shipping. Expertise in performance tuning, query optimization, and database maintenance. Skilled in developing and implementing robust backup and recovery strategies. Adept at ensuring database security and compliance with industry standards. Hands-on experience with SQL Server AWS migrations and cloud-based solutions. Strong collaborative skills, working closely with cross-functional teams to achieve business goals. Proven ability to handle 24x7 production support and resolve critical issues promptly. Thorough understanding of SQL Server tools and technologies, ensuring efficient database management. Extensive experience in installing, configuring, administering, and maintaining mission- critical databases across various Oracle versions, including Oracle 11g, 12c, and 19c.
Hands-on experience in configuring and managing AWS infrastructure components such as Security Groups, Route 53, and VPC to ensure seamless communication and secure connections.
Skilled in utilizing leading third-party database tools like SQL Developer, OEM Toolkit, and Spotlight to optimize database management, performance monitoring, and system efficiency
Strong experience with TSQL programming skills and in-depth knowledge of SQL (DDL, DML, and DCL), and PLSQL. Familiarity with scheduling database tasks such as jobs, alerts, emails, and notifications within SQL Server, adept at managing large-scale production databases and troubleshooting issues as they arise. Experience in architecting, deploying, and optimizing scalable and cost-effective solutions on Azure cloud services, with a strong background in Azure networking.
Hands-on experience in Azure SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Azure SQL Managed Instance, Azure Virtual Network, Azure Storage, Azure Key Vault, Azure Data Factory. Designed, coded, and implemented pipelines to manage data workflows in the cloud. Experience in scheduling and executing backups and restores, log Shipping and maintenance plans utilizing both Native & Third-party tools such as Lite Speed5.0 and Redgate SQL Backup. Demonstrated ability to ensure data integrity, minimize downtime, and optimize database performance through strategic backup and recovery strategies. Leveraged Jenkins, GitHub, and Terraform for efficient database management and automation.
Maintained and tracked AWS RDS databases, tracking query throughput and resource performance. Developed dynamic dashboards and reports using Power BI and SSRS (SQL Server Reporting Services) to provide city officials with actionable insights. Utilized SQL Sentry to identify and resolve performance bottlenecks. Scheduled and executed comprehensive backup and recovery procedures using Veeam Backup and CommVault to safeguard data integrity and availability. Utilized BMC Remedy for incident management and resolution tracking.TECHNICAL SKILLSSkills:Description:LanguagesTSQL, Microsoft SQL ServerDBMSMS SQL Server 2019/2017/2016/2014/2012/2008R2/2008/2005/2000Oracle, Oracle RDS, SQL Developer, OEM ToolkitCloud TechnologiesAWS, IBM Cloud, Microsoft AzureSQL Server ToolsSQL Server Management Studio (SSMS), Enterprise Manager, SQL Server Configuration Manager (SSCM), Database Tuning Advisor (DTA), Profiler, Query Analyzer, , Export Import Wizard, Perfmon, SSIS, SSRS, SSAS, Distributed Transaction Services(DTS), Transparent Data Encryption (TDE), Change Data Capture (CDC)SQL Server SkillsPerformance Tuning, Backups, Recovery, Replications, Deadlock Resolution, Port Change, Setup Database Mail, ActiveX Script Proxy, Operating System Proxy using SQL, Configured Distributed Transaction Coordinator (DTC), Database Mirroring, Triggers, Policies, Shrink, SnapshotAWS ServicesEC2, RDS, S3, Lambda, CloudFormation, IAM, CloudWatch, VPC, DMS, Route 53Operating SystemsWindows Server 2019/2016/2012/2008/2003/2000Development & Automation Tools:Jenkins, Github, TerraformBackup ToolsTivoli Data Protection, CommVault, LiteSpeed, Veeam BackupMonitoring ToolsSQL Sentry, Nimsoft, Nagios, RedgateTicketing ToolsBMC Remedy, JIRA, ServiceNowOther ToolsOLAP, OLTP, Red Gate SQL Compare, Linux, Git, CyberArk, Tableau, PowerBIPROFESSIONAL EXPERIENCEClient: City of Newark, New Jersey Department of Transportation
Title: Senior SQL Server DBA New Jersey Smart City Project (February 2022 Present)Description: Providing comprehensive DBA support for production, development, and test environments. Played a key role in the design, implementation, and management of an innovative Smart Traffic Management System for the City of Newark. This project aimed to optimize traffic flow, reduce congestion, and enhance public safety through real-time data integration and advanced analytics.Responsibilities: Architected a high-availability SQL Server database to support real-time traffic data collection from various sensors and IoT devices deployed across the city. Developed and maintained ETL(Extract, Transform, Load) processes along with OLAP & OLTP to integrate data from traffic cameras, road sensors, and GPS devices using SSIS (SQL Server Integration Services). Conducted extensive performance tuning and optimization of complex SQL queries to ensure real-time data processing and reporting. Implemented data partitioning and indexing strategies to handle the high volume of incoming traffic data efficiently. Ensured data security by implementing advanced encryption methods, role-based access controls, and regular security audits. Adhered to state and federal regulations regarding data privacy and protection, including compliance with the General Data Protection Regulation (GDPR). Developed a comprehensive backup and disaster recovery plan tailored to the city s needs, minimizing downtime and ensuring data integrity. Performed regular database backups, and integrity checks, and conducted periodic disaster recovery tests. Created and optimized SQL queries and stored procedures for real-time traffic analysis and reporting. Leveraged Jenkins, GitHub, and Terraform for efficient database management and automation.
Developed dynamic dashboards and reports using Power BI and SSRS (SQL Server Reporting Services) to provide city officials with actionable insights. Worked closely with urban planners, traffic engineers, and IT teams to gather requirements and deliver a system that met the city's strategic goals. Provided training sessions and technical support to city personnel on using the database and reporting tools effectively. Successfully integrated over 500,000 data points daily from various IoT devices into the centralized database. Reduced traffic congestion by 20% through real-time data analytics and optimization of traffic signals. Enhanced public safety by providing real-time alerts and actionable insights to city officials, leading to quicker response times.Environment: SQL Server 2019, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), TSQL, Power BI, Azure SQL Database, Github, Terraform, JenkinsClient: AmeriHealth, NJ (August 2019 January 2022)Title: Senior SQL Server DBA
Description: Provided extensive database support and maintenance for AmeriHealth, which encompassed reviewing SQL procedures, ensuring data accuracy, and implementing backup and disaster recovery strategies. Designed and maintained database structures, implemented high availability solutions, and automated database tasks to enhance performance and reliability. Developed and documented database specifications, collaborated with stakeholders, and optimized database architecture for speed, accessibility, and scalability. Managed and optimized SQL Server environments, ensuring high availability and performance.
Responsibilities: Installed and configured SQL Server clusters and standalone environments. Configured Database Mail, scheduled database maintenance tasks, and sent email notifications to operators for task success or failure, aiding in resolving emergencies such as server shutdown or database errors. Verified the database transactional replication system and SQL Server Availability group s availability and performance, making sure they have enough resources set aside to provide high resilience and speed. Orchestrated the management and maintenance of all production and non-production Oracle databases across multiple complex RDS environments. Maintained and tracked AWS RDS databases, tracking query throughput and resource performance. Managed migrations from SQL Server 2008 to newer versions in various environments. Configured Always-On availability groups and monitored database performance. Developed automated maintenance tasks including backups, integrity verification, indexing, and statistics updates. Provided daily support and troubleshooting, maintaining development and staging environments. Implemented security measures and conducted regular audits. Ensured compliance with organizational policies and industry standards. Developed and implemented backup and recovery procedures. Managed and optimized ETL processes to integrate data from diverse sources, ensuring data consistency and reliability. Automated routine database tasks using PowerShell, enhancing efficiency and reducing manual workload. Implemented scripting solutions for automated maintenance, monitoring, and deployment activities. Implemented and managed comprehensive backup and recovery procedures using LiteSpeed to ensure data integrity and availability. Developed and tested disaster recovery plans, leveraging solutions such as VMware and AWS for minimal data loss. Utilized tools and scripts to streamline data transformation and loading. Tuned databases using Profiler, Perfmon, DMVs, and DTA, significantly reducing deadlocks and improving query performance. Employed SQL Sentry and Tivoli for proactive monitoring and real-time alerting of database performance and health. Utilized BMC Remedy for incident management and resolution tracking. Reviewed and optimized database architecture to enhance speed, accessibility, and scalability. Designed and maintained efficient database structures to support business applications and reporting needs.Environment: Oracle RDS, SQL Server 2016, 2014, 2012, 2008R2; Windows Server, VMware, SQL Server on AWS, SSCM, DTA, Profiler, SQL Sentry, PowerShell, Tivoli, BMC Remedy, LiteSpeed.Client: Karur Vysya Bank (June 2017 July 2019)Title: MS SQL DBA
Description: At KVB Bank, provided comprehensive database support, including analyzing processes, optimizing SQL Server databases, and developing custom functionality. Worked with cross-functional teams to integrate systems, manage reporting solutions, and ensure data integrity and security. Leveraged expertise in SQL, SSRS, Tableau, Power BI, and cloud platforms such as Azure and AWS to deliver high-quality solutions aligned with business needs.Facilitated migrations and managed high-availability SQL Server environments.
Responsibilities: Managed and monitored SQL Server instances (2014, 2012, 2008R2) in high-availability environments. Installed, configured, and maintained SQL Server on AWS, providing robust connectivity solutions. Conducted regular performance tuning and optimization using tools like DTA and SQL Profiler. Utilized SQL Sentry to identify and resolve performance bottlenecks. Developed and executed disaster recovery plans, leveraging cloud solutions such as AWS and Azure. Maintained database security by implementing encryption, role-based access controls, and regular security audits. Ensured compliance with industry standards and regulations through regular audits and policy enforcement. Designed and managed ETL procedures using SSIS to integrate data from multiple sources. Worked with cross-functional teams to integrate systems, ensuring seamless data flow and consistency. Developed custom reports and dashboards using SSRS, Tableau, and Power BI to support business decision-making. Managed reporting solutions and provided actionable insights to stakeholders. Provided support to application developers and other stakeholders, resolving database-related issues promptly. Collaborated with cross-functional teams to deliver high-quality solutions aligned with business needs. Facilitated database migrations to newer SQL Server versions and cloud platforms, ensuring minimal downtime and data consistency. Planned and executed database consolidation efforts to streamline operations. Utilized ServiceNow for incident management and SQL Sentry for real-time monitoring and alerting. Conducted regular maintenance tasks to ensure optimal database performance and reliability. Created and maintained detailed documentation of database environments, configurations, and procedures. Provided comprehensive reports on database performance and maintenance activities to stakeholders. Integrated on-premises SQL Server environments with cloud platforms such as Azure and AWS, enhancing scalability and disaster recovery capabilities. Utilized cloud services to optimize database performance and reduce costs. Conducted capacity planning and database sizing exercises to forecast future growth and ensure infrastructure scalability. Implemented partitioning strategies and other scalability techniques to efficiently manage large volumes of data.Environment: SQL Server 2014, 2012, 2008R2; Windows Server, SSIS, SSRS, SQL Server on AWS, SSCM, DTA, Profiler, SQL Sentry, ServiceNow, Tableau, PowerBI, ETL procedures, AWS and AzureClient: Enspire INDIA (April 2016 May 2017)Title: MS SQL DBA
Description: Supported and responsible for managing and monitoring production servers, performing regular performance tuning, and ensuring database security and compliance. My role also involved providing connectivity solutions, conducting backup and recovery procedures, and collaborating with cross-functional teams to deliver high-quality solutions. Additionally, I supported application developers, resolved database issues, and assisted in migrating databases to newer SQL Server versions.Responsibilities: Managed and monitored production SQL Server instances (2000, 2005, 2008, 2008R2) ensuring high availability and optimal performance. Installed, configured, and maintained SQL Server instances across various environments, providing robust connectivity and integration solutions. Conducted regular performance tuning and optimization of SQL queries, indexes, and database configurations to maintain efficient operations. Implemented automated maintenance tasks for index rebuilding, statistics updates, and integrity checks to enhance database performance. Scheduled and executed comprehensive backup and recovery procedures using Veeam Backup and CommVault to safeguard data integrity and availability. Developed and tested disaster recovery plans, ensuring minimal data loss and quick recovery in the event of failures. Maintained database security by implementing data encryption, role-based access controls, and regular security audits to comply with industry standards and regulations. Deployed Transparent Data Encryption (TDE) and SSL/TLS encryption to protect data at rest and in transit. Utilized monitoring tools such as Nimsoft to proactively monitor database performance, identify potential issues, and implement preventive measures. Set up alerting systems to notify of performance issues, security breaches, and other critical events in real time. Provided comprehensive support to application developers, assisting in troubleshooting and resolving database-related issues promptly. Collaborated with cross-functional teams, including network administrators, system engineers, and application developers, to deliver high-quality solutions and improve overall system performance. Assisted in the migration of databases to newer SQL Server versions, ensuring smooth transitions, minimal downtime, and data consistency. Planned and executed database consolidation efforts, reducing overhead and simplifying management. Created and maintained detailed documentation of database environments, configurations, and procedures, facilitating knowledge sharing and compliance. Developed custom reports and dashboards using SQL Server Reporting Services (SSRS) to provide stakeholders with actionable insights. Conducted capacity planning and database sizing exercises to forecast future growth and ensure infrastructure scalability. Implemented partitioning strategies and other scalability techniques to manage large volumes of data efficiently. Configured SQL Server Failover Clustering and Log Shipping to ensure high availability and disaster recovery for critical databases. Regularly tested high-availability configurations and disaster recovery plans to ensure readiness and reliability. Assisted in the migration of databases to newer SQL Server versions, ensuring smooth transitions and minimal downtime.Environment: SQL Server 2008R2, 2008, 2005, 2000; Windows Server, Nimsoft, Veeam Backup, CommVault.EDUCATIONMaster s in Management Information Systems, Concentration: Business Analytics at Saint Peter s University, Jersey, New Jersey
|
