Home

Kalyan Reddy - SQL DBA

[email protected]

Location: Owings Mills, Maryland, USA

Relocation: yes

Visa: H1b

Name: Kalyan MSSQL Server DBA Email: [email protected] Experience Summary: Having 12 years of IT experience with 10 + years of experience as a MSSQL Server DBA and 2 years experience Azure/AWS ,Snowflake ,Jenkins pipeline,Git/Github in reputed organizations DB migrations from on-premise to Azure cloud using bacpac files and DMA Good at Azure cloud administration in creating VM, Resource groups, Configuring load balancer,Vnets,configuring Availability sets Good at SQLDB migrations from on premise to Azure cloud using bacpac file and DB deployment methods. Moving the resources form one Resource Group to another Resource Groups when requires. Experience with SSIS, SSRS Proficient in handling SQL server DBA activities related to HA features Log shipping, replication, mirroring, clustering and Always-On. 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. Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks. Loading data in to Snowflake tables from the internal stage using Snowsql Used COPY, LIST, PUT and GET commands for validating internal stage files Experience with AWS cloud services:EC2,S3,EMR,RDS Experience in creating VM/Instances, scale up-scale down resources in Azure/AWS Experience like source code deployment using Git/GitHub Proficient in application build/release/deploy through opensource tool Jenkins pipeline Deployed JAR, WAR and J2EE applications using Jenkins Experience in CI/CD through Jenkins pipeline worked VMware administration Performing Snapshots, Cloning, Cold Migrations and Hot Migrations 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 2019/2017/ 2016/2014/2012/2008R2/2008/2005, SSIS, SSRS MS Access 2003/2000/97 Database Technologies/Tools: SQLServer, 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, Azure/Aws admin, Snowflake, Devops CI\CD Jenkins,Git/Github Programming Languages: T-SQL ,C,C++,Java Education: Masters in Computer Science Master of computer applications (MCA) from Kakatiya university, Telangana, India Professional Experience: Kaiser Permenente(KP) , USA December 2021 to till date MSSQL Server DBA Responsibilities: Demonstrated expertise in application design and construction, work breakdown structure of items, design and code reviews, unit test and build activities Configuring SQL DB on Azure cloud DB migrations from on-premise to Azure cloud using. bacpac files and DMA method Performing database refresh activity with export/import Providing the user / schema /db level/view level permissions Experience in performance tuning like working with indexes rebuild indexes,db integrity checks, updating statistics Loading data in to snowflake tables from the internal stage using snowsql Used COPY,LIST,PUT and GET commands for validating internal stage files Experience with AWS cloud services:EC2,S3,EMR,RDS Experience in creating VM/Instances, scale up-scale down resources in Azure/AWS Experience like source code deployment using Git/GitHub Proficient in application build/release/deploy through opensource tool Jenkins pipeline Deployed JAR,WAR,EAR and J2EE applications using Jenkins Experience in CI/CD through Jenkins pipeline Good communication, interpersonal & problem-solving skills with analytical, decision making and leadership capabilities to enhance organizational objectives. Environment: Azure SQL 2017/2019, T SQL, MS Excel NXP Semiconductors, USA 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 Limited 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, USA 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. Having good onsite experience & Client interaction Environment: Windows 2003/2008/2012,Vmware vSphere 5.1 SXC Pharma, USA 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 Keywords: cprogramm cplusplus continuous integration continuous deployment business intelligence sthree database information technology microsoft