sql server dba with 9+ years of exp and hands on Postgresql

sql server dba with 9+ years of exp and hands on Postgresql

• 1.
  Sunil Kumar Thumma Email:sunil.kumar.thuma@gmail.com Mobile: 8179997425 Professional Summary:  Having 9+ years of experience in MSSQL Server Database Administration and Production support  Experience in Installation, configuration MSSQL Server 2000, 2005,2008 , and 2012 with service pack on stand-alone and cluster environment.  Experience in PostgreSql like Installation ,configuration ,Backup and Restoration in Windows and Linux  Experience in Maintenance, Performance Tuning, Backup and Recovery of the Databases on 2000/05/08/08/2012 platforms.  Experience in Migration of database from Lower version to Higher version  Experience in Migrating heterogeneous to SQL Server using SMA (SQL Migration Assistant)  Having experience on large size production Databases  Provide 24x7 DBA production support, worked with DBA team for On-Call Support in rotation basis to resolve Database related Tickets/Changes assigned to the Group.  Knowledge of Log-shipping, replication and clustering  Experience in SQL Server using Graphical Administration tools which includes Sql Server Management Studio, SQL Server Enterprise Manager, SQL Server Query Analyzer and SQL Server Profiler.  Experience in Net Backup client/ SQL Safe/EMC - NetWorker for scheduling Backup and Recovery  Provided operational support for database as DBA for systems in order to ensure minimal downtime.  Performance Tuning and Monitoring  Involved in the planning and implementation of Disaster Recovery Process.  Good Communication Skills and Technical Skills.  Working experience in ITIL Process Educational Qualification:  M.Sc Computers from G.Pulla Reddy P.G College affiliated to Osmania University, April, 2004  B.Sc Computers from H.R.D Degree College affiliated to Osmania University, April, 2002.  H.S.C from Vani Jr College, I.P.E, April, 1998.  S.S.C Tapovan High School April, 1996. Certification:  Microsoft Sql server 2005 Implementation and Maintenance: 070-431 Experience Details: Tata Consultancy Services, Pune. Duration : May 2013 to Till Date Designation : IT Analyst/Assistant Consultant Environment : SQL Server, PostgreSql Project: EricssonIT EricsonIT is a telecom project where in as a DBA we are responsible to handle 80+ applications server database (Production, Acceptance and Development) servers. 1
• 2.
  Sunil Kumar Thumma Email:sunil.kumar.thuma@gmail.com Mobile: 8179997425 Responsibility:  Managing multiple instances of SQL Server in production and development environments  Handled SOX compliance servers  Migrated Oracle database to MS SQL Server using SMA  Giving Operations support for production /non production SQL Server 2008/2012 servers  Worked on SOX compliance servers.  Tuning SQL Quires whenever there is poor performance.  Monitoring and maintaining the SQL jobs running on various servers  Install security patches and hot fixes on all the servers as applicable  Perform DBA duties including backups, maintenance.  Installed, configured and PostgreSql along with backup and restoration in Windows and Linux Environments B.M.C Software, I.T.C Towers, S.B.Road, Pune. Duration : July 2012 to April 2013 Designation : Staff Database Admin. Environment : SQL Server 2008/, Windows 2008 Tools : Backup Tool – EMC Networker Remedy ON-Demand. Remedy is an ITSM application with Subscription-based software as a service. Where one can access ITIL services like Service Desk, Self Service, Change asset dashboard, and analytics tools anywhere, anytime with cloud, social media and mobile integration Responsibility:  SQL Server installation, configuration, upgrading, troubleshooting, backup and recovery.  Incident handling, Change request implementation  Several servers involved cluster nodes in SAN environment  Addressing issues related to high Memory utilization, blocking, long running queries.  Monitor SQL logs and take steps to ensure minimum disk space usage.  Refreshing TEST/DEV environment from production when needed by the client.  Perform DBA duties including backups, maintenance, user access and security.  Ensure the all the maintenance tasks and backup jobs are successfully executed as per schedule and if any job fails identify the reasons and fix them.  Install security patches and hot fixes on all the servers as applicable.  Documenting weekly and monthly jobs/backup for reporting to client managers.  Creating SSRS Reports  Knowledge of Log-shipping, replication and Mirroring.  Creating users, Granting rights, Credentials, Proxy accounts. Configure Database Mail and use then extensively for sending mails on completion of SSIS jobs, 2
• 3.
  Sunil Kumar Thumma Email:sunil.kumar.thuma@gmail.com Mobile: 8179997425 report of production job history giving details of start time, end time and duration.  Responsible for applying latest SQL Server Service packs on production, development, UAT servers.  Working experience in ITIL Process CompuCom CSI Systems. India Private Limited, Magarpatta City, Pune. Duration : July 01, 2010 to June 212 Designation : System Support Analyst. Environment : SQL Server 2008R2./2008/2005/2000, Windows 2003/2000 Tools : Backup Tool - Net Backup A) Blockbuster Entertainment (Dallas- US) Blockbuster is an Online-service Provider Company who offers the online services like Rent, Buy, Download, and Gift DVD’s. This service used by their vendors and the end- users. There are different types of help desk available to provide the 24*7 support for this Online service Application Responsibility:  Installing and configuring Sql Server 2000/05/08 on Windows Cluster environment Incident handling, Change request implementation and RCA preparation..  Giving Operational support for Production and Non-Production SQL Servers  Managing multiple instances of SQL Server in production, development and test environments including installation and configuration.  Refreshing TEST/DEV environment from production when needed by the client  The average size of the databases handled is 150-600 GB.  Perform DBA duties including backups, maintenance, user access and security.  Monitoring and maintaining the SQL jobs running on various servers.  Install security patches and hot fixes on all the servers as applicable.  Creation of logins, roles and granting security rights  Performance Tuning and Monitoring  Experience in Migration of Databases from SQL Server 2000 to 2005 and to 2008.  Several servers involved cluster nodes in SAN environment.  General Maintenance i.e. Re-indexing, Analyze, Exp/Imp, Monitor and support client server databases on Windows 2000.  Documenting weekly and monthly jobs/backup for reporting to client managers.  Report daily and monthly status of disk space usage  Co-ordinate with developers regarding implementing and performing change.  Provided 7 x 24 Production support for the database and application issues  Working experience in ITIL Process B) PGW (Pittsburgh Glass Works, Pittsburgh- US). Pittsburgh Glass Works, LLC is a high quality range of products and services in a reliable and customer responsive manner. Pittsburgh Glass Works is a leading end-to-end product and service provider (24*7) in the automotive glass industry marketplace into the future. Responsibility:  Giving Operations support for Production / Non-Production SQL 2000/05/08 3
• 4.
  Sunil Kumar Thumma Email:sunil.kumar.thuma@gmail.com Mobile: 8179997425 servers.  Incident handling, Change request implementation RCA preparation.  Managing multiple instances of SQL Server in production and development environments including installation and configuration.  SQL Server 2000, 2005 and 2008 installations of x86 and x64 servers in all environments.  Refreshing TEST/DEV environment from production when needed by the client.  Perform DBA duties including backups, maintenance, user access and security.  Creation of logins, roles and granting rights.  Monitoring and maintaining the SQL jobs running on various servers.  Install security patches and hot fixes on all the servers as applicable.  Performance Tuning and Monitoring  The average size of the databases handled is 150-600 GB.  Several servers involved cluster nodes in SAN environment.  Installing and configuring Sql Server 2000/05/08 in Windows Cluster environment  Working experience in ITIL Process Triumph Systems and Solutions, Bombay. Duration : April, 2009 to June 2010 Designation : Database Administrator Client : TechMahindra, Pune, India A) Blockbuster Entertainment (Dallas – US) Blockbuster is an Online-service Provider Company who offers the online services like Rent, Buy, Download, and Gift DVD’s. This service used by their vendors and the end- users. There are different types of help desk available to provide the 24*7 support for this Online service Application Responsibility:  Giving Operations support for Production / Non-Production SQL 2000/05/08 servers.  Incident handling, Change request implementation and RCA preparation.  Managing multiple instances of SQL Server in production, development and test environments including installation and configuration.  Refreshing TEST/DEV environment from production when needed by the client.  Perform DBA duties including backups, maintenance, user access and security.  Monitoring and maintaining the SQL jobs running on various servers.  Install security patches and hot fixes on all the servers as applicable.  Creation of logins, roles and granting security rights  Performance Tuning and Monitoring  The average size of the databases handled is 150-600 GB.  Several servers involved cluster nodes in SAN environment.  Installing and configuring Sql Server 2000/05/08 on Windows Cluster environment  General Maintenance i.e. Re-indexing, Analyze, Exp/Imp, Monitor and support client server databases on Windows 2000.  Documenting weekly and monthly jobs/backup for reporting to client managers.  Report daily and monthly status of disk space usage 4
• 5.
  Sunil Kumar Thumma Email:sunil.kumar.thuma@gmail.com Mobile: 8179997425  Co-ordinate with developers regarding implementing and performing change.  Provided 7 x 24 Production support for the database and application issues  Working experience in ITIL Process Fortune Digitals Pvt ltd, Hyderabad. Duration: October, 2006 to March, 2009. Role: Database Administrator. A) T.K.M.Pharmacy. Responsibility:  Work as part of a team and provide 7×24 supports when required.  Installation, configuration and upgrading of Microsoft SQL Server and related products.  Establish and maintain backup and recovery policies  Implement and maintain database security (create and maintain users and roles, assign privileges).  Database tuning and performance monitoring.  Using Net Backup for scheduling Backup and Recovery jobs.  Setup and maintain documentation and standards.  Plan growth and changes (capacity planning).  Do general technical trouble shooting and give consultation to development teams. B) Orange Logistics Pvt.ltd. Responsibility:  Installing and configuring and tuning and providing 24X 7 supports for SqlServer 2000 and 2005 in development and production environment.  Creating databases and Logins with permissions in SQL Server 2005 as per developer’s request.  Generated Few Reports using Microsoft Reporting Tool SSRS.  Implement and maintain database security (create and maintain users and roles, assign privileges).  Plan growth and changes (capacity planning).  Check disk space utilization.  Database tuning and performance monitoring.  Reorganization of data and index pages and Fragmentation of indexes using Sql  Check for replication working as intended.  Apply the latest hot fixes and security patches released by Microsoft Personal Profile Name :Sunil Kumar Thumma Gender :Male Date of Birth :25, December, 1980 Marital Status : Married Pan Card No :AJBPT3478M 5
• 6.
  Sunil Kumar Thumma Email:sunil.kumar.thuma@gmail.com Mobile: 8179997425 Present Address : Fl #202, Prathap Enclave, Manikonda Gradens , Manikonda, Opp: Andhra Bank Lane, Hyderabad 500089 Permanent Address : H.No: 6-6-55, Near VenuGopala Swami Temple, Jagtila-505327, Dist.: Karimnagar, State: Andhra Pradesh THUMMA SUNIL KUMAR 6
• 7.
  Sunil Kumar Thumma Email:sunil.kumar.thuma@gmail.com Mobile: 8179997425 Present Address : Fl #202, Prathap Enclave, Manikonda Gradens , Manikonda, Opp: Andhra Bank Lane, Hyderabad 500089 Permanent Address : H.No: 6-6-55, Near VenuGopala Swami Temple, Jagtila-505327, Dist.: Karimnagar, State: Andhra Pradesh THUMMA SUNIL KUMAR 6