SUMMARY:

• 14+ Years of IT Experience with specialization in SQL Server Database Administration/ Project Management analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverable within committed deadlines
• Certified AWS Solution Architect
• Microsoft Certified Technology Specialist - SQL Server 2005
• Managed a Team of 16 supporting Onsite - Offshore model
• Worked with Data Architects and Clients for the purpose of business requirement.
• Coordinate with onshore DBAs, On-call Team and Coordination Team on daily SLA requirements.
• Extract reporting data and prepare required reports in coordination with offshore team.
• Coordinate on all compliance and patching requirements.
• Participated in Project Management training conducted by Cognizant
• Attended PMP training classes from an External Vendor.
• Expertise in providing support to Maintain databases for application development groups.
• Creating and scheduling all Database related jobs.
• Make sure that Shift Report is updated or communicated to coordination team on any requests you are working on or new requests to be addressed by offshore team.
• Worked on Databases with sizes up to Terabytes.
• Worked on Database migration project from SQL Server 2000 / SQL Server 2005 to SQL Server 2008. In this project instead of copying the data file manually from source to destination, used the latest Copy Database feature after complete testing.
• Coordinate/work with Line Managers on any onshore resource related challenges
• Coordinate on all compliance and patching requirements.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Experienced in performing data validations.
• Have a very good knowledge on Financial Domain.
• Excellent communication skills, oral and written combined with superb interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2003, Windows 9X, Windows ME, Windows NT and Windows XP

Programming: SQL, T-SQL, PL/SQL, SQL*Loader, SQL Tuning / Optimization, C

Languages: Pascal, Fortran, C, C++, Visual Basic 6.0, D2K

DBMS: SQL Server 2005 / 2008 / 2008 R 2/ 2012 / 2014 / 2016

Modeling tool: Visio Enterprise, IDEARA Diagnostic Tool, Service Now

Special Software: Visual Basic 6.0

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

SQL DBA

Responsibilities:

• As SQL DBA Lead, responsible for infrastructure production support activities on SQL DB Servers.
• Performing day to day Database administration activities on production servers like backup checks, space usage
• MYSQL DB administration
• Routine checks of log and trace files to trace database activities and scheduling activities.
• Creating and scheduling all DB related jobs.
• Validating and creating user accounts
• Help improve performance of queries by analyzing the execution plans, monitoring resource utilization and Database engine tuning tool to identify indexes/statistics that can help in performance tuning
• Help improve performance of queries by analyzing the execution plans, monitoring resource utilization and Database engine tuning tool to identify indexes/statistics that can help in performance tuning
• Help application team identify the blocking process by collecting information on block processes after the fact using scripts querying DMVs
• Configure Log Shipping, Replication, Mirroring and Always ON feature.
• Plan and implement Disaster Recovery strategies with effective Backup and Recovery policies, setting up replication, documenting the recovery process and a tested plan to recover the databases and users as quickly as possible.
• Migration from SQL Server 2008 to 2016.
• Monitoring day to day the performance of the DB running in the production as well as in the non-production servers.

Confidential, Glen Allen, VA

SQL DBA

Responsibilities:

• As SQL DBA Lead, responsible for infrastructure production support activities on SQL DB Servers.
• Performing day to day Database administration activities on production servers like backup checks, space usage.
• Routine checks of log and trace files to trace database activities and scheduling activities.
• Creating and scheduling all DB related jobs.
• Validating and creating user accounts.
• Help improve performance of queries by analyzing the execution plans, monitoring resource utilization and Database engine tuning tool to identify indexes/statistics that can help in performance tuning
• Help application team identify the blocking process by collecting information on block processes after the fact using scripts querying DMVs
• Configure Log Shipping, Replication, Mirroring and Always ON feature.
• Plan and implement Disaster Recovery strategies with effective Backup and Recovery policies, setting up replication, documenting the recovery process and a tested plan to recover the databases and users as quickly as possible.
• Document Backup and recovery procedures.
• Monitoring day to day the performance of the DB running in the production as well as in the non-production servers.
• Duties also included database creation, backup/recovery, general troubleshooting, script development and documentation.
• Coordinating with vendors for DB and cluster support.
• Maintaining strong partnerships and working relationships with dependent internal IT groups (Infrastructure, Database Operations, Networking, Server Support, Systems Engineering, etc.) as required.
• Preparation of documentation and procedures required for reference.
• Migration from SQL 2000 / SQL 2005 to SQL 2008.
• Providing backup assistance and support to the System admin and Web Admin.
• Working independently on any DB issues.

Environment: MS-SQL Server 2005 / 2008 / 2012 / 2014, SSIS,SSRS, SQL Enterprise manager, TL SQL, SQL Profiler, Windows 2003.

Confidential, Phoenix, AZ

SQL DBA

Responsibilities:

• Performing day to day Database administration activities on production servers like backup checks, space usage.
• Routine checks of log and trace files to trace database activities and scheduling activities.
• Creating and scheduling all DB related jobs.
• Validating and creating user accounts.
• Help improve performance of queries by analyzing the execution plans, monitoring resource utilization and Database engine tuning tool to identify indexes/statistics that can help in performance tuning
• Help application team identify the blocking process by collecting information on block processes after the fact using scripts querying DMVs
• Configure Log Shipping.
• Plan and implement Disaster Recovery strategies with effective Backup and Recovery policies, setting up replication, documenting the recovery process and a tested plan to recover the databases and users as quickly as possible.
• Document Backup and recovery procedures.
• Monitoring day to day the performance of the DB running in the production as well as in the non-production servers.
• Duties also included database creation, backup/recovery, general troubleshooting, script development and documentation.
• Coordinating with vendors for DB and cluster support.
• Maintaining strong partnerships and working relationships with dependent internal IT groups (Infrastructure, Database Operations, Networking, Server Support, Systems Engineering, etc.) as required.
• Preparation of documentation and procedures required for reference.
• Migration from SQL 2000 / SQL2005 to SQL2008.
• Providing backup assistance and support to the System admin and Web Admin.
• Working independently on any DB issues.

Environment: MS-SQL Server 2000 / 2005 / 2008, Sybase, SQL Enterprise manager, TL SQL, SQL Profiler, Windows 2003.

Confidential, Minneapolis, MN

SQL DBA

Responsibilities:

• Maintain SQL Server Production databases and ensure high availability
• Analyze slow running queries across environments and find the root cause for the same and resolve by introducing missing indexes, partitioning tables and placing them in different file groups on different drives to improve performance
• Attend requirement gathering meetings along with application team and understand the requirement or change to be incorporated in the existing
• Database objects design and normalization, review and implementation
• Support change projects where database objects are designed, reviewed and created as per change requirement and ER Diagrams produced using Erwin tool
• Interact with the client, understand and gather requirement, identify the DB objects to be modified and new objects to be created
• Manage space on database servers by proactively forecasting the DB growth
• Back databases before change implementation and ensure rollback capability
• Perform ETL operations with the help of SSIS packages for the initial setup of DBs
• Restore development and staging databases to help development team work on the current version of the database to avoid errors during production move up
• Create roles and grant permissions to users upon proper approval from business
• Ensure the change process is followed religiously and suggest changes required
• Document the changes made to the database objects and update ER diagrams
• Provided secondary DBA support for Sybase databases.
• Attend weekly change control meetings and participate in discussions

Environment: MS-SQL Server 2000 / 2005 / 2008, Sybase, SQL Enterprise manager, TL SQL, UNIX, SQL Profiler, Windows 2003.

Confidential, Phoenix, AZ

SQL DBA

Responsibilities:

• Performing day to day Database administration activities on production servers like backup checks, space usage.
• Routine checks of log and trace files to trace database activities and scheduling activities
• Creating and scheduling all DB related jobs
• Validating and creating user accounts
• Performance tuning
• Resolving deadlocks
• Duties also included database creation, backup/recovery, general troubleshooting, script development and documentation.
• Coordinating with vendors for DB and cluster support.
• Maintaining strong partnerships and working relationships with dependent internal IT groups (Infrastructure, Database Operations, Networking, Server Support, Systems Engineering, etc.) as required.
• Preparation of documentation and procedures required for reference
• Migration from SQL 2000 / SQL 2005 to SQL 2008
• Providing backup assistance and support to the System admin and Web Admin.
• Working independently on any DB issues.

Environment: MS-SQL Server 2000 / 2005 / 2008, Sybase, SQL Enterprise manager, PL SQL, UNIX, SQL Profiler, Windows 2003.

Confidential

SQL DBA

Responsibilities:

• DB Backup, Integrity Checks / Optimization etc. implementation.
• Database Consistency Checks & Index corruption issue handling.
• Creation of Complex Stored Procedure to extract data from database and to populate the fields .
• SQL Query Analysis, tuning, optimization.
• Daily Conference calls with Customer to update the proceedings and highlight any issues incurred.
• Testing the Stored Procedure.

Environment: MS-SQL Server 2000 / 2005 / 2008, Sybase, SQL Enterprise manager, PL SQL, UNIX, SQL Profiler, Windows 2003.

Confidential

SQL DBA

Responsibilities:

• Preparation of Database Migration Design Document
• Preparation, Execution and Testing of Database Migration scripts.(G2 database to G4 Poland).
• Most of the scripts created are using the features BCP OUT / IN.
• Implementation of DB Backups thru Database Maintenance Plan.
• Database Migration
• Database Related Issue Debugging & Troubleshooting.
• Security Administration
• Schedule Jobs & DTS Packages in MS-SQL Server.
• Onsite / Offshore co-ordination.

Environment: MS-SQL Server 2000 / 2005 / 2008, Sybase, SQL Enterprise manager, PL SQL, UNIX, SQL Profiler, Windows 2003.

Confidential

SQL Developer

Responsibilities:

• Data collection/data migration for US sites (California and Texas)
• Developing small interfaces to automate the data load process. configuration of all the applications creation of Areas, Sites, Workspaces, Document Management, Customising Share Point Searches, Creation of Site templates
• Onsite / Offshore Coordination

Environment: MS-SQL Server 2000 / 2005 / 2008, Sybase, SQL Enterprise manager, PL SQL, UNIX, SQL Profiler, Windows 2003.

Confidential, Texas, Carson, CA.

SQL Developer

Responsibilities:

• Data collection/data migration for US sites (California and Texas)
• Developing small interfaces to automate the data load process. configuration of all the applications creation of Areas, Sites, Workspaces, Document Management, Customizing Share Point Searches, Creation of Site templates
• Onsite / Offshore Coordination

Environment: MS-SQL Server 2000 / 2005 / 2008, Sybase, SQL Enterprise manager, PL SQL, UNIX, SQL Profiler, Windows 2003.

Confidential

SQL Developer

Responsibilities:

• Analysis of the Application Understanding Document for the applications that fall under this downstream.
• Handle all the request and problem tickets that come to offshore for the five applications mentioned below within the specified SLA’s. The applications that I handled are,
• Standard Codes Data Base (Silver Application)
• Retail Site Data Base (Silver Application)
• Chargeback Fraud (Silver Application)
• Surplus Land (Lead Application)
• CRT (Lead Application)
• Performing the Lights On Activity building of interfaces for migration of
• Legacy applications to SAP

Environment: MS-SQL Server 2000 / 2005 / 2008, Sybase, SQL Enterprise manager, PL SQL, UNIX, SQL Profiler, Windows 2003.