PROFESSIONAL SUMMARY:

• Certified Microsoft SQL Server 2016/2014/ 2012/2008/2005 DBA with 9+ years of quality experience.
• 7+ years of experience in handling production systems in 24/7 environment (rotating on - call)
• 7+ years of experience in Administering and managing Databases ranging several gigabits.
• Expert in managing multiple instances of database servers on-site and remotely
• 1 year of Oracle Database(10g) administration
• 6 month of DB2 database(9.7) administration
• Installed and configured MS SQL Server 2016/2014/ 2012/2008/2005 and 2000 systems in all environments
• Installed security patches, services packs and hot fixes for windows and SQL Systems
• 8+ years of experience upgrading and migrating SQL Systems from lower version to higher version
• 7+ years of experience in using SQL Server Agent for creating and scheduling complicated jobs
• 7+ years of experience in handing SQL Server systems in Clustered environments
• 7+ years of experience in performance tuning MS SQL Server 2016/2014/2012/2008 for best performance
• Expert in fine tuning parameters on operating systems
• Expert in using SQL Server 2012/2008/2005 profiler trace for bottlenecks and long running queries
• Excellent knowledge in fine tuning stored procedure for super performance
• Excellent knowledge in fine tuning queries taking a long time
• Good knowledge in understanding query plans and statistics data
• Excellent knowledge of implementing Column store Indexes for SQL 2012 and 2014.
• Expert in Creating, Suggesting and implementing Indexes (Clustered, Non-Clustered, Unique)
• Expert in verifying output of Query Execution Plan and suggesting changes
• 5+ years of experience in using tuning wizard in MS SQL Server 2016/2014/2
• Expert knowledge in clustering and mirroring
• 6+ years of experience in capacity planning and implementing solid backup strategy for all SQL Server
• Timely full backup and transaction log backup for all production, development & QA systems
• Implemented AlwaysOn for SQL 2016/2014/2012 and SQL Clustering for MS SQL 2016/2014/2008.
• Expert in implementing log shipping, mechanism (Manual & Wizard)
• Worked extensively on MS SQL Server 2005/2008 Integration Services (SSIS)
• 3+ years of experience in SSIS, SSRS and SSAS
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
• Used containers for repetitive control flow tasks
• Scheduling package execution in SSIS
• Installing packages on multiple servers in SSIS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Used SSRS to Reporting for a Data warehouse system
• Extensive use of DMV’s in MS SQL Server 2008/2005
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models.
• 4+ years of experience in writing stored procedures, triggers and functions having complicated logic
• 5+ years of experience in writing views and cursors and using temporary tables for performance

TECHNICAL SKILLS:

RDBMS: SQL Server 2016/2014/2012/2008 R2/2005/2000, Oracle 11g, DB2 LUW 10.5/9.7

Hadoop: Limited knowledge of Hadoop cluster, HDFS, Hive SQL MapReduce

Database Tools: Management Studio, BI Development Studio, SQL Profiler, Data Transformation Services (DTS), SQL Server Integration Service (SSIS), SQL Server Analysis services (SSAS), SQL Server Reporting services (SSRS), Erwin, Microsoft Visio, ER studio. DBArtisan

Languages: SQL, TSQL,PL/SQL, Visual Basic 6.0, HTML, PowerShell Script, R programming, limited knowledge of Python and Java.

Tools: MS-Front Page, Internet Information Server (IIS), MS-Outlook Express.

Applications: Microsoft Office, Erwin, MS VISIO 2003/2005, Symantec Netbackup 7.1, Tivoli Data Protection (TDP), SQL LiteSpeed, Quest Foglight, Toad 5.7, Idera, Confidential Data Studio 4.1,Autosys,SCCM,SCOM

Operating Systems: Windows 95/98/2000/2003/2008/2012, Windows 7/XP, Linux, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Microsoft SQL DBA/ Distribution Development DBA

Responsibilities:

• Responsible for 24*7 Critical Production Support for more than 100 servers.
• Installed SQL Server 2016, 2014, 2012 and 2008R2 on windows 2008 and 2012 servers, Installed service packs and security fix on production, test and development servers.
• Installed, configured and maintained always on Availability for Sharepoint2016 for local datacenter failover and across datacenter failover.
• Involved in configuring and creating DB hardening standards for SQL servers.
• Involved in monitoring the backup jobs and fixed the failed jobs.
• Configured and maintained 4 node A/P SQL cluster for 2016 version
• Implemented SQL audit and server audit as a part of SQL hardening projects.
• Created and implemented SSIS package to load data and send monthly and quarterly reports to external customers.
• Configured, deployed maintenance plan using Litespeed console for SQL servers.
• Troubleshoot SSIS packages.
• Actively worked with Distribution development team to roll out new version of Confidential Connect direct.
• Provide development support for Real -Time Payment (RTP) application.
• Upgraded SQL server from /2014.
• Implemented extended events for customized SQL servers monitoring.
• Configured database partitioning.

Confidential, Jersey City, NJ

Sr. Microsoft SQL/DB2/Oracle DBA

Responsibilities:

• Responsible for 24*7 Critical Production Support and development support for more than 400 servers
• Installed SQL Server 2016, 2014, 2012 and 2008R2 on windows 2008 and 2012 servers, Installed service packs and security fix on production, test and development servers.
• Installed, configured and maintained always on Availability. Installed and configured Transaction replication
• Involved in configuring and maintaining DB Mirroring and log shipping for production environment.
• Involved in monitoring the backup jobs and fixed the failed jobs.
• Created backup strategies for multiple environments
• Implemented Column store index for SQL 2012 databases
• Involved in implementing Temporal tables for SQL 2016 databases and CDC for SQL 2012 databases.
• Created and deployed SSIS packages to multiple environment.
• Involved in securing SQL Servers and assign the permissions for users and roles.
• Tuning of SQLqueries for (AML) application
• Involved in capacity planning for SQL Server
• Configured Alwayon availability group as part of high availability solution
• Migration of SQL 2005 to SQL 2008R2/2012.
• Configured Service broker technology and Change Data Capture (CDC).
• Provided DB2 administration support for DB2 LUW.
• Copy DB2 data using import/export and load utility
• Involved in DB2 database backup and restore(Circular and archive log backup).created and maintaining tablespaces for DB2 database
• Setup federated connection to push data from DB2 to SQL server
• Worked on installing cluster, commissioning & decommissioning of datanode, namenode recovery, capacity planning, and slots configuration.
• Loaded the dataset into Hive for ETL Operation.

Environment: SQL server 2016/2014/2012/2008 R2, DB2 9.7/10.1, Idera safe backup, Visual studio 2012, T-SQL, Team foundation server 2013, DB Mirroring, Always-on HADR,Log shipping, T-SQL and powershell.

Confidential

SQL Developer/ DBA

Responsibilities:

• Involved in creating and modifying Stored Proc, tables, view and SSIS packages
• Involved in creating Package configuration files to deploy the SSIS packages across multiple environments
• Used multiple SSIS packages for collecting data from heterogeneous sources like Excel, CSV, flat file, Text Format Data to SQL Server databases using SSIS and loading to staging server.
• Created SSIS packages to Load data from sources like Flat file, Excel, OLE DB to different destination like OLE DB, Flat file Destination created providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
• Responsible for creating dynamic SQL to generate data report
• Responsible for managing SQL jobs and resolving issue for 2nd lien modification mortgage process

Environment: Visual Studio 2008/2010, Team Foundation Server, SQL Server 2008R2, AutoSys, T-SQL

Confidential, North Carolina, NC

SQL DBA/ Developer

Responsibilities:

• Responsible for more than 140 SQL Servers including 98 production servers and 36 test and development servers.
• Managed PRODUCTION, DEVELOPMENT and QA Environments, with multiple SQL Server instances in SQL Server 2008 R2/2008 and 2005 environments.
• Installed SQL Server 2008 and SQL Server 2005 on windows 2003 and 2008 servers, applied service packs and security fix for all servers.
• Managed SQL Servers in Clustered environments. Configured 2/3 node Active/passive and active/active SQL Cluster on 2008 R2
• Configured and managed transaction replication
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments
• Mirroring server with high availability
• Experience in upgrading from SQL Server 2000 to SQL Server 2005 servers.
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008
• Migrated Databases from oracle 10g to SQL 2008R2
• Worked on SSIS, SSAS and new features of SQL Server 2005/2008 servers.
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Used containers for repetitive control flow tasks
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Scheduled package execution in SSIS
• Installing packages on multiple servers in SSIS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans. performing administrative tasks such as backup and restore using NetBackup and Tivoli Storage Manager
• Develop, analyze and/or tune Transact-SQL objects to optimize server performance.
• Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic T-SQL.
• Written Stored Procedures to display the data in front end application.
• Utilized T-SQL on a daily basis in creating customs view for data and business analysis.
• Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
• Optimize existing T-SQL code.
• Analyzed Execution Plans to troubleshoot potential performance issues.
• Utilize Dynamic T-SQL within functions, stored procedures, views, and tables.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with database sizing and capacity planning for production servers.
• Experienced with creating logical and physical database design for development projects.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Involved in securing the SQL Server environment and involved in setting up the user permissions.
• Experienced with creating database maintenance plans for efficient operations.
• Created the backup schedule for production, test and development servers.
• Worked with developers to do the database schema changes and database restore request.
• Involved in restore operations to refresh the data from production to test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: MS SQL Server 2008/2005, Windows 2000/2003/2008 Server Operating systems, SSIS, SSAS, SSRS,T-SQL.

Confidential, Philadelphia, PA

MS SQL Server 2008/2005/2000 DBA

Responsibilities:

• Installed SQL Server 2008 on windows 2008 servers, applied service packs and security fix.
• Experienced in configuring and maintaining transaction and snapshot replication to replicate the data to remote servers.
• Involved in troubleshooting SQL Server production issues. Worked with the report team to fix the reporting issues. determined root cause of performance deviation by using Quest Foglight performance analysis for SQL Server
• Involved in configuring SQL Server to run in best optimal conditions.
• Created the new database design for development projects, worked with SQL Developers to create the applications.
• Experienced in creating database backup strategy and implemented for production, test and development servers.
• Created the maintenance plan for SQL Server database optimization and integrity checks for production servers.
• Configured and maintained the 2 log shipping environments to create the backup server.
• Involved in creating work requests and change management using remedy software.
• Experienced in improving SQL Server performance using performance monitor.
• Designed the DTS packages to import and export the data between oracle and access databases to MS SQL Servers.
• Involved in tuning the SQL Server stored procedures using index tuning wizards, profiler and SQL Query analyzer.
• Created the work instructions to install and configure SQL Server 2000, service packs, security fixes.
• Experienced in restoring the production databases to restore critical production data when disaster happens.
• Worked in team environment and involved in on call rotation schedule to support production servers.

Environment: MS SQL Server 2000/2005/2008, Windows 2000/2003/2008 Operating Systems, Quest Foglight

Confidential, Cincinnati

MS SQL Server 2005/2000 DBA

Responsibilities:

• Responsible for 24*7 Critical Production Support for 120 servers out of which 90 servers are production servers, remaining test and development servers.
• Installed SQL Server 2000 and 2005 on windows 2000 and 2003 servers, Installed service packs and security fix on production, test and development servers.
• Installed, configured and maintained MS SQL failover clustering for 2 mission critical servers
• Involved in monitoring the backup jobs and fixed the failed jobs.
• Created manual Log shipping environments for standby servers.
• Involved in securing SQL Servers and assign the permissions for users and roles.
• Designed the logical and physical database design for development projects using Erwin data modeling tool.
• Configured and maintained two log shipping environments to create the backup server.
• Involved in improving the server performance using Performance monitor using I/O, memory and CPU counters.
• Experienced in involving SQL Server performance using index tuning wizards, SQL Profiler and SQL Query Analyzer.
• Created the DTS packages to import and export the data from Oracle, MS Access and text files to SQL Server.
• Created the standard operating procedures (SOP) for SQL Clustering, replication and log shipping.
• Experienced in creating backup strategy for production, test and development servers.
• Configure, setup and maintain SQL DB backup and restore using NetVault Litespeed
• Involved in disaster recovery procedures and restore the production databases.
• Involved in database restore requests and refresh the database between productions, test servers.
• Created the maintenance plans for integrity checks and optimization for production, test and development servers.
• Tunes SQL queries and stored procedures to improve the SQL Server performance.

Environment: MS SQL Server 2005/2000, Windows 2000/2003 Server Operating systems, SSIS, SSAS, SQL Litespeed