SAI PAVAN DANDAMUDI

adygjq@r.postjobfree.com

615-***-****

SUMMARY

• Microsoft SQL DBA with 8+ years of an IT experience in Data Centre as a MS SQL DBA, Sybase.

• Extended expertise and experience in system uptime and availability, monitoring of Data centre environment, Systems & Databases.

• Worked on various platform such as Microsoft SQL Server 2008/2008R2/2012/2014/2016/2017/2019.

• Experience in Database Administration, Management using RDBMS such as SQL Server under WINDOWS environment.

• Special proficiency in SQL server concepts, Database Backups/log shipping, efficiently management of System performance, Job Scheduling, SLAs, Planned System shutdowns.

• Expertise in Installing, configuring, securing and managing SQL servers to ensure better performance and application availability.

• Ability to perform all Database Administration (DBA) tasks like performing database backups and recovery, monitoring logs and hard disk consumption growth rate etc.

• Able to configure jobs for routine activities and troubleshooting them in case of failures.

• Familiar with implementation strategies, and backup/recovery strategies.

• Creating database users, controlling access to SQL Server and making sure right people get access to right data and looking after the security issues.

• Performing the Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities.

• Experienced in advanced concepts of SQL server like Mirroring, Clustering, log shipping, Replication, Always-On

• Experience with cloud monitoring, alert metrics and disaster recovery

• Experience with user access management on cloud/sql server

• Expertise in implementing MS SQL Server security and database permissions.

• Configuring and Maintaining and troubleshooting the Database mirroring and also experience in Mirroring

• Configuring and Maintaining and troubleshooting the Database Log Shipping and also experience in Mirroring DR activities.

• Performing Database Refresh from Production to Stage environment.

• Experience with upgrades from SQL 2008 to 2012 and from 2012 to 2016, 2017,2019.

• Flexibility working in 24*7 environment.

• Good Experience in Performance tuning activities like verifying the slow running queries.

• Fragmentation and re Indexing the fragmented indexes.

• Experience in tools like Performance Monitor, Profiler, Import and Export wizard and Copy database wizard.

• Implemented TDE to protect sensitive data.

• Experience in Data warehouse techniques.

• Plan and Coordinated the administration of PostgreSQL databases to ensure accurate, appropriate and effective use of data including database definition and structure.

Used MySQL and Sybase for different SQL syntax and functions to be familiar with the specific syntax of each database system to write queries and perform database operations correctly.

TECHNICAL PROFICIENCY

Tools : BMC Remedy, Service now, SSIS, SSRS, SSMS, MS Tools.

Databases : SQL Server 2008, 2008-R2, 2012 & 2014, 2016,2017,2019.

Operating Systems : Windows Server 2008, 2005 & 2012,2016,2017,2019.

PROFESSIONAL EXPEREINCE

Dell, CO

Sr Database Admin Jan 2023 to July 2023

Involved in migration of the data to MSSQL Server 2000, 2005 & 2008, 2012, 2014, 2016, 2017, 2019engines from Microsoft Access.

Managed & worked on reports deployed on MSSQL Reporting Services Report Server.

Performed large batch jobs and tuning of SQL queries and database systems.

Created user accounts, roles and granting required access permissions and privileges to the users.

Partitioning and re-organization of table and indexes.

Creating custom MSSQL TSQL Scripts to alter data related to the respective servers and DBA’s.

Involved in designing logical and physical data models using Erwin.

Migrated databases from HP-UX to Sun Solaris, and Windows to Linux.

Regularly monitored servers, which includes Backup Job Monitoring and troubleshoot all the issues on regular basis.

Applied SQL Server service packs based on the errors and flaws that are found in the application.

Set up and configure database instances and environments.

Implement security measures during installation.

Resolved various performance issues and running DBCC commands, spotlight monitoring tools.

Administered the MS SQL Server by Creating User experience in SQL Server Database Administration/ Development using MS SQL Server Management Studio2012, 2008 R2, Management Studio 2005, Enterprise Manager 2000.

Proficiency in implementing CI/CD pipelines using tools like Azure DevOps, Jenkins, or GitLab CI/CD.

Implemented Database Mirroring and Log shipping with SQL server 2012, 2008 R2, 2005.

Strong knowledge in implementing different types of Replication Models such as Transaction, Snapshot and Merge in SQL Server 2012, SQL Server 2008R2, 2005in OLTP environments with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups. SQL Authentication.

Created maintenance plans Full Backups and Transaction Log Backups. Restored them whenever necessary, creating back up strategies and scheduling them for execution.

Hands on experience in troubleshooting high CPU utilization and memory utilization issues.

Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, log shipping issues, connectivity issues, security issues, index management.

Routine DBA activities like analysis of Space Availability, Backups (transaction log, complete) and Scheduled Jobs.

Monitored Clusters and troubleshot Clustering Issues, performing failovers.

Migrating and Syncing the Active Directory objects from on premises AD to Azure AD (Cloud) using the AAD Connect Server.

Configured SQL Server Reporting Server, Database Mails to send notification for alerts.

Create and manage database user accounts and roles.

Audit and track user activity within the database.

Handled requests for database creation/deletion, table creation/deletion, database reorganization, user management, permissions, backup/restore, job scheduling etc.

Provisioned new SQL server installation, configuration, optimization, performance tuning, clustering, high availability configuration (AOAG).

Provided SQL support to application to troubleshoot production issues.

Database maintenance like index rebuild/reorganize, data integrity verification, disk capacity planning, shrink/expand transaction logs.

Applied latest patches/service packs/cumulative updates to production SQL servers and monthly service restarts / AOAG failover – failback.

Monitor SQL health (deadlocks, long running queries, page life expectancy, parallelism, cost of threshold, memory, etc.)

SQL server version upgrades.

Handled ad-hoc request from Project Managers, Managing Consultants like generating report, executing queries, etc.

Database consolidations.

Alerts & notifications setup for SQL Servers.

Experience with Azure AD security controls, Azure AD Conditional Access, Privileged Identity Management, Intune, Cloud Access Security, and DLP.

Implemented the PowerShell scripts for the bulk modification for the Active Directory user and computer object attributes to facilitate synchronization to Azure AD.

Create and maintain database instances, schemas, and tablespaces.

Implemented downstream capture at the destination database using Oracle Streams.

Used tools like the ora2pg, mtk, AWS Data Migration Service (DMS), the Schema Conversion Tool (SCT) to migrate from oracle to postgres and from mssql to postgres on RDS.

Stored the db credentials in the AWS secrets manager.

Designed and developed transactions and persistence layers to save/retrieve/modify data for application functionalities using Django and PostgreSQL.

Configured and backed up database using RMAN, Hot backups, Cold backups and Logical backup.

Wrote ETL code in Python 3.x to clean and normalize unstructured data in legacy Postgres DB to accommodate schema updates in Redshift.

BMC // CA,USA

Sr SQL DBA

July 2021 to Dec 2022

• Involved in migration of the data to MSSQL Server 2000, 2005 & 2008, 2012, 2014, 2016, 2017, 2019engines from Microsoft Access.

• Managed & worked on reports deployed on MSSQL Reporting Services Report Server.

• Performed large batch jobs and tuning of SQL queries and database systems.

• Created user accounts, roles and granting required access permissions and privileges to the users.

• Partitioning and re-organization of table and indexes.

• Creating custom MSSQL TSQL Scripts to alter data related to the respective servers and DBA’s.

• Involved in designing logical and physical data models using Erwin.

• Migrated databases from HP-UX to Sun Solaris, and Windows to Linux.

• Regularly monitored servers, which includes Backup Job Monitoring and troubleshoot all the issues on regular basis.

• Implemented TDE to protect sensitive data.

• Experience in Data warehouse techniques

• Applied SQL Server service packs based on the errors and flaws that are found in the application.

• Resolved various performance issues and running DBCC commands, spotlight monitoring tools.

• Administered the MS SQL Server by Creating User experience in SQL Server Database Administration/ Development using MS SQL Server Management Studio2012, 2008 R2, Management Studio 2005, Enterprise Manager 2000.

• Used tools like the ora2pg, mtk, AWS Data Migration Service (DMS), the Schema Conversion Tool (SCT) to migrate from oracle to postgres and from mssql to postgres on RDS.

• Stored the db credentials in the AWS secrets manager.

• Designed and developed transactions and persistence layers to save/retrieve/modify data for application functionalities using Django and PostgreSQL.

• Configured and backed up database using RMAN, Hot backups, Cold backups and Logical backup.

• Wrote ETL code in Python 3.x to clean and normalize unstructured data in legacy Postgres DB to accommodate schema updates in Redshift.

• Implemented Database Mirroring and Log shipping with SQL server 2012, 2008 R2, 2005.

• Strong knowledge in implementing different types of Replication Models such as Transaction, Snapshot and Merge in SQL Server 2012, SQL Server 2008R2, 2005in OLTP environmentswith appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups. SQL Authentication.

• Created maintenance plans Full Backups and Transaction Log Backups. Restored them whenever necessary, creating back up strategies and scheduling them for execution.

• Hands on experience in troubleshooting high CPU utilization and memory utilization issues.

• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, log shipping issues, connectivity issues, security issues, index management.

• Routine DBA activities like analysis of Space Availability, Backups (transaction log, complete) and Scheduled Jobs.

• Monitored Clusters and troubleshot Clustering Issues, performing failovers.

• Configured SQL Server Reporting Server, Database Mails to send notification for alerts.

• Handled requests for database creation/deletion, table creation/deletion, database reorganization, user management, permissions, backup/restore, job scheduling etc.

• Provisioned new SQL server installation, configuration, optimization, performance tuning, clustering, high availability configuration (AOAG).

• Provided SQL support to application to troubleshoot production issues.

• Database maintenance like index rebuild/reorganize, data integrity verification, disk capacity planning, shrink/expand transaction logs.

• Applied latest patches/service packs/cumulative updates to production SQL servers and monthly service restarts / AOAG failover – failback.

• Monitor SQL health (deadlocks, long running queries, page life expectancy, parallelism, cost of threshold, memory, etc.)

• Hands-on experience on writing Python, PowerShell and Unix Shell (Bash, K, C) scripts for build and deployment automation.

• Experienced in advanced concepts of SQL server like Mirroring, Clustering, log shipping, Replication, Always-On.

Microland Limited, India

Associate DBA

Feb 2019 to July 2021

• Maintained and managed servers owned by the team. These servers are Windows 2008/2012 and SQL Server 2008/2008R2/2012/2014/2016/2017/2019.

• Installed, configured, managed, monitored and troubleshot SQL Server.

• Configured Mirroring, Replication, Log-shipping, Always-on and Clustering setup between database servers/instances.

• Monitored Clusters and troubleshot Clustering Issues, performing failovers.

• Troubleshot performance issues and tuning the database for better performance.

• Used Python to place data into JSON files for testing Django Websites and updating the content of files by using python scripts.

• Designed and developed transactions and persistence layers to save/retrieve/modify data for application functionalities using Django and PostgreSQL.

• Utilized Python Libraries like Boto3, numPY for AWS. Used Pandas library for statistical Analysis.Developed efficient Angular.js for client web based application.

• Used DynamoDB Stream to lambda using python.

• Ran SQL Server profiler to troubleshoot the data issues reported by users.

• Developed AWS Lambda python functions using S3 triggers to automate workflows.

• Monitored issues related to database locks/blockings/deadlocks.

• Configured SQL Server Reporting Server, Database Mails to send notification for alerts.

• Developed Spark Application by using Python (Pyspark).

• Increasing EBS backed volume storage capacity when the root volume is full using AWS EBS Volume feature.

• Created AWS Route53 to route traffic between different regions and Deployed and supported Memcache-AWS ElastiCache.

• AWS Oracle RDS, Aurora Postgres SQL, MySQL as well as experience managing a large Oracle database on EMC Storage in a data center environment.

• Configured Security group for EC2 Window and Linux instances and for puppet master and puppet agents.

• Performed Database Maintenance activities like rebuilding/reorganizing indexes update statistics, checking database integrity and clean up history on regular intervals.

• Monitored daily the Database Space Management parameters, allocating the required space to databases and suitably managing database growth.

• Enrolled users, controlled and monitoreduser access to the database, and maintaining system security.

• Troubleshot and resolved database integrity issues, performance issues, blocking and deadlocking issues, log shipping issues, connectivity issues, security issues, index management.

• Routine DBA activities like analysis of Space Availability, Backups (transaction log, complete) and Scheduled Jobs.

• Created Business Logic using Python to create Planning and Tracking functions.

• Experience in writing code in R and Python to manipulate data for data loads, extracts, statistical analysis, modeling, and data munging.

• Monitored Clusters and troubleshooting Clustering Issues, performing failovers.

• Configured SQL Server Reporting Server, Database Mails to send notification for alerts.

• Database re-organize and index re-organize.

• Handled requests like database creation/deletion, table creation/deletion, database reorganization, user management, permissions, backup/restore, job scheduling etc.

• Provisioned new SQL server installation, configuration, optimization, performance tuning, clustering, high availability configuration (AOAG).

• Provided SQL support to application to troubleshoot production issues.

• Database maintenance like index rebuild/reorganize, data integrity verification, disk capacity planning, shrink/expand transaction logs.

• Executed scripts in prod environment.

• Ensure that you have the necessary drivers or connectors for both MySQL and Sybase. These drivers enable your application or middleware to communicate with the respective databases.

Use SQL statements or an ETL tool to extract the required data from MySQL. You can retrieve the data you need based on your specific requirements and queries.

T- Systems, India

SQL DBA

August 2018 - Feb 2019

• Installed, configured, managed, monitored and troubleshot SQL Server.

• Set up Mirroring, Replication, Log-shipping, Always-on and Clustering setup between database servers.

• Troubleshot performance issues and tuned the database for better performance.

• Migrated data from MSSQL server to postgres on AWS.

• Ran SQL Server profiler to troubleshoot the data issues reported by users.

• Monitored issues related to database locks/blockings/deadlocks.

• Configured SQL Server Reporting Server, Database Mails to send notification for alerts.

• Monitored the Database Space Management parameters, allocating the required space to databases and suitably managing database growth.

• Created users and granted access.

• Monitored Clusters and troubleshooting Clustering Issues, performing failovers.

• Set up SQL Server Reporting Server, Database Mails to send notification for alerts.

• Database Indexing.

• Handled requests like database creation/deletion, table creation/deletion, database reorganization, user management, permissions, backup/restore, job scheduling etc.

• Provisioned new SQL server installation, configuration, optimization, performance tuning, clustering, high availability configuration (AOAG).

• Database reindex, reorganize l, creating tables.

• Configured the Transaction replication in production environment.

Depending on the differences in data types, schema, and syntax between MySQL and Sybase, you may need to transform the data to ensure compatibility. This could involve data type conversions, mapping MySQL-specific functions to their Sybase equivalents, and any necessary modifications to the data structure.

Once the data is transformed, you can load it into the Sybase database. This can be done using SQL statements or an ETL tool that supports Sybase.

BMC // CA, USA

Jr Software Engineer

August 2015 - August 2018

• Backup Job Monitoring and troubleshot all the issues on regular basis.

• Administered the MS SQL Server by Creating User experience in SQL Server Database Administration/ Development using MS SQL Server Management Studio2012, 2008 R2, Management Studio 2005, Enterprise Manager 2000.

• Created maintenance plans Full Backups and Transaction Log Backups. Restore them whenever necessary, creating back up strategies and scheduling them for execution.

• Troubleshot high CPU utilization and memory utilization issues.

• Resolved database integrity issues, performance issues, blocking and deadlocking issues, log shipping issues, connectivity issues, security issues, index management.

• Monitored issues related to database locks/blockings/deadlocks.

• Configured SQL Server Reporting Server, Database Mails to send notification for alerts.

• Handled requests like database creation/deletion, table creation/deletion, database reorganization, user management, permissions, backup/restore, job scheduling etc.

• Provisioned new SQL server installation, configuration, optimization, performance tuning, clustering, high availability configuration (AOAG).

• Provided SQL support to application to troubleshoot production issues.

• Monitored SQL health (deadlocks, long running queries, page life expectancy, parallelism, cost of threshold, memory, etc.

• Relativity database migrations / moved database from server to server.

• SQL server version upgrades.

If you need to keep the data in sync between MySQL and Sybase, you would need to implement a synchronization mechanism. This could involve periodic data updates or real-time replication depending on your requirements.

Visakhapatnam steel plant,

Trainer

Oct 2013- may 2014.

• Configured SQL Server Reporting Server, Database Mails to send notification for alerts.

• Handled requests like database creation/deletion, table creation/deletion, database reorganization, user management, permissions, backup/restore, job scheduling etc.

• Provisioned new SQL server installation, configuration, optimization, performance tuning, clustering, high availability configuration (AOAG).

• Taken backups and restored as needed.

• Provided SQL support to application to troubleshoot production issues.

Monitored SQL health (deadlocks, long running queries, page life expectancy, parallelism, cost of threshold, memory.

• Monitored issues related to database locks/blockings/deadlocks.

• Configured SQL Server Reporting Server, Database Mails to send notification for alerts.

• Handled requests like database creation/deletion, table creation/deletion, database reorganization, user management, permissions, backup/restore, job scheduling etc.

• Provisioned new SQL server installation, configuration, optimization, performance tuning, clustering, high availability configuration (AOAG).

• Provided SQL support to application to troubleshoot production issues.

• Monitored SQL health (deadlocks, long running queries, page life expectancy, parallelism, cost of threshold, memory.

• Relativity database migrations / moved database from server to server.

• SQL server version upgrades.

EDUCATION

Bachelors Of Technology – KL University (Vijayawada) – 2015.

Masters in computer science –SVU California 2017

Contact this candidate