Resume

Sign in

Sql Server Data

Location:
Atlanta, Georgia, United States
Posted:
November 28, 2016

Contact this candidate

Laxmi Narsimha Reddy.konatham

(408)-***-****

acxoc0@r.postjobfree.com

Professional Summary

8+ years of Database Administration and Development experience on MS SQL Server 2014/2012/2008 R2/2008/2005/2000.

Expertise include Administration, Database Design, Performance Analysis of highly transactional servers and production support for Large (VLDB) Complex and Critical databases.

Extensive expertise with configuring High Availability and Disaster recovery scenarios like Always On, Clustering, Mirroring, Log shipping and Replication.

Documented Disaster Recovery plans and participated in disaster recovery drills.

Worked extensively on Multi-Subnet Clustering and Server consolidation. Troubleshooting Production issues, HA issues and AG alerts

Experience in implementing advanced features like Policy Based Management, Resource Governor, Data Collector sets, and Backup Compression Techniques.

Implemented the methodologies like Data partitioning,Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, Online Indexing.

Experience in creating cubes using MS SQL Analysis Services. Developed star and snowflake schemas. Working in both MOLAP and HOLAP environments.

Worked extensively on DMV’s, DMF’s, Mail Setup, Jobs and Alerts, DTA, SQLCMD.

Experience in working with Agile/SCRUM based product development teams, collect database requirements and provide solutions and recommendations for new schema, infrastructure or architecture.

Expertise in setting up High Availability and Disaster Recovery(HADR) solutions such as Active/Passive and Active/Active Clusters.

Performed Sharding and Vertical Partitioning in order to suffice the Application through put and good experience in resolving SQL Server blocking and Dead Lock Issues.

Expert in Performance Tuning by Index Defragmentation, Optimizing execution plans, Proper usage of indexes, Index Rebuild, Reorg.

Experience working with Profiler and Server side trace.

Expertise in reading and understanding Execution plan and fixing query to execute with low cost.

Expert in handling parameterized Reports, Drilldown Reports using SQL SERVER REPORTING SERVICES 2005

Designed effective Maintenance Plans for Backups (Full, Differential and Transactional Log) and RPO, RTO to recover point in time data in in case of disaster of server/center

Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.

Upgraded databases from MS SQL Server 2000 to 2005, 2012 and MS SQL Server 2008 to 2012, 2014.

Expert in extracting from different sources, transforming and loading data using transformation services like data transformation services like Batch processes, Import/Export, SSIS, DTS, BCP and Bulk Insert.

Hands on Experience with using Data Modeling Tools such as Erwin and MS Visio.

Extensive experience in Capacity Planning, Performance Tuning, Disaster Recovery, Troubleshooting, Backup and Restore Procedures.

Experience in SQL Server Reporting Services (SSRS) and Crystal Reports.

Overall database design that involves creating normalized databases, user authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.

Explicit expertise in installation and configuration of SCO (System Center Orchestrator 2012) and SCOM (System Center Operations Manager 2012).

Performed both single server and multiple server deployment of SCOM and its components.

Extensively worked on Data tier applications, deploying and managing dacpacs.

Hands on expertise on both Upgrading and Downgrading SQL Server to new versions and applying Service packs and Hot Fixes.

Expertise in implementing advanced methologies like Transparent Data Encryption (TDE), Page Level Compression and Column Stored Indexes.

Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.

Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc for finding out long running queries.

Explicitly used third party backup tools like Lite Speed, Fog light and Red gate.

Creation and maintenance of Databases, creating Roles and managing user permissions and Data Warehousing.

Experience in Troubleshooting and documenting root cause analysis.

Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL Scripts and Batch files.

Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.

Experience working with Window 2003 Enterprise Server and Windows 2000 Advanced Server Administration and Installation.

Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors and Develop and manage reports on SharePoint Server.

Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in database.

Monitoring and troubleshooting by checking Performance Monitor and Activity monitor.

TECHNICALSKILLS

Databases:

MS SQL Server 2014/2012/2008 R2/2008/2005, Oracle 11g/11gr2and 12c.

ETL & REPORTING Tools:

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Database Tools:

SQL profiler, SQL Query Analyzer, Index Analyzer, DTA, SQL Server Management Studio, Perfmon.

Third Part Tools

SCOM, Idera SQL Check, Companion,lite speed, Red gate, Veritas net backup, Erwin r7, Guardum, Cloudberry Storage Explorer.

Languages:

T-SQL, C/C++, Java, PERL, java script, Visual Studio2010/2012, XML, HTML, ASP.NET, VB.Net.

PROFESSIONAL EXPERIENCE

Paylocity IL Aug 2015 - Till date

Sr. SQL Server Production DBA

Description: Paylocity (NASDAQ: PCTY) develops industry-leading, cloud-based payroll and human capital management software solutions for medium-sized organizations. Paylocity provides comprehensive and easy-to-use solutions enable to the clients to manage their workforces more effectively. In this project my role was assigned as a Database Administrator for support and maintenance of the application databases

Responsibilities:

Installation and upgrades of SQL server SQL 2008 r2 and 2012 and 2014.

Migrated databases from 2005 and 2008 to 2012 and 2014

Installation, Setup and Management of Always On Availability on Multi subnet Cluster

Setup the Always On Availability for DR Node on a Traditional Cluster with Shared Volumes

Migrated SharePoint Database servers from 2005 to 2012.

Setup the Transact Replication from Multiple Publishers to One Subscriber

Apply patch and security updates on regular basis

SQL Server Logins and Windows Access Administration.

Repaired, Recovered, Database Synchronization for Disaster Recovery.

Database Performance Tuning using Data Tuning Advisor, Profiler and Extended events, DMV’s.

Managed Databases using Maintenance Plan, DBCC, Backup (Full, Differential, Log), Automated Backup to Blob Storage.

Performance troubleshooting for Production systems

Implemented partitioning and Page Compression for Very Large Tables.

Implementation of TDE (Transparent Data Encryption) and maintenance of Encryption Keys, Certificates and migration of Encrypted Databases across different environments.

Downgrading SQL Enterprise Edition to DE (Developer Edition 2012/2014) in Development Environments.

Installed, authored, and managed reports using SQL Server Reporting Services (SSRS).

Involved in capacity planning, sizing and database growth projections.

Configuring and setting up RAID levels for the Virtual Hard Drives.

Implemented disaster recovery strategy and configure relative job on DR.

Installed and Configured Microsoft monitoring tool System Center Operations Manager (SCOM)

Installed and integrating MOM Agents across different machines for SCOM monitoring

PowerShell scripts for Server Health monitoring and automated jobs for Blob storage

Create alerts for AG (Availability Groups) health and Extended Events for Dead Lock monitoring.

24*7 Production on call support

Aegon USA IA Oct 2014– July 2015

Sr. SQL Server DBA

Description: Aegon is one of the world's leading providers of life insurance, pensions and asset management. Ageon have operations in over 20 countries, including the USA where known as Transamerica. In this project my role was assigned as a Senior Database Administrator for support and maintenance of the application databases. Has been part of upgrade and migration project team

Responsibilities:

Involved in the Migration of Databases from SQL Server 2005 to 2012 and SQL Server 2008 to 2012.

Involved in migrating DTS packages from SQL Server 2005/2008 to SSIS

Performance tuning of slow running systems using performance counters/Data collector sets, SQL profiler, extended events.

Extensively used SSIS and DTS packages for Data Warehousing and Archiving.

Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, production support and Project review with client.

Optimize slow running queries to improve application performance.

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

Created backup and recovery strategy for the systems based on their RTO and RPO’s.

Configured and maintained transactional Replication Server.

Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.

Created alerts and notifications for System errors, insufficient resources, and fatal database errors.

Created Triggers to enforce data and referential integrity.

Involved in writing T-SQL Programming to implement Stored Procedures and Functions for different tasks.

Performance Tuning, Analysis and optimizing for SQL Server Application by using Performance monitor.

Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration

24*7 Production on call support

Environment :MS SQL Server 2005/2008/R2/2012, Windows 2003/2008, SSRS, SSIS, SSAS, PL/SQL, MS Access, Perl script, Erwin, companion, Idera, TSM/TDP.

State of Michigan, Lansing, MI Feb 2013 –Sep 2014 Sr.SQL Server DBA

Description: Clarity Public Retirement Administration Package is a framework that contains reusable software components that can be utilized to automate common functions within public retirement systems, including enrollment, benefit payments, benefit estimates, customer services and service credit purchases. In this project my role was assigned as a Sr.SQL DBA involved in production support, migrating the databases.

Responsibilities:

Working as a Production DBA with 50+ Production MS SQL Servers and 100+ Dev-Test SQL Servers and 1000 + Databases.

SQL Server 2005/2008 Production Database Administration.

Installed and configured SQL Server 2005/2008R2.

Designed and implemented comprehensive Backup plan and disaster recovery strategies.

Migrated DTS packages from Legacy system to SQL SERVER 2005.

Created and Maintained jobs, alerts and Maintenance plans.

Worked in Active passive and Active active cluster environment.

Worked in Huge Transactional, Merge Replication environment.

Extensively worked to implement Database mirroring, configured Principal, witness and mirror using the SQL SERVER 2005.

Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency

Used Online Indexing in SQL 2005.

Installed, authored, and managed reports using SQL Server 2005 Reporting Services (SSRS).

Configured and maintained Database Mirroring and CTE.

Maintained the database consistency with DBCC at regular intervals.

Set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.

Created Documentation for all the major activities done on day to day basis.

24*7 Production on call support

Environment: SQL Server 2005/2008/2008R2, Windows 2003, QNXT, Care Advance, Biz Talk, Crystal Reports, SSRS, SSIS, Visual Basic, .NET, ADP Pay Roll.

Barclaycard, Wilmington, DE May2012 – Jan 2013

SQL Server DBA

Description: Barclay PLC is one of the world’s largest and most respected financial services companies and has over 300 years of experience.

Responsibilities:

Manage and administer SQL server 2005\2008\R2\2012 servers.

Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012.

Deployment of databases, jobs, cubes from pre-production to production.

Building SQL 2008\R2 cluster environments on VMware or Physical windows

Performed installations of SQL 2008\R2\2012 on clustered and standalone servers

Upgradation of Sql server versions and applying patches and hot fixes.

Adding nodes to already existing clustered servers as a part of data load\High availability

Configured Transactional Replication and Log Shipping with SQL Server Management

Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.

Work on weekly Issues reports which are generated as a part of infrastructure setup.

Continuous monitoring server health with Idera

Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans

Configured Database mail, linked servers,Transparent Data Encryption (TDE) and Auditing

Performance tuning of databases by windows performance monitor and SQL Profiler

Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

Documenting the standard procedures on regular basis.

Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration

Resource planning and coordination for application migrations with project managers, application and web app teams

Involved in capacity planning, sizing and database growth projections. Worked with Data warehousing team in VLDBs environment for archiving the old data

Worked in a environment with Change management process (Service-now tool) in place for all kind of production and non production changes

24*7 on call production support.

Environment: MS SQL Server 2000/2005/2008/R2/2012, Windows 2003/2008, SSRS, SSIS, SSAS, PL/SQL, MS Access, Perl script, Erwin, companion, Idera, TSM/TDP.

Acuity Insurance, Sheboygan, Wisconsin Jan 2012 – April 2012

MS SQL Server Developer/DBA

Description: Acuity is one of the nation’s leading diversified health care benefits companies serving members with information and resources to help them make better informed. The project was about to design and develop the data model and to increase performance by writing different kinds of queries.

Responsibilities:

Performed backup/restore, created database objects such as tables, procedures, constraints, indexes and views, user security management. Designed database tables and relations between them through Normalization. Involved in project planning, scheduling for database module with project managers.

Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification.

Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.

Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.

Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.

Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning and optimizing indexes using Performance Monitor, Profile and Index Tuning wizard.

Experience on Import / Export using DTS and BCP utility.

Worked as a developer in creating complex Stored Procedures, Functions, Triggers, and views.

Involved in Database designing, Logical and Physical Data modeling using Erwin. Transformed logical model into Physical SQL Server Database. Created SQL tables using scripts and Erwin Forward Engineering Utility.

Environment: MS SQL Server 2000/2005/2008, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer.

TCF BANK, Minneapolis, MN May 2010 – Dec 2011

Sr.SQL SERVER DBA

Description: TCF Banks are affiliated with TCF Financial Corporation, a financial holding corporation based in Minnesota. TCF has 444 banking offices in Minnesota, Illinois, Michigan, Colorado, Wisconsin, Indiana, Arizona and South Dakota. TCF is now the 10th largest U.S. Visa® Classic debit card issuer ranked by sales volume.

Responsibilities:

Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2005.

Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005 database.

Created and optimized SSIS packages for data flow between SQL Servers.

Extensively used SSIS and DTS packages for Data Archiving.

Extensively worked on Extracting, Transforming and Loading (ETL) of Data from Excel, Flat file, Oracle to MS SQL Server using DTS Import/Export utility, BCP, DTS and SSIS Packages.

Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, production support and Project review with client.

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

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

Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.

Provide 24 X 7 dedicated support to all Production, QA & Development MS SQL Server Environments.

Installed, configured and maintained transactional Replication Server.

Checking Database Health by using DBCC Commands and DMV.

Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.

Created alerts and notifications for system errors, insufficient resources, and fatal database errors.

Created Triggers to enforce data and referential integrity.

Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.

Performance Tuning, Analysis and optimizing for SQL Server Application by using performance monitor and assist the SQL Developers in SQL tuning.

Environment: SQL Server 2000/2005, T-SQL, Excel, Advanced Windows 2003 Server & PVCS Version Control Management.

HDFC Bank, INDIA Aug 2008– April 2010

SQL server Developer/DBA

Description: HDFC bank is INDIA’s largest private sector bank by market capitalization and second largest overall in terms of assets. The bank is expanding in overseas markets and has the largest international balance sheet among Indian banks.

Responsibilities:

Involvement in the Design and Development of Database.

Creating Automatic data loading Procedures from the host system to master systems

Used stored procedures, bcp and DTS Packages

Involved in automation of the job and was involved in daily monitoring of the tables and indexes for performance

Monitoring Log shipping/Replication and trouble shooting of errors

Security issues related to logins database users and application roles and linked Servers.

Performance Tuning of SQL 7.0

Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.

Backup and Restoration of data/database.

Involvement in Development and Implementation and Designing the database

Creating Automatic data loading Procedures from the host system to master systems

Used stored procedures, bcp and DTS Packages

Security issues related to logins database users and application roles and linked Servers.

Timely completion of activities for database backup, restoration and health check of databases.

Involved in trouble shooting and fine-tuning of databases

Tuning front-end applications like Visual Basic and MS Access, which query the SQL Server databases. Troubleshooting ODBC and OLEDB issues between the application and the server.

Scheduling Full and Differential Database backups to disks, tapes or remote servers, using batch scripts, TSQL and Maintenance Plan Wizard and configure appropriate Recovery Model for the databases.

Environment: SQL SERVER 2000, MS-Access, Visual Basic 6, and Windows NT Server and Windows 2000.

EDUCATION

Bachelor of Technology, JNTU, INDIA.



Contact this candidate