Sql Server Data
Resume:
VENKAT GUNTUPALLI
adf283@r.postjobfree.com
PROFILE SUMMARY:
Having 10 years of experience in Database Administration and Development for very large and complex databases in Postgres 9.6 and SQL Server 2016/2014/2012/2008R2/2008/2005/2000 in variety of environments and sectors.
Strong Experience in MS SQL Server database development and administration in enterprise production and other environments including installation, configuration, upgrade, maintenance, performance tuning, optimization, backup/restore, recovery, migration, monitoring, security planning and trouble-shooting.
Proficient with SQL Enterprise Manager, Query Analyzer, Management Studio, Business Intelligence development studio, rescheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups. OLAP, OLTP, Data warehouse design, trouble shooting.
Experience in implementing SQL Server security and Object permissions like maintaining creation of users, configuring permissions and assigning roles to users.
Experience in constructing T-SQL and Oracle PL/SQL Tables, Stored Procedures, Views, Functions, Packages, Triggers, Cursors, Indexes, User Defined Data Types, Constraints to facilitate efficient data manipulations as per the business rule.
Experience with software development life cycle (SDLC) and project management methodologies. Plus, proficient with third party SQL tools: Lite Speed, SQL Compare, Net backup.
Resolving the Disk space issues and finding the root cause and implementing permanent fixes.
Verifying and resolving the SQL Server Blocking issues and Finding the root cause and implementing the permanent fix.
Creating and administering the SQL Server Databases like data and log file placements and managing the growth parameters and database options.
Experience in applying the Service packs and Cumulative packs for servers.
Good experience with implementing High Availability of database servers using Always on, Replication, Log Shipping and Database Mirroring.
Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update statistics and monthly maintenance plans such as clean up history etc. to run the databases efficiently.
Extensive experience with Storage Capacity Planning, including system storage allocation, on-going capacity analysis and planning future storage requirements
Develop and implement policies and standards for preserving the integrity and security of data
Solid experience as MS SQL Server DBA with excellent T-SQL coding and testing: UDF, views, triggers, cursors, stored procedures, etc.
Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering, always on, log shipping, disaster recovery.
Configuration different types of Always on like Synchronous (high protection and high availability) and Asynchronous (high performance).
Extensive experience with data modeling, logical and physical database design using Erwin.
Good in Data warehousing concepts and components.
Extensive experience on Data loading, Data Extractions and Data Encrypting.
Extensive experience with hardware/software consulting &service. Network logical/physical design/modeling and maintenance. In depth knowledge of TCP/IP network configurations, planning, implementation and optimization.
Monitoring the Memory utilization and CPU utilization on Server level and Database loading time.
Expertized Migrated/Upgraded SQL Server 2000/2005/2008/2012 databases to SQL Server 2005/2008/2012/2014 databases including DTS to SSIS migration and migrated SQL Server 2005 to VMware and Oracle to SQL.
Excellent skills in Information System planning, development and implementation.
Provided 24/7 production on call service.
Closing the tickets with in the SLA time and Monitoring the SLA.
CERTIFICATION:
Exam 70-461: Querying Microsoft SQL Server 2012
Exam 70-462: Administering Microsoft SQL Server 2012/2014 Databases.
EDUCATION:
BSC from Acharya Nagarjuna University, India 2006.
Master’s in computer application from Osmania University, India 2009.
TECHNICAL SKILLS:
Operating Systems : Window 2014, 12, 10, 7, Server 2008 R2/2008/2003, UNIX
Languages : C#.Net, SQL, T-SQL, PL/SQL, Power Shell, Shell scripting.
Web Technologies : HTML, DHTML, XML, XSLT, informatics.
Databases : SQL server 2016/2012/2014/2008 R2/2008/2005/2000
SQL Server Tools/Utilities : SSMS, Enterprise Manager, Query Analyzer, SQL Profiler.
DTS, SSIS, SSRS, SSAS.
Reporting Tools : SSIS, SSRS, Cosmos, SharePoint Portal and Excel.
Monitoring Tools : Quest, sentry, Fog Light and Spotlight, Service now, new relic and Jira.
EMPLOYMENT HISTORY:
Department of Human Services (MDTHINK), Maryland
SQL DBA (Jan 2019 – Till now)
Installing SQL server 2016 for configure the Always on High availably for two node clustering.
Maintaining the server’s health and monitoring the SQL servers and Postgres servers.
Installing Postgres server 9.6 and configured the replication.
Granting the permissions for the users on table, schema and server level in postgres servers.
Creating new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
Deployed the scripts with approvals and review and validating the execution process.
Enabling and disabling the CDC for tables in SQL server in different environments.
Enrolling users, controlling and monitoring User Access to the database, and maintaining system security.
Applying SQL Server patches on cluster and standalone machines.
Working closely with application development and support team to understand their requirements and provide timely solutions, for both current and future projects.
Extensive work with Master Data Management team to configure the database and ETL packages.
Extensive work with Storage Capacity Planning, including system storage allocation, on-going capacity analysis and planning future storage requirements.
Scheduling the jobs to maintain the performance on the servers based on requirement.
PWX configuring for data capturing on Object level.
Upgradation from 2012 to 2016 Sp2 on SQL servers with multiple instances.
Migrating the data from SQL to Postgres SQL servers.
Encrypting the data on Object level columns for MDM.
Involved in Security Patching on SQL and Postgres SQL servers on Monthly basis activities.
Expertise on Memory utilization and performance issues.
Memory allocations for SQL server based on Windows Ram size.
Configuring the Transactional replication for PWX set up.
Team size: 4
Environment: SQL Server 2012, 2016 Always on, Clustering, Replication, Mirroring, SSRS, Web Services, Transact-SQL,PL SQL, SSIS, MS-Excel, Database Backups, New Relic.
AvidXchange, Charlotte, North Carolina
SQL DBA (Aug 19 – Dec 2019)
Configuring replication, mirroring, SQL clusters and troubleshooting issues.
Installation and configuration of MS SQL Server 2008,2012 and 2016.
Migrating databases from SQL Server 2008 to 2012 and SQL Server 2012 to 2016.
Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking
Updating Service packs and Security patches for the Servers.
Monitoring of server performance.
Scheduling the jobs to maintain the performance on the servers based on requirement.
Working closely with application development and support team to understand their requirements and provide timely solutions, for both current and future projects.
Team Size: 4
Environment: SQL Server 2008r2/2012,2016 Always on, Log Shipping, Replication, Clustering, Mirroring, SSRS, Web Services, Transact-SQL, Pl SQL, SSIS, MS-Excel, Database Backups.
SCOTTLINE HEALTHCARE SOLUTIONS, USA HOUSTON, TEXAS
SQL DBA (Jul. 17 – Aug 2019)
Backup and restoring the databases from production to sandbox/test environment.
Performing the Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities
Failover of availability groups for patching on SQL Server 2012 in Multi Subnet Clusters.
Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking.
Have Experience in Planning and Refreshment of Test DB Databases.
Resolving blocking processes related issues.
Configuring and troubleshooting high availability scenarios like Log Shipping and Always on.
Executing scripts in prod environment based on Tickets priority.
Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
Upgrading SQL server from SQL server 2005 to server 2008 and SQL server 2008 to Server 2012.
Working closely with application development and support team to understand their requirements and provide timely solutions, for both current and future projects.
Enrolling users, controlling and monitoring User Access to the database, and maintaining system security.
Migrating databases from SQL Server 2000 to 2005 and SQL Server 2005 to 2008.
Team size: 6
Environment: SQL Server 2005/2008r2/2012, Always on, Log Shipping, Clustering, Mirroring, SSRS, Web Services, Transact-SQL, SSIS, MS-Excel, Database Backups.
T- MOBILE, USA, Hyderabad, INDIA
SQL DBA (Feb. 15 – Jun. 17)
Have hands on experience in database configuration, backup and recovery management
Expertise in Server and Database level security management.
Disk\Space management in all Database servers.
Exposure of working on SQL Lit Speed Backup tool and Experience on taking backups in Net Backup.
Have Experience in Planning and Refreshment of Test DB Databases.
Expertise in High Availability using Always on, Log shipping and Replication.
Configuring different types of High availability always on like synchronous and Asynchronous modes.
Building windows and SQL Server Clusters. (Windows SQL server 2008 and SQL server 2008 R2)
Hands on experience in attending DB Servers Performance issues.
Creating Trace file using profiler during performance issues.
Performed data migration between different environments
Hardening the Servers as per Security Architecture Guidelines
Implementing Utility Control Point (UCP) for monitoring CPU Utilization and Disk space utilization in Database Servers.
Worked on CPU and Memory utilization on server level.
Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
Failover of availability groups for patching on SQL Server 2012 in Multi Subnet Clusters.
Hands on Experience in writing queries and stored procedure to develop application business logic.
Team size: 16
Environment: SQL Server 2005/2008, 2012, 2106, Windows2003, MS Access 2008, Always on, Log Shipping, Clustering, Mirroring, SSRS, Web Services, Transact-SQL, SSIS, MS-Excel, Database Backups.
STATE FARM, USA HYDERABAD, INDIA
SQL DBA (Aug. 12 – Feb. 15)
Configuring replication, mirroring, SQL clusters and troubleshooting issues.
Installation and configuration of MS SQL Server 2005, 2008 and 2012.
Migrating databases from SQL Server 2000 to 2005 and SQL Server 2005 to 2008.
Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking
Configuring and troubleshooting high availability scenarios like Log Shipping.
Implemented Database Mirroring with High Availability Mode in SQL 2005
Maintained & Monitored Alert/Schedule to make smooth replication process.
Ensure and maintain sound backup and recovery policies and procedures.
Responsible for SSIS package deployment and execution, SSAS cubes deployment, SSRS reports publishing, report generation and availability
Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning and Error handling.
Database performance monitoring and tuning when required as per application and business requirements.
Backup and restoring the databases from production to test environment.
Performed data migration between different environments
Updating Service packs and Security patches for the Servers.
Monitoring of server performance.
Configuring and monitoring the Database Mirroring and Log Shipping.
Ensuring Data consistency in the database through DBCC commands.
Repetitive issues analysis and proposals for permanent resolutions.
Team Size: 12
Environment: Win 2008 R2/2003, SQL Server 2005/2008 R2, .Net 3.5 SP1, IIS 7.0, Power Shell.
BELLCANADA HYDERABAD, INDIA
SQL DBA (Sep. 10 – Jul. 12)
We are supporting around 220 Prod and 4000 databases across USA and UK regions.
Regularly Monitoring 120 Production Database Servers for resource usage.
Involved in Installation and configuration of MS SQL Server 2000, 2005, 2008 and 2008 R2 in Windows environment.
Applying SQL Server patches on cluster and standalone machines.
Configuring and maintaining Database Backups.
Responsible for setting up the Transaction Replication for the high availability purpose.
Responsible for Identifying and Resolving Blocking and Deadlock issues.
Daily checking and resolving the tickets depends on the priority levels.
Daily monitoring the Database Space Management parameters, allocating the required space to databases and suitably managing database growth.
Installed and Configured SSRS and Deploying SSIS packages
Responsible for performing database maintenance activities like rebuilding/reorganizing indexes and update statistics, checking database integrity and clean up history on regular intervals.
Applying patches to Test/Dev/Productions servers.
Doing Weekly Refresh of Database from Production to Test Environment.
Configuring and troubleshooting high availability scenarios like Log Shipping.
Executing scripts in prod environment
Able to perform the Failover and Failback activities in Cluster environment.
Upgrading SQL server from SQL server 2005 to SQL server 2008 and SQL server 2008 to SQL Server 2012.
Team size: 12
Environment: SQL Server 2005/2008, Windows 2003, MS Access 2008, Log Shipping, Clustering, Mirroring, SSRS, Web Services, Transact-SQL, JavaScript, SSIS, MS-Excel, Database Backups.
Contact this candidate