Jr SL DBA
Resume:
Ankit R.Shah
Amityville, NY-11701
*************@*****.***
Profile
Extensive industry experience With MS SQL Server DBA, Configuration, Installation, Management, Upgrading system Analysis with MS SQL server 2008R2, 2008, 2005, 2000 in production environment. Additional experience in SQL Business intelligence attributes to thorough understanding of SQL framework.
Technical Summary
• Experience with SQL server2008R2 / 2008/ 2005/ 2000 Installation, Upgrade, Migration, Configuration, SSIS, SSRS and Administration.
• Actively involved in support for production applications.
• Experience in supporting very large and highly transactional databases and troubleshooting various performance bottle necks on different environment (Production, Reporting, DEV, UAT, Test etc.)
• Worked with Indexing, Statistics, Locking and Blocking on queries.
• Experience in database Backup, Recovery, and Disaster Recovery procedures.
• Maintained database level and object level security best practice by creation of users, Configuring permissions and assigning different roles to Users.
• Experience with configuring database with high arability techniques like Replication, Clustering as well as implementing disaster recovery techniques like database mirroring and log shipping.
• Experience with database performance tuning, Query optimization, client/server connectivity and other network issues, database consistency checks using DBCC.
• Experience in investigating and applying necessary SQL server service packs and CU’s.
• Worked with Database Backup Compression, Data Collector, Policy-based management, Resource Governor, SQL server Audit.
• Experience in debugging and optimizing Triggers, Views, Functions, T- SQL queries and stored procedures.
• Experience in using Dynamic Management Views (DMV) to troubleshoot and improve server performance.
• Proficient with data transformation services like SSIS, DTS, and BCP techniques. Good knowledge of RAID System, Capacity Planning, Data partioning, indexing.
• Worked on 32 Bit and 64 Bit clustered and standard server environment.
Education
• Diploma in Electronics & Communication from Technical Education Board – Gujarat, India
• Bachelor of Science - Electronics & Telecommunication from North Maharashtra University, India
Certification
• MCTS: SQL Server 2008, Implementation and Maintenance (70 – 432) August, 2011
• MCITP: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 (70-450) September, 2011
• MCTS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
(70-448) October, 2011
Technical Skills
SQL Server/ Databases MS SQL Server 2008R2, 2008, 2005, 2000, MS Access.
Programming Languages TSQL, C, C++, Assembly Language.
Operating System/ Servers Windows 2008R2, 2008, 2003, 2000, XP, Vista, Win 7.
ETL Tools SSIS, DTS.
Tools SSMS, SQL DB Access, Performance Monitor, SQL Profiler, IDERA, SQL Diagnostic Manager, SCOM, SSRS, SSAS, RML utilities, SQLIO, SQL BPA, MAP tool Kit, etc.
PROFESSIONAL EXPERIENCE
Mount Kisko Medical Group, Mount Kisko, NY Oct 2011 – Present
SQL Server DBA /BI
Responsibilities:
• Working and Managing 93 SQL Servers (2008R2) on Windows Server 2008R2 Environment.
• Installed and configure SQL Server 2008R2.
• Designed and Implemented Backup and Restore Operation (Daily and Weekly) strategy for clustered production Environment.
• Configured Database Mail, Linked Server for the various Developers.
• Monitoring Production (Clustered), Reporting (Clustered), Development and Testing Environment.
• Working with daily user requests and Providing DBA level support for various environments.
• Working with Performance Monitor and SQL Traces to have better graphical analysis to find system bottlenecks.
• Successfully resolved locking and blocking, deadlocks occurred on production database.
• Designed SSIS packages and schedule on regular basis using SQL Agent.
• Doing performance and tuning, identifying locking and blocking for long running queries.
• Monitoring Production and Reporting Server using SQL Monitor, DMV’s, System Views, DBCC commands and SQL Profiler.
• Creating SQL Server logins and assigning roles and Authentication models as a part of Security to the Users.
• Monitoring SQL server Error logs, Disk Space growth, SQL Jobs for Clustering Environment.
• Created Performance and Tuning counter Alerts using SQL Alerts.
• Performing Weekly refresh and Daily refresh from Production to Reporting Environment.
Environment: SQL Server 2008R2 Clustered Windows Server 2008R2, SSIS, and SSRS.
Kamehameha Schools, Honolulu, HI March 2011 – Aug 2011.
SQL Server DBA
Responsibilities:
• Managing approximately 80 SQL Servers (2000, 2005, 2008, 2008R2) with team of 4 DBAs.
• Monitoring and making recommendations for performance improvement in hosted databases.
• This involved index creation, index removal, index modification, file group modifications, code optimization and adding scheduled jobs to re-index and update statistics in databases.
• Providing production support to the users.
• Maintain the integrity, availability, and recoverability of all production data systems. Planning for overall data deployment and operational health.
• Responsible and Involved in SQL Server Performance Monitoring, Server and Database optimization and Query tuning & used Windows Perform and various 3rd party tools to monitor SQL Server health and gauge the performance. Used SQL Server Dynamic Management Views and functions to monitor & optimize the performance.
• Worked with Business Analysts, Cognos Developer, SQL Developers, SSIS Developers in Development of the Project
• Conducting Database Refresh once in every week from PROD to UAT, DEV, and Test Environments.
• Monitoring SQL server Error logs, Disk Space growth, Clustering Environment.
• Planning and applying latest Service Packs to different versions of SQL Server.
• Maintain the integrity, availability, and recoverability of all production data systems. Planning for overall data deployment and operational health.
• Worked on performance and tuning, identifying locking and blocking for long running queries.
• Performing Backup and Restore operation from Production Server to UAT and DEV.
• Monitoring clients’ application and escalating code bugs to development team.
• Extensive ETL (Extract, Transform Load) work including SSIS to provide daily data exports.
• Involved with the team to run different MS SQL Server tools like MAP tool kit , SQLIO.
Best practice analyzer (BPA), RML utilities for SQL Server health check.
• Supports Production, UAT, and Development Environment.
• Monitoring all Production servers using third party tool IDERA
• Created SQL Server logins and assigning roles and Authentication models as a part of Security.
Environment: SQL Server 2000/2005/2008/2008 R2, Microsoft Business Intelligence, Visual Studio for SSIS, SSRS, SSAS, MS Office Access, Windows Server 2003/2008.
Rume Corp, Farmingdale, NY Nov 2008 - Feb 2011.
IT Technician/SQL Server DBA
Responsibilities:
• Installed SQL Enterprise Server 2005 / 2008 64 bit version on windows 2003 Servers.
• Designed and Implemented SSIS packages to load data from heterogeneous data source.
• Migration of database from SQL Server 2000 to 2005 / 2008.
• Experience with implementing different type of Replication models like snapshot and transactional.
• Developed, deployed and monitored SSIS packages including upgrading DTS to SSIS.
• Worked and generated reports using SQL Server 2005 reporting services (SSRS)..
• Experience in implementing different types disaster recovery scenarios of Replication models like Snapshot, transactional, Merge.
• Implementation of SQL logins, Roles and Authentication modes as a part of security policies for various categories of user.
• Involved in implementation of log shipping for disaster recovery.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Designed and configured DB Mirroring in SQL Server 2005.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies implemented
• Performed and applied SQL service pack and windows service pack to upgrade.
• Performance testing on stored procedures, indexing and Triggers.
• Involved in trouble shooting and fine tuning of database for its performance and concurrency.
• Experience in using DMV to improve Server performance.
Environment: SQL Server 2005 / 2008, Microsoft Business Intelligence, Visual Studio for SSIS, SSRS, SSAS, Microsoft .Net, MS Office Access, Windows Server 2008.
DNS Software Technologies Pvt. Ltd, Pune, India Dec 2007 – Sept 2008.
SQL Server DBA
Responsibilities:
• Involved in System Study and database Maintenance.
• Successfully installed and configure SQL Server 2005
• Migration of MS SQL Server from 2000 to 2005
• Monitored Log shipping as high arability solution.
• Configured Server memory for maximum performance and effective utilization.
• Integrated Performance Monitor and SQL Traces to have better graphical analysis to find system bottlenecks.
• Extensively used filtered Indexes to improve query performance and lower storage and maintenance cost.
• Created, Modified and monitored Replication (Transactional, Merge) on all Production databases.
• Designed and Implemented comprehensive Backup plans and disaster Recovery strategies.
• Involved in Migration of DTS package to SSIS package.
• Worked and generated basic reports using SQL Server 2005 Reporting services (SSRS).
• Created SQL Server logins and assigning roles and Authentication models as a part of Security Policies for various categories of user support.
• Created, Scheduled and monitored SQL Server Jobs making sure job run successfully every night.
• Extensively worked in UAT and Production support and involved in trouble shooting SQL Server in various level.
Environment: SQL Server 2000/2005, Windows Server 2000/2003, Microsoft Business Intelligence Visual Studio for SSIS, SSRS, Microsoft .NET, MS Office access.
DOT INFO TECHNOLOGIES, Pune, India July 2007 – Dec 2007.
SQL DBA.
Responsibilities:
• Undergone through formal training for SQL Server 2000 and 2005.
• Involved in System Environment (DEV Environment) and database Maintaining.
• Involved with team for Installation and Configuration of the MS SQL 2005.
• Involved in upgrading database MS SQL Server 2000 to 2005
• Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.
• Configured high Availability Techniques like database Mirroring and different Replication models like Merge, Snapshot and Transactional on test environment.
• Good understanding in performance tuning, Backup and disaster Recovery Process and tools.
• Created logins and Maintained user permissions appropriately.
Environment: MS SQL server 2000/2005, MS Office access, MS Visual Studio, Windows Server 2003.
Contact this candidate