SUMMARY

• Specialized in SQL Server 2005/ 2008 / 2008 R2/2012 / 2014 and SQL Server 2016 having 8.7+ years of software life cycle 7 years’ experience which includes MSSQL in Database Administration, System Analysis, Design, Security Database Administration and 1 year as AWS Admin along with operations support.
• Experience in Installing, patching, maintaining sound backup policies, procedures and routine operational monitoring activities to ensure a stable database environment capable of meeting ongoing business needs.
• Experience in ETL processes. Worked on Data Extraction, Transformation and loading from different data sources using SSIS. Have good knowledge on using Variables and Expressions in Packages and troubleshooting capabilities.
• Experience in migrating SQL databases over Azure and AWS cloud environments as well as on premises side - by-side migrations from SQL lower editions to SQL 2014 and SQL 2016.
• Perform and oversee day-to-day database activities related to check SQL server error logs, backups, restores, integrity checks, optimizations, refreshing re indexing, performance tuning and troubleshooting
• Index partition for high volume database and maintenance and troubleshooting data/log size.
• Windows Azure (IAAS, PASS) and SQL Azure backup and database creation.
• Creating AWS instances for Aurora RDS and redshift data warehouse clusters and maintaining IAM roles and security groups.
• Experience in high availability SQL Server solutions, including Log shipping, Mirroring
• Implemented DMV and dynamic management functions for finding out long running queries
• Sound knowledge on Peer to peer replication and experience in resolving MSI & MSP Files issues
• Experience in Always On Configuration Type 1 and Type 2 and troubleshooting
• Experience on Cluster Installation and Up gradation (active\passive & active\active)
• Experience in Creating Jobs and Sending Alerts using DB Mail.
• Experience in high availability SQL Server solutions including Transactional replication and merge replication (Push & Pull Subscriptions).
• Taking all types of Backup (Full, Differential and T-Log) and restoration.
• Experience in implementing Log shipping, and Replication. Involved in Security like giving privileges to the users and creating logins.
• Good Knowledge in DBCC, Stored procedures and T-SQL Statements.
• Involved in updating the patches to SQL Server like installing the Hot fixes and service packs etc.,
• Strong RDBMS concepts and Experience in creating Indexes, Views, Stored Procedures, User Defined Functions and Triggers to facilitate efficient data access.
• Expertise in designing complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports, Sub reports using SSRS.

TECHNICAL SKILLS

Databases: SQL Server 2008,2008R2 and 2012

Ticketing tool: Service NOW, ITSM and BMC Remedy

Operating Systems: Windows 2008 and 2012. Linux

Microsoft Office Suite: Excel, Word, PowerPoint, Visual studio.

Cloud Service: AWS and SQL Azure

3rd Party Tools: Lite Speed, Red Gate

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

Databases: SQL Server 2008, 2008 R2, 2012 and SQL 2014.

Environment: Windows Server 2008, 2008R2, 2012 and SQL 2014.

Responsibilities:

• Involved in L3 Support, Change Management and Incident management support.
• Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements.
• Responsible for supporting 24x7 over 120 production SQL servers, over 600 databases, average sizes of the databases are 100GB-1TB.
• Migrating the databases and other database objects from SQL server 2000, 2005 to 2012, 2014 and 2016.
• Supporting the projects during the UAT, SAT and troubleshooting the data issues from database end.
• Using ticketing tools like remedy and Service Now to support day to day activities.
• Helped with performance tuning for batch job delays and long running queries during the SAT and UAT testing. Applied patches and service packs to keep the database at current patch level.
• Responsible for backup, restoration, maintenance plans and databases security.
• Developed SSIS package to copy the data from other sources.
• Installation of SQL Server 2008 R2, SQL 2012 & SQL 2014 on Standalone Servers and clusters nodes.
• Applying Service packs and Patches on standalone servers & cluster nodes, resolving the issues related to installations and up gradations
• Worked on Test, Dev., and pre-prod and production servers. Configuration of Transactional replication (Push & Pull Subscriptions)
• Up gradation of SQL Server 2008, SQL Server 2008 R2 to SQL Server 2012 and SQL 2008 R2 to SQL 2014. Creation of Logins, users and groups with appropriate roles.
• Configuration of Always-on on Type 1, Type 2 and Type 3 and 4
• Fix the issues related to share components Worked on MSI & MSP files issues which were raised at the time of SQL up gradation.

Confidential, Topeka, KS

Databases: SQL Server 2008, 2008 R2 and 2012

Environment: Windows Server 2008, 2008R2 and 2012

Responsibilities:

• Expertise in SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies.
• Day to day activities include providing Database support and troubleshooting of issues like Connectivity, Memory issues, Query performance, Server related, Auto jobs failures.
• Create the automation for the environment for different jobs.
• Creating physical Devices and Databases.
• Database support involves SQL server and Oracle databases of different versions.
• Creating user logins and adding users to databases aliases and allotting roles to users.
• Configuring Adaptive Server to achieve the best performance tuning, monitoring the server activity, writing stored procedure, Replication & scheduling activities and all other database activities.
• Managing security using grants and revokes, Performing Backup and Recovery of Databases.
• Automation of Backup and Recovery of Databases using UNIX scripts.
• Automate DBCC maintenance activities on Databases, Tuning of Server by setting Configuration parameters.
• Helped with performance tuning for batch job delays and long running queries during the SAT and UAT testing. Applied patches and service packs to keep the database at current patch level.
• Responsible for backup, restoration, maintenance plans and databases security.
• Developed SSIS package to copy the data from other sources.
• Performed regular Database Maintenance task, checking the disk Defrag procedures in Development environment.
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes.
• Worked on the space issues because of Transaction log growth as well as data file growth.
• Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers.
• Used Index Tuning Advisor for Database performance for proper indexes.

Confidential

Databases: SQL Server 2005, 2008 and 2008 R2

Environment: Windows Server 2000 and 2003 and Linux

Responsibilities:

• Installing and Configuring SQL Server, including service pack deployments.
• Checking the health of the servers and the databases.
• Check OS Event Logs and SQL Server Logs for unusual events.
• Regularly monitor and identify blocking issues.
• Monitor disk space to ensure your SQL Servers won’t run out of disk space.
• Experience in implementing Log shipping, Mirroring and Replication.
• Requirement basis Failback/Failover of Clusters.
• Maintaining database backup strategies and recovery scenarios.
• Monitoring the Data file, log files & Database Backup & Recovery.
• Managing the space and monitoring the free space etc.
• Ensuring Data consistency in the database through DBCC commands.
• Creation of database maintenance plans, rebuilding indexes.
• Involved in Security giving privileges to the users and creating logins