Post Job Free

Resume

Sign in

Sql Server Data

Location:
Fairfield, CT
Posted:
July 13, 2017

Contact this candidate

Resume:

Ranjit Routhu

Email: ac1afe@r.postjobfree.com

Mobile: 470-***-****

Professional Summary

• Over 10 years of IT experience in Microsoft SQL Server Database Administration, Design, Development & Support. SQL Servers 2014,2012,2008 R2,2008,2005,2000 in Production and experience in data warehousing including business intelligence tools SSIS Development environments and experience in design, development, testing, production support.

• Managed and administered 2500+ database in 300 instances

• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems

• Having Experience on Data center servers and handling 6 TB databases.

• Performed Installation, Configuration, Maintenance and Administration of SQL Server 2016/2014/2012/2008R2/2008/2005/2000.

• Migration SQL Database from on premises to SQL Azure.

• Expertise in defining Database Backup, Restore, Recovery and Disaster Recovery Procedures.

• Responsible for Providing 24x7 dedicated support to all Production, Clustered & Development servers.

• Expertise in SQL Server Always-On Availability Groups and HA/DR technology

• Administering SQL Server High Availability and Disaster Recovery strategies

Log shipping & Mirroring

• Solid experience on high availability SQL Server solutions, including Replication Models (Snapshot, Transactional) and SQL Server clustering (Active-Active, Active-Passive).

• Created monthly & yearly growth report for capacity planning.

• Designed the Backup-Recovery plans to minimize the data loss and faster recovery.

• Experience in applying patches, cumulative updates and hot fixes to keep the database at current patch level.

• Optimize Database performance using SQL Profiler and Database Engine Tuning Advisor, Extended Events, Activity Monitor, Performance Monitor(Perfmon), Dynamic Management Views (DMVs).

• SQL Server Production Server monitoring using SCOM, SQL Idera UMAP tool, Solar wind, UMAP

• Resolving database corruption issues, bring back databases from suspect mode to

online mode, deadlocking

• Expertise in T-SQL writing stored procedures, triggers and functions, Views

• Created numerous simple to complex queries involving joins, correlated sub- queries, functions, cursors, dynamic T-SQL.

•Created maintenance plans to perform Re-indexing and update the index statistics.

• Hands on experience in Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS).

• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.

Education

• Bachelor’s Degree in Computer Science (B.sc) from Andhra University, India completed in 2004.

Technical Skills

Operating systems : Windows server 98/2000/2003/2008/2008R2/2012R2

Languages : T-SQL

Tools : Litespeed,IDera,Solarwind,Sanovi,Profiler,DTA,Actvity Monitor

Databases : MS-SQL Server 2000/2005/2008/2008R2/2012/2014.

Data migration : DTS, SSIS, BCP, SQL Loader, Import/Export Wizard.

MS-Office : Word, Excel, Outlook

Reporting tools : SQL Server Reporting services

Monitoring Tools : ServiceNow,SCOM,HP SERVICEMANAGER,UMAP

ETL TOOLS : SQL SERVER INTEGRATION SERVICES(SSIS)

Domain Knowledge : Banking, E-Governance, Power

Certification

Microsoft Certified Technology Specialist (Administering Microsoft SQL Server 2012 Databases - 070-462)

Microsoft Certified Technology Specialist (Implementing a Data warehouse with Microsoft SQL Server 2012 70-463)

Professional Experience

GE, Atlanta Feb 2016 to present

Sr. SQLDBA

Environment : VM ware, Windows 2012/2008 R2 Server, SQL Server 2016/2014/2012/2008R2, Microsoft visual Studio 2008,C#.NET,ASP.NET

Responsibilities:

• Hands on experience for SQL Server 2008R2/2012/2014/2016 versions.

• Handled Large size databases up to 6TB

• 24 X 7 Production Database On-Call Support following the escalation matrix

Supporting the team in high priority issues.

• Responsible for installing, configuring SQL server cluster and troubleshooting issues with SQL Cluster

• Monitoring HADR technologies Always on, Clustering, Replication

• Configuring & monitoring on Snapshot and Transactional replication

• Monitoring & Maintaining Active/Passive clustering

• Table partitioning (Range Partitions) on Large size tables

For monthly and year partitions.

• Implemented Table partitions on existing tables and new tables to shifting data into

Multiple partitions to improve the performance

• Performed SQL cluster upgradation from SQL Server 2008R2 to SQL Server 2014

and 2016 Versions

• Subscribe SQL Server Azure Cloud Services.

• Create Databases on SQL AZURE

• Setting up SQL Azure Firewall

• Create & manage SQL Server AZURE Databases

• Migrating SQL Databases from on premises to SQL Azure

• Knowledge Active Geo-Replication For Azure SQL Database

• Strong experience in Capacity Planning, Implementing Backup and Recovery Strategy for application and database.

• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes.

• Increased RAM in SQL Server clustered environment to avoid performance issues

• Increased tempdb files as per core count to avoid tempdb contention

• Resolved the performance issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.

• Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler, Extended Events

• Implemented Weekly Maintenance activities Re-indexing, Update statistics, Check dB

on user and system databases

• Monitor SQL Server health using SQL Idera Diagnostic Manager

• PowerShell scripts for automation on backup schedule

• PowerShell to automate multiple database SQL Server restores

• Monitor Disk space using PowerShell

• Monitor a SQL Server Cluster using PowerShell

• Experience in Database Security and Management.

• Creation of Schema objects, rules and granting of roles to the users.

• Implemented MS SQL Server security policies and granted object level permissions.

• Worked on the space issues because of Transaction log growth as well as data file growth.

• Experience in creating Jobs & Scheduling jobs, Alerts, Operators, Database mail configuration and schedule SSIS Packages.

• Synchronize data between Production & QA servers using backup & restore snapshots

• Using ServiceNow tool to implement changes on Production and QA environment

• Developed database objects such as stored procedures, user defined functions, triggers, views, Complex queries, indexing, Cursors.

● Enable dynamic logging of package run into a text file.

● Enable auditing of package and underlying expensive tasks into a database table, to help in performance tuning.

● Create SSIS packages to move data from (XML, CSV and TXT) files to SQL database.

● Create parameterized reports to accommodate business required.

● Create drill down and drill through reports.

● Enable multithreading on SSIS packages for parallel processing property of SSIS.

Group O, IL Aug 2014 to Jan 2016

Sr. Database Administrator

Environment : VM ware, Windows 2012/2008 R2 Server, SQL Server 2014/2012/2008R2/2005,Microsoft visual Studio 2008,C#.NET,ASP.NET, SharePoint, IIS Web server

Responsibilities:

• Configuring & Monitoring HADR technologies Always on, Clustering, Replication

• Monitoring SQL Server Production and QA servers using MS SCOM tool

• Knowledge in Install windows server 2008r2/2012 installation

• Knowledge in windows server 2008R2/2012 Failover cluster installation

• Experience in installation of SQL Server failover cluster installation(Active/Passive) and Active/Active cluster.

• Handling backups & restores using TSM (Tivoli storage management), Maintenance plans.

• Experience in configuration of transactional replication

• Set up firewall rules for your database

• Enable SQL Database auditing on Azure Cloud

• Enable SQL Database threat detection Azure

• On-Premises SQL Server Database to the SQL Azure Cloud

• Implemented SQL Data Sync ON SQL AZURE

• Migrate your SQL Server database to Azure SQL Database

• SQL Server restart times using PowerShell

• PowerShell script to report SQL Database Status

• PowerShell to automate databases SQL Server restores to refresh environments

• Performed database server migrations from SQL Server 2000, 2005 to SQL Server 2012,2014

• Performed DR drill operations for user testing the application.

• Creating & altering databases.

• Maintaining Files & File Groups.

• Performing SQL SERVER Health check using spotlight

• Performed installation of SQL Server Patches and Hot fixes.

• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.

• Ability to work independently as well as work with teams having varying backgrounds on complex issues and have strong verbal and communication skills

• Manage referential integrity, domain integrity and column integrity by using the constraints.

• Experience writing complex SQL Queries and Procedures.

• Designed database object as stored procedures, user defined functions, triggers, views, complex queries, indexing, etc

• SQL Server import/export process to transfer data between DB servers

• Create indexes, statistics to optimized queries by using execution plan for tuning the database.

• Optimization of stored procedures using SQL Profiler and Database tuning wizard.

• Optimized queries by altering database design, analyzing different query plans and indexing strategies, Optimize existing SQL Code.

• Query Analyzing using Execution Plans to troubleshoot performance issues.

• Managing SQL Server Agent Jobs & Alerts.

• Implementing Change Data Capture(CDC)

• Implementing Data Compression in Page level and Index level

• Developed, deployed SSIS Packages & upgraded into SSIS

Latest versions

• Migration of SSIS packages from SQL server 2005 to SQL Server 2008R2 & 2012

•Developed SSRS reports such a Sub Reports, Charts, Matrix reports, Linked reports.

• Deploy and provide security to SSRS reports

•Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

City National Bank, CA April 2013 to July 2014

Sr.SQL Server DBA

Environment: Window server 2012/2008R2/2008, SQL Server 2012/2008R2/

2008/2005, C#.NET, ASP.NET, SharePoint, IIS Web server

Responsibilities:

• Maintained total 150 production servers, DR Server, Development, Test servers

• Experience in handled Large size databases 2 TB

• Maintain & troubleshooting experience in HADR technologies Clustering,

Replication, Mirroring, Log shipping.

• Applying patches at Active/Passive clustering

• Installation of SQL Server failover cluster installation

• Performed DR drill operations for user testing the application.

• Performing SQL SERVER Health check using spotlight

• SQL Server Production Server monitoring using Red Gate tool

• Maintaining Files & File Groups.

• Finding SQL SERVER Health check reports

• Performed installation of SQL Server Patches and hot fixes.

• Performed up gradations from SQL server 2005 to 2012/2014

• Migration of DTS packages to SSIS packages

• Developed, deployed SSIS Packages & upgraded into SSIS

Latest versions

• Scheduled maintenance plans for Rebuilding & Reorganizing indexes, Update statistics

• Scheduled DBCC commands to troubleshoot issues related to database integrity & Consistency issues.

• Experience writing complex SQL Queries and Procedures.

• Developed database objects such as stored procedures, user defined functions, triggers, views, Complex queries, indexing, Cursors.

ICICI bank Mar 20011 to April 2013

Sr.SQL Server DBA

Environment : VM ware, Windows 2008R2/2008/2003 Server, SQL Server 2012/

2008R2/2008/2005/2000, Microsoft visual Studio 2008, C#.NET, ASP.NET, SharePoint, IIS Web server

Responsibilities:

• Performed database server migrations of ICICI bank applications Lombard general insurance, ICICI Prudential insurance, I-direct servers

• Performed DR drill operations using Sanovi, 3rd party tool for user testing the application.

• Handled total 400 Production, DR, Development servers

• Experience in handled Large size databases 1.4 TB

• Creating & altering databases.

• Maintaining Files & File Groups.

• Performed Pssdiag performance tool to find slowest top 10 queries.

• Finding SQL SERVER Health check reports by using RAS, UMAP tools

• Performed server installation and configurations for SQL Server 2012, 2008R2, 2008, 2005 and 2000.

• Handling backups & restores using Symantec, VERITAS backup tools & Maintenance plans.

• Performed installation of SQL Server patches and hot fixes.

• Involved in capacity planning, sizing and database growth projections

• Scheduled Full,Diff & Transactional log backups for the user databases and system databases in the production environment using the Database Maintenance Plan Wizard • Setup backup and restoration jobs for development and QA environments

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

• Experience writing complex SQL Queries and Procedures.

• Developed database objects such as stored procedures, user defined functions, triggers, views, Complex queries, indexing, Cursors.

• Implemented SQL Server DB import/export process

• Maintained the indexes, statistics and optimized queries by using execution plan for tuning the database.

• Tuning and optimized queries by modify database design, analyzing different query options and indexing strategies, Optimize existing T-SQL code.

• Analyzed Execution Plans to troubleshoot potential performance issues.

• Implementing Change Data Capture(CDC)

• Implementing Data Compression in Page level and Index level

• Developed, deployed SSIS Packages & upgraded into SSIS

Latest versions

• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.

• Migration of DTS packages to SSIS packages

•Developed SSR reports such a Sub Reports, Charts, Matrix reports, Linked reports.

• Deploy and provide security to SSRS reports

• Maintaining Security Roles and System Role Maintenance SQL Server Reporting Services

• Monitor more than 400 database servers which are handed over to us

• Monitoring of database Growth and disk space on Production

• Monitor the Log shipping servers and backup reports and disk space

Lakshmi villas Bank Dec2009 to Mar 2011

SQL SERVER DBA /BI Developer

Environment : Windows 2008 Server, Microsoft visual Studio 2008,C#.NET, ASP.NET, SharePoint, IIS Webserver, BIDS (Business Intelligence Development Studio), SSMS, PROFILER, DATA TUNING ADVISOR,ACTIVITY MONITOR

Responsibilities:

• Performed SQL server installation and configurations for SQL Server 2008, 2005

• Performed installation of SQL Server Service Packs.

• Scheduled Full, DIFF & Transactional log backups for the user databases and system databases in the production environment using the Database Maintenance Plan Wizard • Monthly Data Extraction Process from Flex Cube to Sql Server 2008 Database Using SSIS packages

• Daily General Ledger (GL) Data Extraction package running

• After Loading Data to Production Verifying LVBMIS Reporting System

•Trouble Shooting with SSIS Package Errors

• Developed, deployed SSIS Packages & upgraded into SSIS

Latest versions

• Deploy and provide security to SSRS reports

• Maintaining Security Roles and System Role Maintenance SQL Server Reporting Services

• SQL Server Profiler to monitor and capture database activities of users and applications.

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

ORIENTAL BANK OF Commerce Sep2008 to Dec 2009

SQL SERVER DBA

environment : Windows 2003 Server, Microsoft visual Studio 2008,C#.NET, ASP.NET, SharePoint, IIS Web server,BIDS (Business Intelligence Development Studio),SSMS(SQL SERVER MANAGEMENT STUDIO),PROFILER,INDEX TUNING WIZARD,PERFMON

Responsibilities:

• Performed SQL server installation and configurations for SQL Server 2005

• SQL Server Profiler to monitor and capture database activities of users and applications.

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

• Every month Extracting Finale data from oracle database to Sql Server database

• After Extracting Data into Database validate the database

• Generate OBC MIS Reports Monthly wise

• Creating Stored Procedures and User Defined function and views

• Create New Reports Based on Bank Formats

• Verifying that backups have been created and successfully saved to a secure location

• Monitor disk space to ensure your SQL Servers won’t run out of disk space

• Developed SSRS reports such as drill down & drill through reports, Sub reports, Matrix reports and Charts using SQL Server Reporting Services (SSRS)

• Deploy and provide security to SSRS reports

• Maintaining Security Roles and System Role Maintenance SQL Server Reporting Services

• Involved in all phases of the project (Documentation, Designing, Unit testing and Defect fixing).

• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.

• Manage referential integrity, domain integrity and column integrity by using the constraints.

• Create specified columns for Primary Keys in all the tables at the design time

• Create User defined functions to provide custom functionality as per the requirements.

• Identify potential blocking, deadlocking and write code to avoid those situations.

Municipal Corporation of Delhi Government (Sep2007 to Sep2008)

Database Developer (MS SQL SERVER2000/2005)

Environment: Windows 2003 server, Java, JDBC, SQL server 2000/2005, Apache Tomcat server, SQL Profiler, Data Tuning Advisor, SQL Server Mmanagement Studio.

Responsibilities:

• Installation, configuration and creation of database.

• Implemented security planning with three user groups for the application

• Writing stored procedures,user defined functions,creating indexes

• Experience writing complex SQL Queries and Procedures.

• Developed database objects such as stored procedures, user defined functions, triggers, views, Complex queries, indexing, Cursors.

• Implemented SQL Server DB import/export process

• Maintained the indexes, statistics and optimized queries by using execution plan for tuning the database.

• Optimized queries by altering database design, analyzing different query options and indexing strategies, Optimize existing T-SQL code.

• Daily monitoring of database that included checking for fragmentation, alert log

• Estimated the space requirements for various data structures used in the and trace files, checking the backups etc application.

• Modified the database structure accordingly.

• Setting up database privileges and roles.

• Worked on tuning of SQL scripts auto trace utility, tuning of memory and tuning of disk utilization.

• Controlling and monitoring user access to the database.

• Configuring log shipping & monitoring

Delhi Employment Exchange (Mar2006 to Sep2007)

Database Developer (MS SQL SERVER2000/2005)

Environment : windows 2003 server, Java, Jdbc, Jsp,SQLSERVER 2000/2005,Apache Tomcat server, SQL Profiler, Data Tuning Advisor

Responsibilities:

• Installation, configuration and creation of database.

• Implemented capacity planning for data storage retrieval.

• Daily monitoring for Backups & Job maintenance

• Modified the database structure accordingly.

• Setting up database privileges and roles.

• Worked on tuning of SQL scripts auto trace utility, tuning of memory and tuning of disk utilization.

• Controlling and monitoring user access to the database.

• Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors

• Written Stored Procedures to display the data in front end application.

• Utilized T-SQL on daily basis in creating customs view for data and business analysis.

• Optimized queries by Modifying database design, analyzing different query options, and indexing strategies, Optimize existing T-SQL code.

• Expertise in T-SQL writing stored procedures, triggers and functions, Views

• Created numerous simple to complex queries involving joins, correlated sub- queries, functions, cursors

• Involved in all phases of the project (Documentation, Designing, Unit testing and Defect fixing).

• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.

• Ability to work independently as well as work with teams having varying backgrounds on complex issues and have strong verbal and communication skills

• Manage referential integrity, domain integrity and column integrity by using the constraints.

• Create specified columns for Primary Keys in all the tables at the design time

• Create User defined functions (Scalar, Inline, Multi Tables statement)

• Identify potential blocking, deadlocking and write code to avoid those situations.



Contact this candidate