Sr. SQL Server DBA
Resume:
Anil Kumar
Frisco, TX *****
*****@*******.***
SUMMARY OF EXPERIENCE
• Over Fifteen Years of experience in Information Technology as System Analyst, Programmer, Sr. Database Administrator/ Production/ Development
• Over Nine years of Expertise as Sr. Database Administrator/Developer in Microsoft SQL Server 2008/2005/2000, and working knowledge of Oracle.
• Last Project (2 years) as Operation DBA to Hotels.com/Expedia Inc.
• Database Administration in Microsoft SQL Server 2008/2005/2000 and providing production support for 24X7 high availability environments.
• Database Mirroring, Partitioning, Replication, and Log Shipping in MS SQL Server.
• Migration and upgrade from SQL Server 2000 to SQL Server 2005, and SQL Server 2005 to SQL Server 2008.
• Performance Monitoring and tuning of OLTP/OLAP database server and databases in MS SQL Server 2005/2000.
• Performance Monitoring using tools such as Quest Performance Analyser, Quest Spotlight, Litespeed, BMC ProactiveNet, SQL Sentry and others.
• Troubleshooting and Performance tuning of slow running Queries.
• Writing DTS/SSIS packages, stored procedures, functions, triggers.
• Working on ETL tools. Writing Reports using SSRS.
• Planning and Implementation of security Policies as per PCI and SOX compliances.
• Logical and Physical Data Modeling and Schema design.
• Designing, testing and implementation of high availability solutions for databases.
• Planning, implementation and support of database backup, database recovery and disaster recovery policies of databases in a highly availability environment.
• Installation and Configuration of HP Polyserve Software. Installation SQL Server 2000/2005/2008, Service packs and hot fixes on stand alone and cluster servers.
• Managing projects in Travel, IT, Health and Education Industry.
• IT Project Management: Interacting with senior management and application users to gather requirements and creating project plan with the help of developers/programmers and other stakeholders.
• Microsoft Certified Database Administrator in SQL Server 2008/2005/2000.
TECHNICAL SKILLS
Operating Systems: Windows 2003 Server (32 bit & 64 bit), Windows 2000
Advanced Server/2000 Professional/NT 4.0/98/XP MSDOS, UNIX, VMS, DFS.
Databases and tools: MS-SQL Server 2008/2005/2000/7.0/6.5., Oracle 9i, BCP, MS Access, SSIS, SSRS, SSAS, Crystal Reports, MKS Source Integrity Tool.
Clustering Software: Microsoft Clustering, HP Polyserve Clustering.
Programming Languages / Tools: Transact -SQL,Visual Basic, Visual C++, C++, C, COBOL, SQL, PLSQL, Jscript, VBScript, Windows Script, Microsoft Active Directory, Unix Shell Programming, Windows performance monitor, Index tuning wizard, DTA, ERWin Data Modeler, Visio.
Backup Tools / Software: Quest Tools (LiteSpeed 2005, Performance Analysis and Spotlight), SQL Sentry, Red-Gate – SQL Compare, BMC - ProactiveNet.
Hardware used (32/64 bit Servers): Dell, IBM, HP, Compaq, and Digital.
Professional Qualification/ Certifications
• Master of Science in Computer Science (MS)
• Post-Graduate Diploma in Computer Science and Application (PGDCA).
• Master of Science in Statistics (MS)
• Microsoft Certified Data Base Administrator (MCDBA) in SQL 2000.
• Microsoft Certified Technology Specialist (MCTS) in SQL Server 2005 and SQL Server 2008.
• Microsoft Certified IT Professional (MCITP): Database Administrator: SQL Server 2005 and SQL Server 2008.
EMPLOYMENT HISTORY
A. Hotels.com, Expedia Inc, Dallas, Tx, USA April 2007 to Feb 2009
Sr. SQL Server DBA (Operations)
Hotels.com (an operating company of Expedia Inc.) is an online Travel company that provides more than 70,000 properties world wide. The site offers Hotels, Flight booking, Vacation packages, Hotels reviews, deals and number of others customer reward programs. It has more than 20 points of sales world wide. The site is highly transaction driven revenue generating site, where a downtime even for a minute is not acceptable.
Roles and Responsibilities:
• 24X7 Database Production support as Operation DBA to www.hotels.com, www.travelnow.com, www.expedia.co.jp, www.hotels.co.uk and other around 20 Point of sales of www.Hotels.com in Europe, Australia and Asia.
• On Call support for 24X7.
• Proactively monitoring of live site production databases in Microsoft clustered environment.
• Troubleshooting of site issues, DB Performance issues and long running queries.
• Running Various MPS reports for troubleshooting a SQL Server Instances.
• Production Support to Back office Application and Data ware house environment.
• Troubleshooting of SQL job failures, DTS and SSIS packages.
• Installation and Configuration of HP Polyserve Software. Installation of Microsoft SQL Server 2000/2005/2008, Service packs, Hot fixes in Clustered environment and standalone environment.
• Database Migration from SQL Server 2000 to 2005 and from SQL Serve 2005 to 2008 for live site, back office application and others.
• Installation of SQL Server 2008 and its configuration and DB migration from SQL 2005 to SQL server 2008.
• Implementing security Policies as per PCI and SOX compliances.
• Configuring, Monitoring and Troubleshooting DB mirroring Replication, Log shipping.
• Data Center Migration and Disaster Recovery plans and Implementation.
• Planning and implementation of database backup/restore Strategies.
• Working with Development team to normalize the database and optimize Queries.
• Performance Monitoring of MS SQL Server 2005/2000 using various tools SSMS, Performance Analysis, Spotlight, BMC – Proactivenet, SQL Sentry.
• Writing reports using SSRS, and supported SSAS environment.
• Writing customized scripts for monitoring of the SQL Servers and other database administration work.
• Installation and configuration of various Quest tools such as Litespeed 2005, Performance Analysis, and Spotlight.
• Deployment of Production Builds. Deploying Build in Pre-prod environment and working with QA team for Functionality Testing and Regression Testing.
• Database refresh in QA environment.
Environment: Microsoft SQL Server 2008/2005/2000 Enterprise Edition with Clustering, Windows 2003 Advance Server /2000 Server, PolyServe Clustering, Windows 2000 Professional/Windows XP, Quest Litespeed 2005, Performance Analysis, Spotlight, SQL Sentry, BMC - Proactivenet
- - - - - - - - -
B. Sainisoft Inc, Piscataway, NJ, USA December 2006 to March 2007
Sr. SQL Server Database Administrator
Roles and Responsibilities:
• Data Migration and Upgrade from SQL Server 2000 to SQL Server 2005.
• Configuring and Monitoring Replication and Log shipping in MSSQL Server 2005/2000.
• Providing Production support for MS SQL Server and Oracle 9i environment.
• Planning and implementation of database backup/restore and disaster recovery.
• Working with Development team to normalize the database and optimize Queries.
• Performance Monitoring of MS SQL Server 2005/2000 and Oracle 9i.
• Writing DTS/SSIS package to import and process the firewall security log to analyze unauthorized access to SQL Servers.
• Writing customized scripts for monitoring of the SQL Servers and other database administration work.
• Installation of Microsoft SQL Server 2000/2005, Service packs, Hot fixes.
• Installation and configuration of Quest Litespeed 2005.
Environment: Microsoft SQL Server 2000/2005 Enterprise Edition with Clustering, Oracle 9i, Windows 2000 Advance Server /2003 Server, Windows 2000 Professional/Windows XP, Quest litespeed 2005, Microsoft Projects, VBScript/Windows Scripting
- - - - - - - - -
C. PGIMER, Chandigarh – INDIA January 2005 to October 2006
System Analyst (Database Administrator/Architect)
PGIMER (www.pgimer.nic.in) is Post Graduate Institute of Medical Education and Research is situated in Chandigarh (INDIA) is one of the largest Health Care organization in the country. It is super specially Hospital, Research Institute and Imparting Postgraduate Medical Education in Medical Sciences and para-medical Sciences. The PGIMER is an Institute of National Importance. More than one million patients visit every year in Out Patient Departments and More than 50,000 patients are admitted in various wards every year. It has around 6,000 employees.
Project Summary: The project includes designed/development of Modules of Back office services which includes Finance, Procurement and Inventory.
Roles and Responsibilities
• Monitoring and troubleshooting the production servers and Support to Back office Application and Data ware house environment.
• Supported production, QA, test and development environments for highly available applications.
• Configuration monitoring and troubleshooting of Replication and Log Shipping.
• Monitoring, troubleshooting and optimizing the performance of the SQL Server 2000/2005 databases.
• Writing DTS/SSIS packages using advanced tasks for data Extraction, Transformation and Loading. Writing Customized DTS/SSIS Packages for Import/Export of Data. Used Crystal Reports for writing reports.
• Backup and restoring databases using various tools and T-SQL Scripts. Point in time recovery and Disaster Recovery.
• Used ERWIN Data Modeler tool for DB Design/Management. Optimization of stored Procedures/Triggers/Queries. Tuning database and helping developers to tune applications.
• Running SQL Profiler and Windows performance monitor to collect performance parameters and analyzing it to identify cause of slow running queries.
• Capacity planning and creating Development, QA and Production Environments.
• Writing T-SQL scripts for various Database Administration works.
• Installation of SQL Server 2005/2000 with Service Packs and Hot Fix.
Environment: MS-SQL Server 2000/2005 on Windows 2000/ 2003 server
- - - - - - - - -
D. PGIMER, Chandigarh (INDIA) June 2002 to December 2004
System Analyst (Database Administrator)
Project Summary:
Patient Medical Record System: It is used to capture the Patient's Demographic and Clinical Information and diagnostic Information of the Patient. The module is used for In-door and Out-Door Patients.
Roles and Responsibilities
• Writing Optimized DTS/Stored Procedures/Triggers/Queries. Tuning database and helping developers to tune applications.
• Writing T-SQL scripts for various database Administration works.
• Monitoring and troubleshooting the production servers with Replication and Log Shipping.
• Supported production, QA, test and development environments for highly available applications.
• Running SQL Profiler and Windows performance monitor to collect performance parameters and analyzing it to identify issues related to slow running queries.
• Capacity planning and creating Development, QA and Production Environments.
• Implementation of Security policies. Data refresh in QA environment.
Environment: MS-SQL Server 7.0/2000 on Windows NT/2000 server.
- - - - - - - - -
E. PGIMER, Chandigarh (INDIA) January 2000 to May 2002
Database Administrator
Project Summary: Laboratory Information System: Modular system was designed to captures various Clinical Parameter of the Patients. The module also includes Test requisition, Reporting, and archiving of Laboratory data of patients.
File Monitoring System: The system was designed and developed to track the office document to bring efficiency in the system.
Roles and Responsibilities
• Monitoring, troubleshooting and optimizing the performance of the Microsoft SQL Server 7.0/2000 databases in OLTP environment. Running SQL Profiler and Windows performance monitor to collect performance parameters and analyzing the same to identify the issue related to Slow running Queries.
• Backup and restoring databases using various tools and T-SQL Scripts.
• Wrote and optimized stored Procedures/Triggers/Queries. Tuning database and helping developers to tune applications. Writing T-SQL scripts for various database Administration works.
• Configuration monitoring and troubleshooting replication.
Environment: MS Windows Server NT/2000, MS SQL Server 7.0/2000, Visual Basic, Windows XP.
- - - - - - - - -
F. PGIMER, Chandigarh (INDIA) December 1995 to December 1999
Database Administrator/ Developer
Project Summary:
Payroll system: It is used to disburse the salary to the employee, keep track of their earning, savings, deduction for the purpose of Tax etc.
Library Information System: It is used for catalog maintaining and issue/return of books.
Patient Billing on line system: It collects the Hospital Charges from the patient for Laboratory tests, their stay in the Hospital.
Roles and Responsibilities
• Writing stored Procedures/Triggers/Queries. Tuning database and helping developers to tune applications. Writing scripts for various database Administration works.
• Monitoring, troubleshooting and optimizing the performance of the Microsoft SQL Server 7.0/6.5 databases.
• Running SQL Profiler and Windows performance monitor to collect performance statistics and analyzing to identify missing indexes, Slow running Stored Procedures, Full Table Scan.
Environment: MS Windows NT 4.0/3.5 Server, MS SQL Server 7.0/6.5, Foxpro, Visual Basic 6.0/5.0, Windows 98/95
- - - - - - - -
Contact this candidate