Home

kalyan - mssql dba

[email protected]

Location: Middle River, Maryland, USA

Relocation: any

Visa: h1b

G Kalyan Reddy MSSQL Server DBA 804-859-4635 Experience Summary: Having 13 years of IT experience with 11+ years of experience as a MSSQL Server DBA with reputed organizations Managed Azure SQL databases SQL db, managed instances and installed SQL db in in azure vm s, including provisioning, monitoring, and performance tuning activities. Implemented high availability and disaster recovery solutions using Azure technologies such as Geo-replication and Azure Backup. Automated routine tasks and processes using Azure Automation and PowerShell scripting to improve efficiency and reduce manual effort. Designed and implemented Azure SQL Database security measures, including role-based access control and encryption. Conducted database migrations from on-premises environments to Azure SQL Database, ensuring minimal downtime and data loss. Worked closely with Azure support services to troubleshoot technical issues and optimize database performance. Experience with SSIS, SSRS Experience in Installation and Configuration in different versions like SQL Server 2008/R2 ,2012 ,2014,2016 ,2017 ,2019 and 2022 Proficient in handling SQL server DBA activities related to HA features Log shipping, replication, mirroring, clustering and Always-On. Excellent skills in database administration, backup and recovery activities, applying updates, troubleshooting and upgrades. Experience in applying the service packs and cumulative packs to fix the Vulnerabilities. Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups. Experience in implementing SQL Server security and Object permissions like maintaining creation of users, configuring permissions and assigning roles to users. Performed VMware vMotion to move VM s in between ESXi hosts Experience in Cognos BI tools Query studio & Report Studio Using Report Studio created conditional formatting reports Developed different types of reports like list, drill through reports and prompt reports. Published packages to Cognos server. Technical Skills: RDBMS/DBMS: MS SQL Server 2022/2019/2017/ 2016/2014/2012/2008R2/2008/2005, SSIS, SSRS Database Technologies/Tools: SQL, T-SQL, Data Transformation Services (DTS), OLAP. Reporting Tools: Cognos, Excel. Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7, windows X Public Cloud Azure SQL DBA, Azure Administrator, Vmware Education: Masters in Computer Science Master of computer applications (MCA) from Kakatiya university, Telangana, India Bachelors in computer Science Bachelor of computers science (B.Sc computers) from Osmania University, Hyderabad Professional Experience: Kaiser Permanente (KP) , USA December 2021 to till date MSSQL Server DBA Responsibilities: Managed Azure SQL databases, including provisioning, monitoring, and performance tuning activities. Implemented high availability and disaster recovery solutions using Azure technologies such as Geo-replication and Azure Backup. Automated routine tasks and processes using Azure Automation and PowerShell scripting to improve efficiency and reduce manual effort. Designed and implemented Azure SQL Database security measures, including role-based access control and encryption. Conducted database migrations from on-premises environments to Azure SQL Database, ensuring minimal downtime and data loss. Worked closely with Azure support services to troubleshoot technical issues and optimize database performance. Experience in performance tuning like working with indexes rebuild indexes, DB integrity checks, updating statistics Experience in working with query execution plans identifying the root cause for the query slowness issues Good communication, interpersonal & problem-solving skills with analytical, decision making and leadership capabilities to enhance organizational objectives. Having good onsite experience & Client interaction Environment: Azure SQLDB, SQL Server 206/2017/2019,2022, T SQL NXP Semiconductors, Chennai May 2016 November 2021 MSSQL Server DBA Responsibilities: Working closely with application development and support team to understand their requirements and provide timely solutions, for both current and future projects. Creating the change requests & service request for DB maintenance activities. Identify the Db errors using event logs and SQL logs to troubleshoot. Establishing weekly maintenance plans such as Rebuilding indexes, Update statistics and monthly maintenance plans such as Db backups, clean up history etc. to run the databases efficiently. Experience in applying the service packs and cumulative packs to fix the Vulnerabilities. Configuring replication, mirroring, SQL clusters and SQL Always ON Availability. Installation and configuration of MS SQL Server 2005, 2008,2012,2014,2016,2017 and 2019 Migrating databases from SQL Obsolete versions (2005,2008,2008R2 ) to latest versions. Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blockings. Maintained & Monitored DB Alerts mails/Schedule to make smooth DB process. Database performance monitoring and tuning when required as per application and business requirements (Rebuild index, update statistics) Backup and restoring the databases using EMC Networker backup tool. DB migration and DB version upgradation (In place & side by side) of servers and database. Good communication, interpersonal & problem-solving skills with analytical, decision making and leadership capabilities to enhance organizational objectives. Having good onsite experience & Client interaction Environment: MSSQL Server 2008/2012/2014/2016/2017/2019,T-SQL,MSExcel,Windows server 2008/2012/2016 Electricity Northwest,Hyderabad September 2013 Jan 2016 MSSQL Server DBA Responsibilities: Installation, configuration and applying Service packs of MS SQL Servers 2012, 2008R2/2008/2005 on production and development environments. Good Experience in configuring Log shipping, Mirroring. Having good knowledge on SQL server architecture, Clustering, Always on High Availability and replication. Experience in Database Backup/Restore, implementing Recovery Models and maintenance activities. Implementing SQL Server Security and database permissions. Creating schemas and assigning object level permissions. Monitoring Database, checking error logs, checking the log file size and free space in the data drives. Troubleshooting the LOG file Space, Disk space issues on Production servers Scheduling and Monitoring jobs using SQL Server Agent as per the business requirement. Resolving Blocking and enabling trace to capture the Dead lock Issues. Maintained Database Authentication Modes, creation of users, configuring permissions and assigning roles to users. Acknowledging the tickets and maintaining 100% SLA. Attending the Daily calls. Providing 24X7 support for production servers. Good communication, interpersonal & problem-solving skills with analytical, decision making and leadership capabilities to enhance organizational objectives. Having good onsite experience & Client interaction Environment: MSSQL Server 2005/2008/2012/2014,T-SQL,MSExcel,Windows server 2003/2008 CSC Health care, Noida September 2012 June 2013 Wintel Engineer Responsibilities: Daily checking the assigned tickets and resolve the tickets depends on the priority levels. Performing Snapshots, Cloning, Cold Migrations and Hot Migrations Performed VMware vMotion to move VM s in between ESXi hosts Creating virtual machines, install operating systems inside VM s and install tools and configure these VM s based on customer requirements Build new windows server and decommissioning old server Adding users in Active directory providing the user level /Domain level permissions Worked on the disk space alerts to resolve the disk space issues Applying monthly security patches on application/Db servers Good communication, interpersonal & problem-solving skills with analytical, decision making and leadership capabilities to enhance organizational objectives. Environment: Windows 2003/2008/2012, Vmware vSphere 5.1 SXC Pharma, Bangaluru August 2011 August 2012 Cognos developer Responsibilities: Business Analysis and Reports Requirement Gathering. Developed different types of reports using Report studio. Developed different types of reports like list, drill through reports and prompt reports. Published packages to Cognos server. Tested the reports. Created cascade prompts and conditional formatting using report studio Attending daily client standup calls Good communication, interpersonal & problem-solving skills with analytical, decision making and leadership capabilities to enhance organizational objectives. Having good onsite experience & Client interaction Environment: Cognos BI 8.0,T-SQL,MSExcel Keywords: business intelligence database information technology microsoft South Carolina