SUMMARY

• Experience in Installation and Configuring SQL Server 2008R 2/2012/2014/2016
• Experience in monitoring and capturing SQL server performance and tuning the Database and SQL queries.
• Experience in creating Backup and Restore strategy including Disaster Recovery
• Strong experience in Upgrading and Migrating SQL Server from Server 2008r2 to 2012 and 2016.
• Experience in ETL process to export and import data to/from various platform including SQL to MySQL and Oracle.
• Experience in creating Maintenance Plan Jobs to update statics and rebuild index to run on regular basis
• Expert in configuring DB mail to send Alerts in case of job failure or success.
• Hands on experience configuring and maintaining High Availability solutions like AlwaysON.
• Strong Experience in creating Log Shipping, DB Mirroring, Replication
• Experience in configuring and monitoring Log shipping and Replication using native tools.
• Hands on experience on Failover Clustering both on windows and on SQL server
• Strong experience on T - SQL, DMVs, DBCC commands and Trace Flags
• Experience on creating Store Procedure, Functions, Triggers, Cursors, Tables, Views and Indexes.
• Experience in configuring reporting server and creating and deploying reports.
• Experience with developing and deploying complex SSIS and SSRS Packages.
• Monitor and Troubleshoot SQL Servers and databases by using Standard Reports, Activity Monitor, Profiler/Tuning Advisor to find and resolve various bottlenecks such as Locks/Dead Locks/ Long /Slow running Queries.
• Hands on experience dealing with Execution Plan for query optimization and Indexes for performance issues.
• Experience in responsibly securing SQL Server, User Management, Assigning Permissions and Roles (Server level and Database level).
• Experience in Using Performance Monitor (perfmon) dealing with various counters.
• Worked as a System Administrator on various Windows Operating Systems.
• Hands on experience of Microsoft SharePoint 2007 and Microsoft SharePoint 2010.
• Experience in creating standard documentation for the purpose technical documentations.
• Experience in using native client tools such as SSMS, WorkBench, SQLDeveloper, Toad
• Excellent Analytical, Communication and Interpersonal skills.

TECHNICAL SKILLS

RDBMS & Tools: SQL Server 2005/2008/2008 r2, 2012 and 2014, MS Access 2010, MySQL 5.0,SQL Loader and Export/Import.

Languages: T-SQL, PL/SQL, HTML, VB, .NET, C#, C++, and Java

ETL Tools: SSIS and Remedy MDM.

Data Model: Darwin 2.0, Erwin, and SSAS.

Reporting Tools: SSRS, Cognos, and Business Objects XI.

Backup Software: Lite speed, Red gate, SQL Backup and FTP.

Operating System: Windows XP; 7 and 10, MS-DOS, Windows NT/ 2000/2003/2008 and 2008r2/2012r2/2016 servers and Linux

Third Party Tools: Spotlight, Idera Diagnostic Manager, Red Gate, Toad for MYSQL, WinSCP, KeyPass, PUTTY

Database Query Tools: Query Analyzer, SQL Profiler, SSMS and Toad for SQL Workbench for MySQL.

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential, NY

Responsibilities:

• Administration of 110 + SQL Servers in Production, Development, UAT, TEST and DR Environments.
• Migrated SQL Server 2008 R2 to 2012, 2014, 2016 in Windows Server 2012R2
• Experienced with VM infrastructure using vSphere 6.0
• Engage in trouble shooting and performance tuning of databases.
• Rebuilding/Re-organizing the indexes for better performance.
• Develop and test storage strategies for large operational database (VLDB), delivering solution that guaranteed recovery performance and high availability.
• Well versed with disaster recovery Strategies that ensure Data security and high availability.
• Implement SQL Logins, Roles and Authentication Modes as a part of Security Policies for various groups of business users.
• Recover the databases from backup. Implementing Point-In-Time Recovery solutions.
• Perform SQL Server service pack / hotfix upgrades.
• Installed and configured Transactional and snapshot replication.
• Experienced with HARD AlwaysOn
• Worked with Amazon Web RDS, S3, SNS, SES and EC2 services
• Upgraded, Migrated and Consolidated database datacenters
• Created Linked server to other database platform form adhoq queries
• Installed and configured SSRS, SSIS and SSAS
• Perform deployments to Production and QA environments on scheduled and on demand basis.
• Monitor SQL servers using tool Spotlight.
• Meeting the SLA (Service Level Agreement) established with Jira system.
• Provide 24x7 production supports for SQL Server databases on Clustered Servers with database sizes ranging from 100 GB to 1.2 TB to achieve maximum performance and uptime in production environment.
• Use SQL SSMS, SQL Server Profiler, SQL Server Agent, DatabaseEngine Tuning Advisor (DTA) and other tools for day to day administration.

Database Administrator

Confidential, Basking Ridge, NJ

Responsibilities:

• Administration of SQL Servers in Production, Development, Staging, TEST and DR Environments.
• Experience in installed SQL server in Stand-alone ad Cluster environment
• Migrated SQL Server 2008 R2 to 2012, 2014 in Windows Server 2012R2
• Engage in troubleshooting and performance tuning of databases.
• Rebuilding / Re-organizing the indexes for better performance.
• Develop and test storage strategies for large operational database (VLDB), delivering solution that guaranteed recovery performance and high availability.
• Well versed with disaster recovery Strategies that ensure Data security and high availability.
• Implement SQL Logins, Roles and Authentication Modes as a part of Security Policies for various groups of business users.
• Recover the databases from backup. Implementing Point-In-Time Recovery solutions.
• Perform SQL Server service pack / hotfix upgrades and Windows server patching.
• Installed and configured Snapshot and Transactional replication.
• Upgraded, Migrated and Consolidated database datacenters
• Created Linked server to other database platform form adhoq queries
• Installed and configured SSRS, SSIS and SSAS
• Perform deployments to Production and QA environments on scheduled and on demand basis.
• Monitor SQL servers using third party tools such as IDERA diagnostic manager, Red Gate, Spot-Light.
• Provide 24x7 production supports for SQL Server databases on Clustered Servers with database sizes ranging from 100 GB to 1 TB to achieve maximum performance and uptime in production environment.

Database Administrator

Confidential, Atlanta, GA

Responsibilities:

• Performed Analysis, Designed and Created databases meeting the requirements and performance expectations.
• Developed and managed reports using SQL Server 2008/R2 and 2012 Reporting Services.
• Managed the migration of SQL Server 2005 databases to SQL Server 2008/R2 and 2012.
• Monitored SQL server performance using SQL Profiler to find performance and dead locks.
• Configured 3 node active/passive sql cluster in sql 2012
• Configured transactional replication for Mission critical applications
• Setup database mirroring for Line of Business to ensure data high availability
• Configured log shipping in sql 2008/R2 and 2012
• Worked closely with storage team to design RAID from database machines
• Well versed with 3rd party monitory application e.g Idera, NetIQ, SCOM
• Experienced in sql disaster recovery strategies
• Deployed SSIS packages per user requirements
• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Monitored and modified Performance using execution plans and Index tuning.
• Day-to-day administration of SQL Servers.
• Designed and implemented comprehensive Backup plans and disaster recovery strategies.
• Rebuild the indexes and update statistics at regular intervals for better performance.
• Install SQL Server service pack and Windows Service pack upgrades after careful evaluation.
• Designed and created databases, tables, views, store procedures and triggers.
• Facilitated database portion of application deployment and joint effort deployments.
• Designed and implemented Security policy for SQL Servers.
• Automated alerts on server failures, job failures and task completion.
• Enforce Database Security by managing user privileges.
• Involved in integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and Performance Point 2010 and Dashboards.
• Exported data (ETL/SSIS) from SQL server to various file system.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.