ROHAN K

SQL Server DBA

816-***-****

acvose@r.postjobfree.com

SUMMARY:

Over 8+ years of IT Experience in SQL Server database administration, System Analysis, Design Development and Support of Microsoft SQL Server 2014/2012/2008 R2 / 2008 / 2005 in Development, Test, Production and Cluster Server Environments.

Experience in working with different domains such as health, government, insurance and retail domains

Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2014/2012/2008/2008R2/2005.

Experience in using SQL Server Tools like Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.

Experience in implementing and monitoring different types of Disaster Recovery and High Availability techniques such as Mirroring, Log shipping, Replication (Snapshot, Transactional & Merge).

Installed and maintained SQL Server Failover Clustering (active/active and active/passive) in Production, QA and Dev environments for SQL Server 2008, SQL Server 2008 R2 and above versions.

Knowledge on implementing high availability with Always on Availability Groups.

Experience working in VM, ASP Environments.

Worked in OLTP and OLAP environment that includes Production, QA and development databases in SQL Server.

Strong SQL Server Developer Skills including writing Transact-SQL Queries, stored procedures, user defined functions, views and Good understanding of Normalization /De-normalization, Database design and modeling (logical and physical).

Experienced in Administering, configuring and managing SAN, EMC storage for backups and disaster recoveries.

Have extensive experience in DBCC and DMV’s to check the health of the server.

Expert in creating Logins and Users as per client’s policy and requirements and in assigning roles as needed according to the project plan.

Expertise in Database Backup and Recovery procedures by using Native, TDP/TSM and Lite Speed to/from Disk /Legato server (Tape).

Experience in PowerShell scripts and PowerShell active directory with SQL server PowerShell extensions.

Very Good Experience working with SCOM Monitoring tool.

Good knowledge in using ticketing tools like BMC Remedy, Service Now (SNOW).

Expert in using third party tools like Lite Speed, Red Gate to speed up backup operations.

Extensively used tools like SSMS, SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

Experience in using Performance Monitor/Profiler to resolve Dead locks/Long running queries. And also good experience in data (table) partitioning

Implemented the SQL Server 2008 concepts like Data partitioning, Snap shot isolation, database mirroring, Default trace, change data capture(CDC), File stream, database snapshot, DDL triggers, try-catch blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA, SQL CMD and dedicated admin connection.

Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC, Re-indexing, Updating Statistics and online indexing.

Knowledge of indexes, index management, and statistics.

Expertise in DBCC Trace Flags and Blocking situations.

Good Knowledge in querying the databases using the PowerShell scripts.

Experience in data modeling like physical data modeling and logical data modeling by using ERWIN tool.

Good experience on physical storage configuration and optimization of SAN with different RAID levels.

Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Research on extended events subjects to monitor the CPU performance consumption and deadlock information on the servers with disabling trace flags.

Checking the threshold values and baselines and monitoring in perfmon and SCOM.

Expertise in implementation of security models; Database authentication modes, creation of users, configuring permissions and assigning roles to users.

Expert in Extraction Transformation Loading (ETL), Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.

Experience in managing Alerts, Operators and Jobs through SQL Server Agent.

Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).

Experience in providing 24X7 on call support on weekly rotation.

TECHNICAL SKILLS:

Databases: MS SQL Server 2005/2008/2008R2/2012/2014, Microsoft Access

Operating Systems: Windows server 2003/2008/2008R2/2012.

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business

Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Query Analyzer

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),

SQL Server Analysis Services (SSAS).

Data modeling Tools: Erwin, MOM, Tivoli.

Backup Tools: Lite Speed, Red gate.

Monitoring Tools: SQL Sentry, Solar winds ignite DPA, SCOM and BMC Remedy.

Programming Languages: SQL, TSQL

EDUCATION:

Bachelors from Jawaharlal Nehru Technical University, Hyderabad, India

WORK EXPERIENCE:

Client: Anthem Inc., Woodland Hills, CA MAY 2015- PRESENT

SQL Server DBA

Description: Anthem Inc. is an American health insurance company founded in the 1940s, prior to 2014 known as WellPoint, Inc. Anthem, Inc. is working to transform health care with trusted and caring solutions. Anthem Inc. health plan company deliver quality products and services that give their members access to the care they need. With nearly 71 million people served by its affiliated companies including more than 38 million enrolled in its family of health plans, Anthem is one of the nation's leading health benefits companies.

Responsibilities:

Administrated and Managed SQL Server 2014/2012/2008R2/2008 databases in Production, QA and development environments.

Administrated 127 servers, 950+ databases with 8 Data Domains.

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

Worked with the Windows, VM and SAN, Networking, Security teams for building new servers and migrating servers.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Installed and configured a SQL Server 2012 clustered environment with availability groups.

Migrated and configured SQL Server 2008 R2 to SQL Server 2012 on a Clustered and Standby Environments.

Handled Responsibilities like installing, configuring and maintaining SQL server 2008 R2 Active/ Passive cluster.

Involved in implementing and monitoring different types of Disaster Recovery and High Availability techniques such as Mirroring, Log shipping, Replication (Snapshot, Transactional & Merge).

Solving Tickets on Daily Basis for Production Issues.

Responsible for Stored Procedures optimization, Performance tuning & index tuning.

Administrator tasks like managing users, roles and permissions. Extensively worked on Replication for synchronization of databases for SQL Server High Availability.

Created Logins and Users as per client’s policy and requirements and assigned roles as needed according to the project plan.

Performed data partitioning for efficient management of database tables and indexes.

Involved in complete database design including conceptual, logical and physical models.

Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups.

Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Used third party tools such as Lite Speed to speed up backup operations.

Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages.

Used functions to create predefined conditions and prompts to filter the data and dynamic user selection.

Experience in PowerShell scripts and PowerShell active directory with SQL server PowerShell extensions.

Deployed and Debugged SSIS packages using BIDs 2008 R2 and scheduled jobs for these packages.

Implemented security policies for SSRS reports.

Have experience in enabling and disabling TDE encryptions.

Involved in creating Cubes using SQL Server Analysis Services.

Created the reports using Business Objects functionality's like Queries, Sub queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc.

Responsible for providing 24X7 on call production support on weekly rotation

ENVIRONMENT: MS SQL Server 2008/2008R2/2012/2014, Windows server 2008/2012, SSIS, SSRS, SCOM, Lite Speed.

Client: L’Oréal, North Brunswick, NJ May 2013 - March 2015

SQL Server DBA

Description: The L'Oréal Group is a French cosmetics and beauty company. It is the world's largest cosmetics company, and has a registered office in Paris. It has developed activities in the field of cosmetics, concentrating on hair color, skin care, sun protection, make-up, perfumes and hair care, the company is active in the dermatology, toxicology, tissue engineering, and biopharmaceutical research fields and is the top nanotechnology patent-holder in the United States.

Responsibilities:

SQL Server 2005/2008/2008R2 Database Development and Administration.

Responsible for providing 24X7 on call production support on weekly rotation to 30+ Production, development, 20+ Testing and Clustered servers.

Used log shipping, Always on Availability Groups and Replication for synchronization of databases.

Worked with Transactional Replication to achieve Load balancing using network authentication.

Responsible for Performance and tuning of SQL servers and application issues related to migration.

Administrated and managed HA- clustering which is two node active-active and active- passive clusters.

Monitoring SQL server performance using SQL Server profiler to find long running queries and dead-locks.

Daily routine Developer/DBA tasks like handling user’s permissions, monitoring Blocking, Deadlocks, Long running jobs, and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.

Managing alerts, managing security, Re-indexing/Reorganizing Indexes, performing DBCC checks.

Managing the locking/blocking and space management issues.

Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods.

Solving Tickets on Daily Basis for Production Issues.

Implementation of SQL Logins, roles and Authentication Modes as a part of Security Policies for various categories of users.

Involved in various projects from start to production deployment, guiding development team for efficient performance and planning capacity.

Worked with Partitioning Techniques to allow the SQL Server engine to escalate locks to the partition level before the table level.

Debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements

Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Extensively used DBCC and DMV’s to check the health of database in regular basis.

Proficient Development skills (SQL, TSQL, Stored Procedures, and Triggers) for the purpose of providing development support and application tuning.

Worked with SQL development team by Designing and creating SQL Database, tables, indexes, and views. Created User Defined Functions, Stored Procedures, and Triggers.

Created jobs on various activities like backup, maintenance.

Developed Backup and Restore scripts for SQL Server 2012

Maintained Production and Test Database Environment in SQL server 2008R2/2008/2005.

Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.

Experience with backups, restores and recovery models.

Environment: MS SQL Server 2012/2008 R2/ 2008/2005, T-SQL, Erwin, SSAS, SSIS (ETL), SSRS, Windows 2003, 2008 and 2012 Servers.

Client: Georgia Department of Community Health, GA JUNE 2011 – APRIL 2013

SQL Server DBA

Description: The Georgia Department of Community Health (DCH) is one of Georgia’s four health agencies serving the state’s growing population of almost 10 million people. The department is one of the largest agencies in Georgia state government.

Responsibilities:

Coordinated physical changes and performance monitoring of two replicated production servers, two development servers and one reporting server, all Microsoft SQL Server 2005/2008/2008R2.

Migrated databases from SQL Server 2005 to SQL Server 2008/2008R2 and documented the process during Pre-Migration and Post-Migration steps.

Administrated and managed HA- clustering which is 2 node active-active.

Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic sql queries.

Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.

Configured Security by creating Logins for ACTIVE DIRECTORY and SQL SERVER LEVEL by Creating Principals (logins) and Mapping users to roles. (Securable and Permissions).

Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, and SYSTEM VIEWS AND in built GLOBAL VARIABLES for the instant analysis.

Utilized fog light for monitoring the deadlocks, blockings and windows level performance also.

Responsible for all database architecture and program design, including survey systems, report developers, OLAP cubes, and interfaces with clients’ CRM software.

Responsible for backups/restores, monitoring SQL uptime.

Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.

Debugged triggers and stored procedures to improve the overall efficiency.

Profiled and tuned servers on a monthly basis to ensure fast queries and reports.

Evaluated OLAP tools, and built web-based OLAP cube reporting systems around it.

Created web-based dashboard to show reports produced, average report run time, emails sent, surveys taken, etc.

Wrote, designed and produced customer site allowing customers to view reports, place orders, download newer software versions, and set up their own surveys.

Created company intranet with help desk ticket and order tracking.

Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.

Implemented load balance web servers for high availability.

Evaluated and purchased reporting systems including Actuate, Case Studio, Visual Studio .NET, Net Charts, and UML diagramming.

Wrote installation and procedural manuals for support staff.

Created linked servers between Oracle 10g and MS SQL SERVER 2008 and also deployed SSIS packages for data transfer.

Environment: SQL Server 2005/2008/2008R2, SQL Profiler, T-SQL, SSIS, SSRS, SSAS, ERWIN, MS office

Client: Virtusa Software, Hyderabad, India September 2009 - April 2011

Title: SQL Server DBA

Description: Virtusa Corporation is a global information technology (IT) services company providing IT consulting, technology and outsourcing services. Using our enhanced global delivery model, innovative software plat forming approach and industry expertise, we provide high-value IT services that enable our clients to enhance business performance, accelerate time-to-market, increase productivity and improve customer service.

Responsibilities:

Responsible for the Installation, Daily monitoring, Maintenance of SQL Server 2005 installations in both the Production and Development Environments and also upgrades to SQL server 2005.

Experience in creating and deleting roles, users, logins, privileges, role membership, triggers and functions.

Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

Diagnosing and tuning the server optimal performance using SQL Profiler and Database Engine Tuning Wizards.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.

Designed and created databases, tables, views, store procedures and triggers.

Checking Database Health by using DBCC Commands and DMV’S.

Monitored and modified Performance using execution plans and Index tuning.

Recovered the System and User databases from suspect mode.

Monitoring locking/blocking and space management issues

Scheduling jobs and monitoring and troubleshooting them

Monitoring SQL/Windows/application/security event logs Monitor and support client server databases on Windows 2003/2005 servers.

Extensively worked on trouble shooting and fine-tuning of databases for its performance

Monitoring SQL server performance using profiler to find the performance and deadlocks.

Rebuilding the indexes at regular intervals for better performance

Involved in development and implementation of SSAS, SSRS and SSIS application solutions for various business units across the organization.

Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks

Implemented SSIS (SQL Server Integration Services) packages

Maintaining high availability of SQL servers by proactively monitoring the critical services in a 24X7 on call production support on weekly rotation.

Environment: Windows 2003, MS SQL Server 2005, SSRS, SSIS, SSAS, Erwin, SQL Server Profiler.

Client: DHANUSH INFOTECH, HYDERABAD, INDIA June 2007 - August 2009

Role: SQL Server Developer

Description: Dhanush InfoTech led by certified professionals with expertise in Research, Design, Development and Delivery of high-end Technology Solutions, has achieved the rank of global thought leaders in IT Services

Responsibilities:

Studied and understood the requirements of the information required by company’s Procurement Department about the vendors.

Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions

Data migration (import & export – BCP) from Text to SQL Server.

Normalization and De-Normalization of tables.

Developed Backup and Restore scripts.

Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.

Worked with developers on how to write better SQL, how to use more powerful features like table variables, how to avoid cursors, etc.

Written T-SQL queries for the retrieval of the data.

Worked with fellow developers in rewriting procedures, functions, triggers, table partitions, views for better functionality.

Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.

Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.

Used many transformations like Data Conversion, Derived Column, Conditional split, Multicast, Sort, Merge, Union All, Fuzzy Lookup, Fuzzy Grouping and also used for loop, for each Loop, Sequence container and Execute SQL task etc. I have hands on experience with BIDS.

Have good experience in SSRS reporting and also generated different kinds of reports like Tabular Reports, Matrix Reports, Parameterized Reports, Ad-hoc Reports, Drill down Reports, Drill through Reports, Sub reports, List & Chart reports as well as interactive reports according to business requirements in time restricted environment.

Created and executed the stored procedures and complex queries for reports.

Environment:

SQL Server Enterprise Edition/ SQL Server 2005, Crystal reports, T-SQL & Windows 2K platform.

Contact this candidate