Sql Server Data
Resume:
Ranjit Routhu
Email: ************@*****.***
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