SUMMARY

• Over 9+ years of working experience in SQL Server Database Administration, Performance Analysis, Database Design, Development and Support Production,large scale 24x7 operations/production web service environment.
• Ahighly qualified, goal - oriented IT professional with extensive experience with SQL Server 2014/2012/2008/2005/2000 Database Administration in 24x7x365 environment.
• Expertise on Implementing High Availability options with Zero Data Loss and real-time apply environment.
• Well equipped with the working knowledge of application development life cycle methodologies, database and application performance tuning.
• Expert in installation and configuration of MS SQL Server 2014/2012/2008/2005 Databases.
• Experience in Planning and executing disaster recovery (DR) exercises on the DR servers.
• Expertise in mentoring and setting up High availability environments like active-active and active-passive clustering, Database Mirroring, Replication (Snapshot, merge, transactional), Log shipping, setting up servers from scratch on clustered environment, Linked servers.
• Responsible to follow the company guidelines / regulations to ensure company data is held in a secure manner, including electronic access or in written format.
• Gathering data requirements, and designing and fine-tuning of databases as per the requirement of clients. Complete Administration of MS SQL Server Databases is my primary responsibility
• Increased the Server Availability time with optimum level of Database Recoverability by incorporating the SQL server Differential backup and LOG Backup.
• Extensive knowledge of Relational Database Management Systems.
• Experience of working in large business critical systems, supporting multiple environments (Production/Business Readiness Test/Development).
• Good hands on experience on Data Migration
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Expert in performing database consistency checks and planning and scheduling Backup & Recovery
• Experience in using methods like Bulk Copy (BCP) and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) in MS SQL Server 2000/2005/2008.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks
• Experience in configuring SQL jobs and Windows tasks for performing scheduled activities like backups and purging / archiving data.
• Developed DR plans and automated failsafe backup remediation
• Possess a proven ability to streamline processes and coordinate efforts between diverse groups.
• An adaptable leader rapidly learns new technologies and stays abreast of trends in the industry to place the company at the forefront of technology and increase productivity and profitability
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

• Databases: MS SQL Server 2005/2008/2008 R 2/2012/2014/2016, MS Access 2000/2005/2007. Oracle 12c/11g/ 10g/9i/8i/8.0/7.0
• Database Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIS), Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, oracle Golden Gate, SQL reporting, SSIS,MAP Tool, MongoDB, Cassandra, SQL Compare, TSM, CommVault, SCOM, Idera.
• Programming: SQL, TSQL, BASIC, C / C++, XML, HTML, Powershell, Perl and Shell Scripting.
• Operating System: Windows 2012/ 2008R2/2003/2000, Advanced Server, NT & Windows 9x, Linux.
• Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP
• Case Tools: MS Office 2000/XP/ 2003/2007/2010, MS Outlook 2000/ 2003/2007/2010, Visio, Clear Quest.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. SQL Server Database Administrator

Responsibilities:

• Installed and configured MS SQL Server 2017, 2016, 2014 and 2012 with latest service packs and security patches.
• Migrated SQL server 2008 to 2012, SQL server 2012 servers to 2016 including Always ON and two node clustered SQL Servers.
• Documented processes for installations, clustering, availability group setup, and patching.
• Provided strategic direction for the database team and functioned as the technical/project leader on Enrollment and Claims systems migration project
• Supported Migrations for different applications which include Enrollment, Tibco, Lawson, Avaya Call routing databases.
• Supported migrations of application databases from SQL Server 2008R2 to SQL Server 2017.
• Developed new Security standards and worked with 600+ plus users and multiple teams during this project.
• Developed central database to monitor entire SQL Server Database farm and developed SSIS packages and SSRS reports which generate database alerts and monitoring system.
• Managed and administered 2500+ database in 190+ instances. Initiated a project to consolidate servers and to remove old/unused databases.
• Configured and supported replication and log shipping in both SQL 2008 and 2012.
• Worked and developed database security standards which include user maintenance.
• Involved in developing data masking process that is used to mask the data as part of refresh process from production to test environments
• Created maintenance plans for backups, index and update stats maintenance
• Supported 24x7 on call rotation

Environment: SQL Server 2016, 2014, 2012, 2008R2, 2008, 2005/2000 Enterprise Edition, Windows Server 2000,2005,2008,2012 SAN.

Confidential, Fairhaven, MA

Sr. SQL Server Database Engineer

Responsibilities:

• Installed, configured and upgraded Stand-alone SQL Server 2005, 2008, 2008R2,2012, 2014 and 2016 versions and maintained Microsoft best practices in applying Service Packs and Hot Fixes on cluster,log shipping, Mirroring and Always ON servers on regular basis.
• Worked with building, Installing, Configuring and Maintaining Active-Active and Active-Passive two and four node failover Clusters as part of Migrations
• Implemented HA and DR solutions such as Always ON and FCI
• Sufficient time spent in conducting periodic database health and performance checks. Regularly create missing indexes, update statistics, rebuild\reorganize indexes; schedule T-SQL scripts on all production servers to monitor failed jobs and disk free space issues to avoid unnecessary breakdowns.
• Installed, configured SQL Sentry 11.0.80.0, a performance monitoring tool.
• Administered the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, granting the privileges to users and groups.

Environment: SQL Server 2014, 2012, 2008R2, 2008, 2005/2000 Enterprise Edition, Sybase, DB2, oracle, Linux,Windows Server 2000,2005,2008,2012. SAN, SQL Sentry.

Confidential, Boston, MA

SQL Server Database Administrator

Responsibilities:

• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs
• Migrated SQL server 2005 servers to 2008, SQL server 2008 servers to 2012 including Replication and clustered SQL Servers and as well as side-by-side upgrade process.
• Involved in Migrations of App Servers and Batch Servers.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Working with development and systems teams to perform application and database tuning
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Worked in Active-Active, Cluster environment as a High availability solution.
• Implemented high availability technologies.
• Prepared Documentation for the Disaster Recovery plan.

Environment: SQL Server 2012, 2008R2, 2008, 2005/2000 Enterprise Edition, Windows Server2000,2005,2008,2012. SAN, SQL Sentry

Confidential, NY

SQL Server Database Administrator

Responsibilities:

• Installations and configurations of sql server2008,2008R2,2012 applying service packs, and Upgrades
• Microsoft sql server in the following environments: Development, test, qa production, stand alone, clusters, and virtualized.
• Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database. Creating and managing user accounts / logins for development purpose.
• Using T-sql worked extensively on creation of Databases, Objects, Stored Procedures, Triggers, Security, DTS (i.e. Import and Export), BCP, Transact-SQL, Backups, Recovery, and SQL Server Agent, SQL Server profiler using SQL Server.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs

Environment: SQL Server 2008, 2008R2, SQL Server 2005/2000, Windows Server 2003, SAN storage systems, oracle 8i,9i, 10g and 11g, Linux, Idera .