SUMMARY:

• Over 11 years of expertise as results - driven project and database management professional with first-rate skill in directing full cycles for complex, multi-site programs. Expertise in Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000 and 7.0 in Production, Test, Development environment.
• Extensive working experience in Government Client and various industries Automobile, Financial, Energy Sector, Arts Performing and Healthcare industry, including designing, implementing, maintaining and documenting complex database applications.
• Experience with software development life cycle (SDLC) and project methodologies.
• Managed a major Hardware Upgrade / Database Migration.
• Performed Capacity Planning, data modeling and Logical/Physical database Design.
• Experience in Database Backup, Recovery and Disaster Recovery procedures (Clustering, Log Shipping, Replication, Mirroring and Always-on Availability Group).
• Experience in installing and configuring SQL Server 2012/2008 R 2/2008/2005/2000 clusters in Active/Active and Active/Passive.
• Experience with SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005 installation, configuration, SSIS, SSRS, MOSS 2007 and administration.
• Involved in updating Windows Patches and SQL Server Patches on different versions of Windows Operating System and SQL Server.
• Involved in migrating databases from SQL Server 2000 to SQL Server 2005, 2008 and from SQL, 2008 R2 (Side by Side), 2008, 2008 R2 to 2012 and 2014.
• Proficient with SQL Server tools, including Enterprise Manager, Management Studio, Query Analyzer, Profiler, SQL Server Agent, Performance Dashboard, BIDS, DTS, SSRS, SSIS and SSDT.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including Database Mirroring, SQL Server Log shipping and SQL Server clustering.
• Experience in Replication - Transactional, Peer-to-Peer, Snapshot and extensive knowledge in Merge replication.
• Experienced in programming tasks Stored Procedures, Triggers and Cursors using SQL Server 2014/2012/2008 R2/2005/2000 with T-SQL.
• Experience in working on Database level encryption and Data level encryption.
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Errors, and Event Handling.
• Experienced in writing T-SQL (DDL, DML, and DCL). Expert in implementing business logic in backend. Reviewing T-SQL code, maintaining coding standards in all SQL Server environments.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks & Blocking.
• Managed Amazon web services(AWS) in different data centers US East (N. Virginia) and US West (Oregon)
• Experience in AWS design and Administration with knowledge in RDS and EC2.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
• Proficient with database backup and recovery models.
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Having experience in third party tools LiteSpeed, Idera, RedGate Foglight and Spotlight.
• Installed and Configured TortoiseSVN and pulled the files from SVN to our local folders.
• Download the production going scripts from AHP and prepared the implementation instructions.
• Managed GitHub and GIT Bash tools, pull the folders and SQL files from GIT source.
• Worked on Jenkins to download SQL Scripts using Token number and prepared the implementation instructions.
• High level plan for securing all the databases and better control on all SQL Servers.
• Involved in creation of linked servers using remote user account.
• Industry working experience in SQL Server and Oracle database management, maintenance, and troubleshooting.
• Worked on VMware machines.

TECHNICAL SKILLS:

Relational Databases: SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000/7.0 , Oracle 9i, Oracle 8.0, MS Access 2000, DB2, SQL*PLUS

Operating Systems: UNIX, Windows Server 2012, 2008 and 2003, Windows Server 2000, Windows NT 4.0, Windows XP

Languages: C, C++, PL/SQL, Java, VB 6.0 and T-SQL

Web Technologies : ASP.NET, VB.NET, Web Services, HTML, DHTML, Java Script, VBScript, IIS 4.0, IIS 5.0, Application Server

Other Tools: Crystal Reports, Test Director 7.0/7.5/8.0, PVCS Tracker 7.0Rational Clear Quest

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Sr SQL Server Administrator

Responsibilities:

• Experience in installation of SQL Server 2016/2014/2012 Enterprise and Standard Edition in newer environments.
• Extensive knowledge about 2016 new features like Always Encryptions, Dynamic Data Masking, Multiple Tempdb files during the time of installation, Row Level Security and Query store feature, etc.
• Worked on supporting multiple applications like OPUS/Empower, CDS, SDS and MSP.
• Extensive experience in working on high availability and disaster recovery plans like Mirroring, Replication and Always-on Availability Group.
• Worked on creating databases for developers and giving them appropriate permission on dev environment.
• Apply latest services packs on all Dev, QA, UAT and Production servers.
• Working on Data Center Migration of moving all databases from ING to COF domain.
• Reviewing SQL scripts provided by developer execute them in QA and UAT; update CO with Implementation instruction for production deployment.
• Worked on Monthly Sprint release that comes every first week of the month.
• Involved in Weekly Production release deployments like OCR\BAU\EMR on weekly basis.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in monitoring the SQL Server Performance issues using third party tools like Diagnostic Manager and Performance Analysis.
• Daily task to verify the backup jobs and maintenance jobs are running fine.
• For Every sprint I have prepared DevRoot, QARoot and QA1Root database for SQL Servers.
• Compare using RedGate tool from Prod to UAT and UAT to QA sync any differences at data level and object level, this is monthly maintenance to Sync all environments.
• Involved in User requested tickets to execute the scripts both DML and DDL operations on QA and Production environment.
• Worked on daily compare with QARoot and DevRoot to local database, if any changes occurred revert the changes to QARoot settings.
• Extensive experience with AWS (AWS Cloud Formation, AWS ECS and EC2)
• Managed databases on RDS and EC2 environment.
• Managed Amazon web services(AWS) in different data centers US East (N.Virginia) and US West (Oregon)
• Migrated the databases, logins and jobs from On-premises servers to RDS AWS.
• Designed, Implemented and Migrated databases to AWS.
• Installed and Configured TortoiseSVN and pulled the SQL files from SVN to our local folders.
• Download the production going scripts from AHP and prepared the implementation instructions.
• Managed GitHub and GIT Bash tools, pull the folders and SQL files from GIT source.
• Worked on Jenkins to download SQL Scripts using Token number and prepared the implementation instructions.
• Prepared Self-Paced Cassandra through Datastax.
• Completed the courses of “Introduction to Apache Cassandra” and “DS201: Datastax Enterprise Foundations of Apache Cassandra”
• Created tables under the KeySpaces using CQL Fundamentals, with clustering columns, Primary keys, partition keys.
• Import/Export data from CSV using CQL statements.
• Extensive on Cassandra features like Replication factor, Ring, peer to peer, Vnodes, gossip, snitch, consistency and Hinted Handoff.
• Worked on third party tools like AnthilPro, Kanban and RegGate Tool to support daily work.

Confidential, Baltimore, MD

Sr SQL Server Administrator

Responsibilities:

• Experience in installation of SQL Server 2012 and SQL Server 2014 in newer environments.
• Configured Always-On Availability Groups (SQL Server) on both 2012 and 2014.
• Experience on supporting Active/Passive clustering environment.
• Worked on supporting multiple applications like Moxy, APX, Galileo, CRD, Salerio and Automate.
• Experience in setting up Disaster recovery and High availability plan on Always-on Availability group.
• Experience in applying SQL Server Service Packs to the latest version 2008 R2 and 2012 servers.
• Experience in working on VMWare and Stand-alone servers.
• Extensive experience in setting up and troubleshooting Mirroring, Log shipping and transactional replication.
• Create Databases on SQL AZURE.
• Setting up SQL Azure Firewall
• Create, manage SQL Server AZURE Databases
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers
• Daily task to verify the backup jobs using Symantec backup exec, Native backups and troubleshoot them if the jobs are failed.
• Assign Support Request Management tickets and complete the work as requested.
• Worked on multiple internal projects to support application team to fulfill their needs.
• Involved in monitoring the SQL Server performance issues using third party tools like Spotlight and Performance Analysis.
• Worked on Production servers and troubleshooting them as needed.

Confidential, Gaithersburg, MD

Sr SQL Server Administrator

Responsibilities:

• Experience in installation of SQL Server 2008 R2 and SQL Server 2012 in newer environments.
• Experience in applying SQL Server Service Packs to the latest version on 2008, 2008 R2 and 2012 servers.
• Worked on migrating SQL Server Databases from SQL 2005, 2008 R2 to SQL 2012 version.
• Successfully migrated around 50 databases to SQL 2012 version.
• Experience on supporting Active/Active clustering environment.
• Experience in working on VMWare and Stand-alone servers.
• Extensive experience in setting up Snapshot, Log shipping, Transactional and Merge replication.
• Worked on setting up mirroring from internal domain to external domain.
• Daily task to verify the backup jobs and troubleshoot them if the jobs are failed.
• Assign Service-now tickets and complete the work as requested.
• Worked on decommissioning the databases which are not required using service-now tickets, also filling up the decommissioning request form.
• Worked on multiple internal projects to support application team to fulfill their needs.
• Worked on collecting all application users and their information are uploaded to SQLInventory database for immediate contacts.
• Involved in monitoring the SQL Server performance issues using third party tools like Foglight and Performance Analysis.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Worked on requesting firewall ports open from external domain to internal domain.
• Worked on data compare using TOAD for SQL.
• Assign Service-now tickets and complete the work as requested.
• Worked on Production servers and troubleshooting them as needed.
• Involved with users and executing the scripts on Production environment.
• 24/7 on call support.

Confidential, New York, NY

Sr SQL Server Administrator

Responsibilities:

• Involved in supporting high availability concepts like Clustering, Mirroring, Replication and log shipping.
• Experience in installation of SQL Server 2008 R2 and SQL Server 2012 in newer environments.
• Experience in applying SQL Server Service Packs to the latest version on 2008, 2008 R2 and 2012 servers.
• Experience in working on VMWare and Stand-alone servers.
• Involved in troubleshooting the performance issues like memory pressure, High CPU utilizations and Disk IO’s at SQL Server level.
• Extensive experience in setting replication, mirroring and log shipping.
• Involved in Capacity Planning, data modeling and Logical/Physical database Designs.
• Daily task to verify the backup jobs and maintenance jobs are running fine.
• Worked on space reports for all servers and request the space if it is required, to maintain below 70% of space occupied.
• Experience in generating the reports and running scripts using central management servers.
• Worked on setting-up the multi-server administration to manage target servers from centralized server.
• Scheduled the Maintenance jobs, Native backup jobs and “shrink transactional log file” jobs from Multi-Server Jobs.
• Assign Service-now tickets and complete the work as requested.
• Experience in handling multiple internal projects at a time and implemented them successfully.
• Worked on Critical Business requirements to execute SQL scripts on Production servers using emergency change request.
• Involved in User requested tickets to execute the scripts both DML and DDL operations on UAT and Production environment.
• Worked on privilege tickets to provide read, write and execute permissions on windows and SQL Logins.
• Maintain Azure SQL databases using the Elastic Database tools.
• Moved data from a multi-tenant database to a single-tenant database using Elastic database tools.
• Maintain Elastic database jobs, queries and run transactions that span several databases in Azure SQL database.
• Experience in decommissioning the old servers and databases which are not required using service-now tickets, also filling up the decommissioning request form.
• Worked on requesting Firewall ports to be open to connect SQL Server machines.
• Extensive experience in Idera backup tool which has policy based schedules.
• Involved in monitoring the SQL Server performance issues using third party tools like Foglight and Performance Analysis.
• Also, have experience in using performance dashboard reports in SQL Server.
• Experience in supporting DR servers to confirm that servers are functioning properly.
• 24/7 on call support.

Confidential

Sr SQL Server Administrator

Responsibilities:

• Involved in supporting high availability concepts like Cluster services and Network Load Balancing servers (NLB).
• Experience in applying Windows Patches and SQL Server Service Packs to the latest version.
• Setting up peer-to-peer topology and transactional replication between SQL Server databases.
• Involved in supporting SQL Server 2000, 2005 and 2008 servers.
• Troubleshooting Replication errors, Blockings and tuning long running SQL queries.
• Worked on manual cleaning data from Distribution database which were already sent to subscriber database.
• Maintaining hospital databases which have patient information, Radio Graphs, CT scans, blood test, Insurance copy and all related documents.
• Experience in working on database level encryptions.
• Worked on estimate time for space and database usage of SQL Server.
• Troubleshooting alerts like run out of space on drives, Databases issues and any backup job failures.
• Rebuild Backup server after the SQL Server got crashed.
• Copy manually of missing data from source server to message queuing servers using BCP and SSIS packages.
• Experiences in rebuilding SQL Server after the hardware enclosure were degraded.
• Involved in archiving data from the tables.
• Expertise in creating linked servers to send Meta data to another instance.
• Involved in preparing documents for Installation of SQL Server 2008, Archiving data and setting Peer to Peer topology replication.
• Worked on weekly maintenance of rebooting SQL Server boxes.
• Tools used for creating tickets are Remedy, Product Studio and Bugger 2011.
• Maintaining the database health of all hospitals located around DC area.
• 24/7 on call support.

Confidential

Sr SQL Server Administrator

Responsibilities:

• Installation of MS SQL Server 2008 R2, 2008 and 2005 on production, Test and Development boxes.
• Experience in installing and configuring SQL Server 2008 R2/2008/2005 clusters in Active/Active mode.
• Involved in Capacity Planning, data modeling and Logical/Physical database Design.
• Involved in upgrades of both Side-by-Side and In-Place from SQL Server 2000 to SQL Server 2008/2005 and from SQL Server R2/2008.
• Successfully migrated near to 160 Databases from SQL 7.0 including many numbers of DTS packages to SSIS.
• Successfully migrated near to 40 Databases from 2005 to 2008 R2/ 2008.
• Involved in upgrading service packs for SQL 2005, 2008 and 2008 R2 to the latest version.
• Migrated SSIS packages from SQL 2005 to SQL 2008 R2 servers.
• Setting up the Transactional Replication in between SQL Server databases and also from SQL Server to Oracle databases.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Created maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application, Cleansing and solving Database troubles.
• Daily support, troubleshooting, monitoring, optimization, tuning and blocking of servers and SQL server environments across entire system.
• Worked on creating the SSIS package for monitoring the database status and SQL Error logs for the mission critical servers.
• Worked on generating MOM and SCOM reports on mission critical servers for CPU usage, Memory (available memory) and disk space.
• Created various Jobs scheduled and troubleshoot the failed jobs.
• Involved in working with Redgate tool for SQL compare & SQL Data compare between the databases and tables.
• Having experience in backup tools LiteSpeed and RedGate.
• Create the change control management for the final approval of database upgrade.
• Worked on Remedy Tickets and CSDS request to complete SQL Server related request.
• Supporting Applications which has databases on SQL Server 2000, 2005, 2008 and 2008 R2 across many Locations Alabama, Kentucky, Texas, Indiana, West Virginia & California (United States).
• Interacting with the application team members for scheduling the database migration during the non-production timings.
• Involved in Creating Weekly status reports for the issues which has been resolved and yet to resolve.
• Having good experience in 24/7 production support.

Environment: Windows 2008/2003/2000/ NT4.0, MS SQL Server 2008 R 2/2008/ 2005/2000/7.0/6.5 , Clustering, Replication, DTS, SSIS, MOM, .NET Framework, Redgate tool, LiteSpeed, Idera, ASP .NET, ADO.NET, Visual Studio.

Confidential, Arlington, VA.

SQL Server Administrator

Responsibilities:

• Involved in Installation of SQL server 2005 Enterprise Edition on the new boxes.
• Worked on active / active cluster environment servers.
• Worked on setting up the Log shipping in between Arlington (US) and Camden (UK) servers.
• Implemented the database Mirroring concept on production servers.
• Involved in creating ticketing system for setting up the Log shipping.
• Documentation preparation for both Log shipping and mirroring setup.
• Resolved some performance issues on critical servers.
• Daily task like checking SQL Server Services, Database status, Error logs, Backup Jobs, Disk Space, Mirroring and log shipping monitors.

Environment: Windows 2003/2000, MS-SQL Server 2005/2000, Clustering, Log Shipping.

Confidential, New York.

Sr SQL Server Administrator

Responsibilities:

• Installed and configured SQL server 2005 active/passive cluster.
• Successfully migrated around 50 databases from including DTS packages to SSIS.
• Worked on implementing the Mirroring concept on all the production servers.
• Configured Transactional log replication and Snapshot replication.
• Initiated, managed and coordinated database change control items to predictably modify the database environments.
• Involved in Installation of Quest tool for all the Prod, UAT and Dev servers.
• Monitoring Performance Analysis and Capacity Manager on all servers using quest tool.
• Designed and developed security strategies for interfacing databases with application software.
• Involved in database security to strengthen, so that application access and distributed access apply the minimum privilege.
• Worked on creating the new linked servers and also changed the existing linked server’s remote user to a new account.
• Changing the startup account form local system account to windows domain account for all the Servers.
• Performed data backup, recovery and transfer operations and worked on developing disaster recovery strategies.
• Involved in T-SQL query tuning.
• Involved in the creation and maintenance of indexes, tables and other database objects.
• Designed and developed ETL processes using SSIS to receive customer files from data warehouses and load them into transaction processing systems.
• Involved in creation and maintenance of Users, roles, groups and their privileges.
• Involved weekly meeting to discuss about the project status, issues and achievements.

Environment: Windows 2003/2000/NT4.0, MS-SQL Server 2005/2000, Clustering, Replication, DTS, SSIS, SSRS, .NET Framework, ASP .NET, ADO.NET, Visual Studio, HTML, XML, IIS 6.0

Confidential, Washington D.C.

SQL Server Administrator

Responsibilities:

• Providing 24/7 on call support for all the Production servers.
• Used upgrade advisor tool to check any prerequisites steps to be taken before migrating the Databases.
• Involved in Migration of SQL Server 2000 to SQL server 2005.
• Migrated DTS packages to SSIS packages.
• Installation of SQL server 2005, SSRS, SSIS and MOSS 2007.
• Involved in configuration of SSRS with Microsoft office SharePoint Server in Integrated mode
• Administering the MS SQL Server 2005 & 2000 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Worked on Site Scopes Monitoring tool and SQLSafe Backups tool.
• Involved in setting up Database Mirroring with and without witness Server in SQL server 2005 (Manual / Automatic fail-Over).
• Configured and maintained Transactional and Snapshot replication.
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
• Designed and implemented comprehensive Backup and Recovery plan and disaster recovery strategies Implemented.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Database Refresh from Production backup to Stage and Development environments
• Working with ITSM Tickets (Any changes on Production, staging and development environment need to Create ITSM Tickets).
• Developed few reports using MS SQL Reporting Services.
• Worked on critical issues on production servers with the help of Microsoft tech support.
• Extensive experience on VMware machines.

Environment: Windows 2003/2000/NT4.0, MS-SQL Server 2005/2000, SSIS, SSRS and MOSS 2007, Site Scopes monitoring tool and SQLSafe Backups tool, Clustering, VMware machines.

Confidential, Louisville, KY .

SQL Server Administrator

Responsibilities:

• Installation of MS SQL 2005 & 2000 Enterprise servers on production, Test and Development boxes.
• Supporting Applications with SQL Server 2000 & 2005 Databases across Many Locations all over United States.
• Planned and Successfully Implemented SQL Server 2005 on the Production, Test and Development Servers.
• Successfully Installed the Service Pack 1 and Hot-fix for SQL Server 2005 in all the Dev and Prod Environments.
• Administering the MS SQL Server 2005 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Involved in Migrating the existing database to SQL Server 2005 (Side by Side).
• Created a mirrored database on the report server using Database Mirroring with High Performance Mode.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Involved in DTS Package, DTS Import/Export for transferring data.
• Involved in implementation of replications like Snapshot and Transactional.
• On call 24/7 support to databases on weekly rotation.
• Created SSIS Packages to migrate the data from database to Text files.
• Generated different reports using MS SQL Reporting Services and Crystal Reports.

Environment: Windows 2003/2000/NT4.0, MS-SQL Server 2005/2000, SSIS, SSRS, System Monitor / Performance Monitor, DTS, Performance Tuning, Clustering, .net, VB Script and Visual Source Safe.