OBJECTIVE

• To be associated with a dynamic organization which provides optimal learning opportunities to achieve organizational goals for the benefit of the company and the individual.

SUMMARY

• Having 4.7 years of IT experience in MS SQL Server Database production support and Maintenance Activities
• Microsoft Certified professional in SQL Server 2012
• Expertise in Installing, configuring, securing and managing SQL servers to ensure better performance and application availability.
• Exposure to SQL Server and Windows environments.
• Experience in working with production ( 24 x 7 ) and DEV/QA environments.
• Ability to perform all Database Administration ( DBA ) tasks like performing installations, databasebackups and recovery, monitoring logs and hard disk consumption growth rate etc.
• Able to configure jobs for routine activities and troubleshooting them in case of failures.
• Familiar with implementation strategies, backup/recovery strategies.
• Monitor SQL Server down, SQL Server Agent, Error log, Application and System logs, Job failures, Backup Failures, Database and Log growth, CPU, Memory and Disk Utilization using the in - house built SQL Server monitoring tool.
• Creating database users, controllingaccess to SQL Server and making sure right people get access to right data and looking after the security issues.
• Experienced in advanced concepts of SQL server like Mirroring and log shipping.
• Expertise in implementing MS SQL Server security and databasepermissions .
• Performing the Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities.
• Configuring and Maintaining and troubleshooting the Database mirroring and also experience in Mirroring DR activities.
• Configuring and Maintaining and troubleshooting the Database Log Shipping and also experience in Mirroring DR activities.
• Troubleshooting Space issues and performing Capacity Planning for Production Database servers.
• Database performance monitoring and tuning when required as per application and business requirements.
• Performing Database Refresh from Production to QA/DEV environment.
• Experience with upgrades from SQL 2005 to 2008 r2 and from 2008 R2 to 2012.
• Experience in SQL Server migration activities
• Knowledge on Windows and SQL Server clustering
• Flexibility working in 24*7 environment
• Administrating MS SQL Server, analytical, monitoring, troubleshooting, organizational skills, and assessment planning and implementation.
• Good understanding about ITIL concepts like Incident Management, Problem Management, Change Management, Release Management, Configuration Management, Service Level Management Certifications (Internal Certifications).
• Team player, willing to share and develop my knowledge and experience
• Ability to handle multiple tasks and tight deadlines.
• Working with different clients has made me interact with people of different cultures and mindsets.

TECHNICAL SKILLS

• SQL Server Versions SQL Server 2005,2008, 2008R2 and 2012
• SQL server tools SQL Server Management Studio, SQL Profiler, Performance Monitor, SQLCMD, Database Tuning Wizard,Microsoft Clustering Services (MSCS), SQL Server Upgrade Advisor, DTA, DMV'sand DBCC Commands
• DR Configuration Log Shipping, Mirroring,Clustering, Transactional Replications
• Operating Systems Windows Server 2003, 2008 R2 and 2012
• Other Essential Software Microsoft Office Word, Excel

PROFESSIONAL EXPERIENCE

Confidential, Omaha, Nebraska

SQL Server DBA

Responsibilities:

• Working closely with application development and support team to understand their requirements and provide timely solutions, for both current and future projects.
• Configuring replication, mirroring, SQL clusters and troubleshooting issues.
• To reduce threat to the environment identified users having SYSADMIN rights and relegate them to the appropriate rights.
• Planed phased implementation of security patches in coordination with applicationteam to minimizedowntime to end users.
• Installation and configuration of MS SQL Server 2005, 2008.
• Migrating databases from SQL Server 2000 to 2005 and SQL Server 2005 to 2008.
• Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking
• Configuring and troubleshooting high availability scenarios like Log Shipping.
• Implemented Database Mirroring with High Availability Mode in SQL 2005
• Maintained & Monitored Alert/Schedule to make smooth replication process.
• Ensure and maintain sound backup and recovery policies and procedures.
• Database performance monitoring and tuning when required as per application and business requirements.
• Backup and restoring the databases from production to test environment.
• Resolving blocking processes related issues.
• Executing the scripts in production environment.
• Updating Service packs and Security patches for the Servers.
• Monitoring of server performance.
• Performing data refresh activities from production to Dev/Test on need basis.
• Performance tuning of the database.
• Creating and reviewing Security features for all the servers.
• Configuring and monitoring the Database Mirroring and Log Shipping.
• Trouble shooting blocking, space issues.
• Ensuring Data consistency in the database through DBCC commands.
• Migration and up gradation of servers and databases
• Repetitive issues analysis and proposals for permanent resolutions.
• Working on Remedy ticketing tool for ticket management.

Confidential

SQL Server DBA

Responsibilities:

• Installing Windows and SQL server on new servers with the help of datacenter team when ever required.
• Deploying service packs and security patches based on the need.
• Maintaining the high level security and configurations of servers.
• Data migration using attach/detach database whenever customer requested to migrate the data from one version to other or one server to other.
• Restoring backups on production environments to when there is data loss or need to resolve production bugs.
• Create the jobs and also maintain the jobs as daily basis as well as weekly basis.
• Responsible for 24/7 production support.
• Creating scripts for database objects like tables, procedures and indexes.
• Configuring alerts based on required criteria and keen monitoring through Perfmon.
• Database email configuration.
• Creating users, roles and giving appropriate permissions to the members as part of the security implementation.
• Configuring and monitoring the Database Mirroring and Log Shipping.
• Ensuring Data consistency in the database through DBCC commands.
• Migration and up gradation of servers and databases
• Repetitive issues analysis and proposals for permanent resolutions.
• Working on Remedy ticketing tool for ticket management.
• Monitoring SQL Server agent jobs/maintenance plan