Sql Server Service

Aravind

MS SQL Server Database Administrator with 4 Years of Experience with Clustering, Log shipping, Mirroring, Replication, Recovering System and User Suspect Databases, Troubleshooting, Performance Tuning and T-SQL Scripts.

Mobile no: +1-423-***-**** Email id:************@*****.***

A dynamic and results-driven professional with 4 years in SQL database Administrator.

Experience on installing, configuring, Managing and Monitoring of all SQL servers

Automation of SQL Server activities including scheduled and maintained routine Jobs,

Alerts and Maintenance Plans.

Experience on power shell scripting.

Monitoring sqlserver jobs like backup, database space, log space etc.

Strong Experience in Backup, Recovery strategy and Database Refreshes

Experience in Database administration activities for DB security (creating users, logins and assigning permissions to them)

Good understanding of RDBMS.

Experience on SQL plus, Database triggers, PL/SQL Optimization.

Experience in finding Root cause for all type of incidents to fix the issue permanently

Have experience in finding and clearing blockings.

Having hands on experience in Database Mirroring and ensuring high availability to the

Database by testing the failover.

Good exposure in configuring and troubleshooting Log shipping and Replication.

Have good knowledge on ALWAYSON.

Extensively involved in Performance tuning.

Have good working understanding of SQL databases and Transact query languages

Have experience in upgrading SQL Server 2005 to SQL Server 2008/2008 R2/2012/2014/2016.

Have good experience in applying Service Packs and Hot fixes on SQL Servers.

Experience in Database Backup, Recovery and Disaster Recovery Procedures.

Proficiency in developing SSIS packages to Extract, Transform and Load( ETL)

In-depth understanding of security and backup procedures to ensure database integrity.

Worked and good understanding with Active Directory Domain servers.

Experience on Testing, Writing Test cases and Test Metrics.

Developing Architectural Design for databases.

Designing Data models.

Speaking with clients/application & development teams regarding issues and keeping track of the issue till it gets resolved.

Good MS Office Proficiency, MS SQL SERVER, Oracle, DB2, Sybase.

Working Understanding of Software Development Life Cycle.

Extensive knowledge and experience on managing very large Data Warehouse databases.

Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors,Triggers and Views.

Experience in Designing Databases.

TECHINICAL SKILLS:

Operating Systems: Windows 2003/2007/2008 R2 Server etc.

Databases: MS SQL Server 2005/2008/2008 R2 /2012

Languages: T-SQL,Perl

ETL & Reporting Tools:Informatica, Power Center 8.5/8.0,Data Stage6.0, 1.0, Business Objects Xi R26.1, Oracle Data Integrator, SAS

Programming Languages:C,C++,Asp.Net, XML, HTML, DHTML, CSS, Java

Education: Bachelor’s

Professional Experience

Falls Lake Insurance Company, Raleigh, NC Aug ’15– May ‘17

SQL DBA/Developer

Responsibilities:

Performed server installation and configurations for SQL Server 2005 and SQL Server 2008, 2008R2/2012,2014,2016.

Maintaining the servers - applying patches and service Packs.

Involved in capacity planning, sizing and database growth projections.

Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.

Setup backup and restoration jobs for development and QA environments.

Executed Change requests as per release window on production servers.

Implemented disaster recovery solution at the remote site for the production databases using Log Shipping& Mirroring.

Managing the databases and high availability solution on DR Testing Activity.

Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.

Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.

Installed, configured and maintained SQL Server 2005 and 2008 fail over cluster servers for upcoming projects.

Configured Log Shipping and database mirroringin two different domains.

Configured and maintained Merge & Transactional replications.

Used DBCC commands to troubleshoot issues related to database consistency.

Used Index tuning wizard to redesign and created the indexes for better performance.

Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.

Worked on Fog light Monitoring, Service Now and Remedy ticketing tools.

Handling escalated issues. To ensure the maximum uptime.

SQL Server upgrades with new service packs and hot fixes.

Recovering the databases from backup in disasters and Implementing Point-In-Time Recovery solutions.

Develop and implement Database Administration/Maintenance Plan for SQL Server.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Data migration using attach/detach database whenever client requested to migrate the data from one version to other or one server to other.

Managing the space for databases. Checking the performance of SQL Server by using SQL Server

Coordinating with Development, Test and Support teams for server wide issues.

Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.

Written Test cases for Insurance Quotes.

Written scripts using Perl scripting languages and T-SQL.

Write queries and generate reports using ETL tools.

Involved in designing logical and physical data models using Erwin.

Review and confirm the mongo schema design, sharding strategy, indexing, and infrastructure choices, Windows vs Linux - During run mode, deal with capacity planning, tune the infrastructure and Mongo DB.

Cover the backup and restore process with Ops Manager, cover the Disaster Recovery Plan, help during incident and problem management in production, performance issues

Written PL/SQL Stored Procedures, Packages, Functions and Triggers.

Written queries in SQL plus and executing on day-to-day basis.

Perform SQL tuning and assist developers with coding PL/SQL.

Proficiency in developing SSIS packages to Extract, Transform and Load ( ETL) to

Data warehouses from databases.

Invesco,Hyderabad, India June ’13 – May’15

SQL DBA/Developer

Responsibilities:

Performed server installation and configurations for SQLServer 2005 and SQL Server 2008,2012.

Maintaining the servers - applying patches and service Packs.

Moving databases from Testing Server to Application Server.

Closely monitoring the growth of the Databases and adding space to database files.

Installation, configuration and maintenance of the MS SQL Server

Management of SQL Servers, databases, storage management for databases sizing.

Designing and supporting high availability SQL Server solutions that include Log shipping, Mirroring & Replication.

Create and modification of the database according to the requirement.

Creating users, roles and giving appropriate permissions to the members as part of the security implementation.

As per hardening measure, changing system/user databases default location.

Initiative among team in communicating with the client to get the Issues resolved.

Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical, support, and business staff at all levels.

Creating Triggers and Views on daily basis.

Perform SQL tuning and assist developers with coding PL/SQL.

Developed Architectural design for finances of the Company as it is mostly into Investment.

Written PL/SQL Stored Procedures, Packages, Functions and Triggers.

Implement "Stored Procedures and Triggers" based on business plans using PL/SQL.

Involved in designing logical and physical data models using Erwin.

Work closely with other teams in other region to deliver the service.

Responsible for 24 7 Production support.

Proficiency in developing SSIS packages to Extract, Transform and Load( ETL) to

Data warehouses from databases.

Design Databases on the requirement basis of clients need.

Contact this candidate