SUMMARY

• Around 10 years of Technical Expertise in Database Administration and Development for very large and complex databases on SQL Server 2016/2 /2005/2000 with complex Enterprise Application Environment.
• Experience in Mortgage, Retail, Insurance, Manufacture and logistics domain projects.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong experience in mentoring team members, managing the offshore team and project management.
• Well versed with vendor management.
• Experience in analyzing Locks, Dead Locks and expertise in resolving Dead locks.
• Experience in high availability SQL Server solutions, including Log Shipping, Replication, Mirroring
• Hands on experience in implementing FULL, TRANSACTION and DIFFERENTIAL and Tail Log Backups. Also by scheduling the jobs and Maintenance Plans.
• Very good exposure to Failover clustering for Active/Active and Active/PassiveSQLServer 64 - bit environment.
• Experience in resource governor implementation to prioritize the users.
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load and Created extensive reports using SSRS.
• Developed Cubes usingSQLServer Analysis Services (SSAS).
• Experience in Server administration in various environments - Window 2000, 2003, 2008 and 2012 with Active Directory Services (AD, DNS, and DHCP).
• Strong experience in handling multiple server instances and more than two terabyte size databases.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, DBCC commands and event viewer for performance analysis.
• Experience in data modeling for OLTP and date warehouse using MS Visio and Erwin.
• Expertise in planning and implementing MS SQL Server Security and database Permissions.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Worked on 2014 new features like In-Memory OLTP (Hekaton), AlwaysOn Enhancements, etc.
• Extensive knowledge in capacity planning
• Experience in Data Migration from MS ACCESS 2000/2003 to MS SQL server 2005, MS SQL server and from .
• Involved in Migrating MYSQL to SQL Server 2008/2012 databases.
• Technical expertise in installing database security patches and service packs.
• Very strong Experience in T-SQL programming tasks like developing Stored Procedures, Functions, and Triggers, ad-hoc queries for reports, TSQL batches, PowerShell scripts.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models and E-R Diagrams.
• Experience in handling very large databases in OLTP and data warehouse environments, which are in Terabytes size and troubleshooting the problems.
• Experience in 24/7 production support for all SQL server databases.
• Maintenance of Database recovery model - Full/ Bulk-Logged and Transactional log.
• Experience in configuring and managing Linked Servers betweenSQLserver and other RDBMS like Oracle, Sybase and MySQL or by using ODBC connectivity.
• Good knowledge in Oracle 10/11G and Unix/Linux.
• Good interpersonal skills, committed team player with team driven skills.
• Good communication skills, written and verbal presentation skills.

TECHNICAL SKILLS

Databases & Services: SQL Server 2000/2005/2008/2012/2014, Oracle 10/11G, MYSQL 4.1/5.1/5.5, Sybase, MongoDB, SSIS, SSRS, SSAS, Database Tuning Advisor, SQL Server 2000/7.0, T-SQL, MSDE, OLAP, Query Analyzer, SQL Profiler, Performance Monitor, Index Tuning, Replication, DTS, BCP, Agent, Jobs, ODBC, JDBC

Programming/Scripting: T-SQL Programming, C, C++, VB, Java

Operating Systems: Windows XP/NT/ 2000/2003/2008/2012, Vista, UNIX

Microsoft Office suite: Word, Excel, Power Point, Outlook, Access, Visio, MS-Project.

Protocols: TCP/IP, HTTP, FTP, SSH, TELNET

Virtualizations: VMware vSphere client, Citrix Client

PROFESSIONAL EXPERIENCE

Confidential, Coppell, Texas

Sr. SQL Server DBA/ Developer

Responsibilities:

• Database analysis to identify business impacts and need to prepare detailed database design for new enhancements and full fill the business requirements.
• Designing security architecture in assigning database roles, schema privileges, table and column level permissions.
• Responsible for managing onsite and offshore team and project management
• Provide best practice documents to the team
• Assign the task to individual team members
• Manage 24/7 production database support and involve in 3rd and 4th level DBA escalations.
• Responsible for Data migration between MS SQL Server and different environment using SSIS and maintain data integrity in target systems. Responsible for all ETL jobs.
• Schedule SQL jobs for daily/weekly/monthly activities. Troubleshoot the SQL jobs for any data and technical issues.
• Manage multiple server instances and databases with terabyte sizes.
• Responsible for Plan, design and implementation and support of DEV, UAT and Production and Unit Testing.
• Implemented and Scheduled Replication process for updating our parallel servers.
• Responsible for capacity planning of all SQL servers.
• Responsible for database backup plan implementation and troubleshooting the issues.
• Bug fixing for previous development technical issues
• Used Execution Plan,SQLProfiler and Database engine tuning advisor to optimize queries and rebuild Indexes andfine tuningStored Procedures to enhance the performance of Databases and memory management
• Responsible for writing scripts/stored procedures from marketing campaign management waterfall process.
• Involved in Optimization and normalization of database and tables.
• Part of team for analyzing and implementing the physical design for database.
• Implemented log shipping to support DR servers and Prepare documentation for the Disaster Recovery plan.
• Responsible for resolving blocking and dead lock issues.
• Implemented resource governor to prioritize the users.
• Configuring and troubleshooting Linked Servers.
• MonitoringSQLServer performance usingSQLProfiler client and server trace, task manager and resource monitor.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS)
• Responsiblefor report design and developments
• Scrub report design, development and unit testing using SSRS
• Leads report design, development and unittestingusing Power BI
• All eligible and marketable report development in Cognos.
• Collaborated across multiple business units to build strong relationships with key internal stakeholders and business partners to address organizational needs, ensure that business requirements and fulfillment processes met client needs, and evaluate usability of solutions.
• Responsible for data cleaning and marketing campaign data issues.
• Plan, design and implement the data purge/archival jobs.
• Involved in all major root cause analysis like leads report issues, campaign report issues and vendor’s data miss match issues.
• Functional and system design document preparation

Environment: Citrix, Windows 2016/2012, MS SQL Server 2016/2014/2012, SSIS, T-SQL, MongoDB, Power PI with cloud, Cognos 8 / 10

Confidential

Sr. SQL Server DBA/ Developer

Responsibilities:

• Responsible for management of three environments like DEV, UAT and PROD.
• Responsible for OS event logs and SQL server logs check for unusual events, verify all scheduled jobs.
• Monitor disk space to ensure your SQL Servers won’t run out of disk space. Periodically monitor performance using both System Monitor and Profiler/SQL Trace.
• Responsible for design and comprehensive backup plan implementations. Login creation and appropriate credentials assignment for business users and management of SQL agent jobs.
• Responsible for disaster recovery implementation and security management operations.
• Install and administrate Active/Passive cluster on Microsoft Windows Server 2012 Enterprise Edition and database audit
• Using Performance Monitor/Profiler to solve Dead Locks/Long running queries. Provide the proper solution for the loop holes. Resolve the performance issues like blocking and deadlocking issues.
• Responsible for DB performance improvement activities.
• Responsible for new design for production data archive job and resolved index fragmentation problem issue.
• Implementation of resource governor to prioritize the users.
• Successfully implemented database mirroring between Primary server and Mirror Server.
• Responsible for data model changes.
• Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans.
• Providing 24x7 technical database supports for SQL Database systems.

Environment: MS SQL Server 2012, Windows 2012 Server Operating systems, IIS 6.0, .NET, T-SQL, MongoDB

Confidential

SQL Server DBA/ Developer/Data Modeler

Responsibilities:

• Responsible for database environment setup and Management of five environments like DEV, SIT, UAT, STAGE and PRODUCTION.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Responsible for reports development using SSRS and develop stored procedures and views.
• Responsible for leads reports development using Cognos.
• Responsible for any Data model changes (Used AAI as reference model).
• Responsible for database performance tuning; Query Optimization, using Performance Monitor, SQL Profiler.
• Design and implement backup plan strategy as per the business requirement. Monitor replication and resolve the related issues. Implement operational automation using T-SQL scripts.
• Co-ordinate with front end and middleware developers for database requirements and create the required objects in database and populate the data.
• Performing SQL server daily health check and preparing a report based on it.
• Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.
• Handling creation of new SQL Server databases as per Client/Application Team request using Build Sheet Template.
• Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
• Applying Service Packs and Security patches for the Servers as released.
• Installed SQL Server 2005/2008 on Active/Passive and Active/Active clusters as part of Upgrade.
• Monitoring the Log Space for successful execution of all the specified jobs.
• Managing backups on a daily basis and recovery (as per request).
• Reviewing SQL Server and SQL Server Agent Error Logs.
• Monitoring of server performance by profiler during peak periods of server utilization.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies and also preparing Auditing Reports for following auditing standards.
• Configuration and Maintenance of Log Shipping, Mirroring & Replication across different environments.

Environment: SQL Server 2005, SQL Server 2008 R2, SSIS, SSRS, Windows 2008, Windows 2003 EE, Cluster. Cognos 8

Confidential

Oracle DBA/ Developer

Responsibilities:

• Profile creation, schema and role to implementation for better secure accessibility of database.
• Creating table spaces and assigning to different users.
• Replica database server setup for production server
• Coordination with on site team for database issues and get it resolve.
• Creation & administration of all database objects, including tables, indexes, views, sequences, packages, procedures

Environment: Oracle 10g, PL/SQL, UNIX, MS Word, and Windows XP

Confidential

SQL DBA/ Developer

Responsibilities:

• Responsible for requirement analysis: analyzing PERL scripts and extracted business rules.
• Database and user creation and provide access for users as per their role in the project.
• Create and modify table schema as per client requirements. Regular database backups for CCP database
• Responsible for Migration of stored procedures from Sybase to MS SQL 2005.
• Involvement in stored procedures performance improvement.
• Remove the triggers which were created for referential integrity in Sybase and drop all those triggers to reduce overhead and handle by adding referential integrity between the tables in MS SQL server (with some addition of audit columns in all tables).
• Responsible for complete basic unit testing for all stored procedures.
• Used DTS service for the data transformation from source to target database.
• Created complex stored procedures, triggers and cursors in SQL Server.
• Developed source to target specifications.
• Created DTS package to schedule the jobs for batch processing.
• Scheduled the DTS packages using the Data transformation services SQL2005.
• Performance tuning to optimize SQL queries using query analyzer.

Environment: MS SQL Server 2005, MS SQL Server 2000, Windows Server 2003, SSIS, Transact-SQL, DTS,Sybase,MY SQL

Confidential

SQL DBA/ Developer

Responsibilities:

• Creation of System Appreciation Documents which contains detail description of Database objects.
• Creation of Data dictionary for each database.
• Creation of Master Data dictionary.
• Understanding the functionality of the Application.
• Study of Queries, Macros, Modules and other Objects
• Development of Functional and data flow diagrams.
• Design Database to consolidate all MS ACCESS Database.
• Migrate the macros to procedures and functions using T-SQL
• Creation of Test Production server.
• Utilized SQL scripts and complex queries to analyze and extract data.
• Supported business applications using T-SQL.
• Provided database coding support using SQL server environment.
• Modified existing applications to ensure data integrity and security.
• Implementing backup strategy as per the business plan
• Ensuring all databases are backed up on regular basis
• Database performance tuning - Identifying the areas where performance improvements are possible
• Root cause analysis for database issues

Environment: MSACCESS 2000/2003, MS SQL Server 2005, Windows Server 2000/2003, MY SQL 5.6