Nithin
SR. SQL SERVER DATBASE ADMINISTRATOR
Ph: 845-***-****
Email *************@*****.***
SUMMARY:
Proficiently providing services in Information Data Management Services since last 10 years.
10+ years in SQL Server Administration, worked in MSSQL 2016/2014/2012/2008R2/ 2008/2005/2000 versions and Operational Supporting Activities.
Installed SQL standalone, SQL clusters and migrated from SQL Server 2005 to SQL Server 2008R2, SQL Server 2012, SQL Server 2014 & SQL Server 2016.
Worked in all phases of Release Management Lifecycles for Application and Data Warehouse Environments.
Accountable for the below Database Management Capabilities –
Incorporated Service packs, hot fixes and security patches.
Implemented advance features like table partitioning, indexing, file group.
Created Database Snapshot, Transactional and Merge Replications Services.
Involved On-call 24x7 supporting and maintenance Rollovers.
Build and supported databases for Application Normalized and Object-Oriented Data Models.
Build and supported databases for Operational and transactional log databases.
Performed Database Operations Supporting Activities –
User Authentications and Authorizations for Databases and Schemas.
Accountable for Database Backup and Recovery, Pruning Data Corruption, and Troubleshooting.
Experience with supporting SQL Server in cloud environment like Building and supporting processes to replicate data from an on-premise Datacenter to Microsoft Azure SQL VM.
Experience in Migration SQL server database to Microsoft Azure platform.
Supported, enhanced and tuned application views, stored procedures, functions and database triggers.
Implemented partitioning strategies as need basis requested by the Enterprise data architects.
Experience in the configuration of Log Shipping, Mirroring and High Availability Always-On Availability Groups
Creating Active directory accounts and giving access to the users.
Managing and supporting Delphix Virtualization Platform
Good understanding of VDBs (Virtual databases) like Delphix Masked VDBs.
Wrote Advanced SQL functions in T-SQL.
Involved in Query Optimization, Client/Server connectivity’s, database consistency and System DMVs.
Experience in extracting and transforming transactional information using DTS Import/Export Wizard, BCP (Bulk Copy Program), DTS (Data Transformation Services) and SSIS Packages from SQL Server
Created and maintained job plans, scheduling the jobs, Sending Alerts, Mail configurations.
Strong interpersonal and communication skills.
CERTIFICATIONS:
Microsoft Certified Professional (Certification ID:10640465)
EDUCATION:
Bachelors of Electronics and Data Communications, JNTU, India
Master’s in Data Networking and Security, Birmingham City university, UK.
TECHNICAL SKILLS:
Category
Technologies
Operating Systems
Windows 95 /98/2000,2012, DOS, Linux, Unix,
Languages
Windows Power shell Scripting, T-SQL, PLSQL, SQL
Storage
EMC-SAN Clarion,
San Tools
EMC Navisphere 6.0, Multipath Software
Hardware
DELL 6850 Servers, DELL 6300 Servers, SAN arrays, Pentium PC’s and Windows 2000,2008,2003,2012,2016 Servers
Cisco Firewall
ASA firewalls, Fort iGATE, Sonic
Databases
SQL server 2000, 2005, 2008, 2012,2014, 2016, 2017, & 2019
ETL tool
Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Services (SSAS)
Cloud
Microsoft Azure Cloud Computing, SQL Server Azure
SQLServer Monitoring Tool and replication tool
Solar Winds, Red-Gate, SQL Sentry, Golden Gate, Attunity, PerfMon
PROFESSIONAL EXPERIENCE:
Client: Dell 10/2016 – Till Date
Location: Round Rock, TX
Role: Lead SQL Server Administrator with Delphix Quality Engineer
Key responsibilities:
Test data management Project to facilitate using Masked production data for development and testing purpose by using Delphix and Delphix masking tools.
Responsibilities:
Creation of User Database and Installation of SQL Server 2008/2008 R2, 2012, 2014 & 2016.
Involved in Install, configure, monitor, upgrade, patch and tune SQL Server 2008,2012,2014 & 2016 servers
Security Administration: creation of users, Roles and granting appropriate privileges.
Implementing Backup and Recovery Strategies and supporting Delphix Database Virtualization Platform
Expertise in implementing of high availability Always-On Availability and disaster recovery mechanism like replication models, log shipping, database mirroring.
Creating DSources from the production database on Prod Delphix engine, creating VDBS from them and replicating to Non_Prod by using SQL Delphix replication.
Creating DSources from the production database on Prod Delphix engine, creating VDBS from them and replicating to Non_Prod by using Oracle Delphix replication.
Creating DSources from the production database on Prod Delphix engine, creating VDBS from them and replicating to Non_Prod by using MYSQL Delphix replication.
By using MYQSL work Bench i have written Store procedure to mask a data before replicating it to non_prod ENV.
Suggested improvement processes for increasing efficiency of applications and current processes.
IF we have any network issue, we will raise a service now ticket and work with Network Team
Worked with golden gate to create the Oracle VDBS.
Creating SQL and Oracle Delphix Masked VDBs from them for end clients.
Involved in Day-to-day activities such as Agent Jobs, Backups and Recovery, Services, Index, Database growth, health and consistency check, Data maintenance (partitioning, archiving and purging), issue\ problem maintenance and management, Incident management, Security maintenance etc.
Recovered the database during the event of crash on several occasions. The Recovery was done to Point-in-time.
Involved in SQL Server performance using index tuning wizards, SQL Profiler and SQL Query Analyzer.
Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor {DTA}.
Worked closely with the application team, network team and storage teams on various projects.
Upgrade DTS Packages to SSIS Packages
Assist ETL Developers to write and debug SSIS packages
Worked on debugging and troubleshooting the database issues and code issues.
Involved and implemented the Disaster recovery process to the critical databases and Instances as per MSFT standards.
Involved and worked with the Change management, Release management for the smooth releases and of application\server\db installation or db patch\upgrade
Provide 24 X 7 Production Support DBA with On-call Rotation.
Worked as team player in resolving issues, documentation etc.
Environment: MS SQL Server 2008/ 2008 R2, 2012, 2014 & 2016, Microsoft Azure, Delphix tool masking, Delphix jet Stream. Quest Foglight monitoring tool
Client: Dell 05/2016 – 09/2016
Location: Round Rock, TX
Role: Lead SQL Server Administrator
Responsibilities:
Successfully Upgraded from SQL Server 2008/2008 R2 to SQL Server 2012 and SQL 2012 to 2014 on development and Testing Environment.
Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in development and Testing Environment.
Worked in Active/ Passive Cluster environment.
Developed disaster recovery plans and contingency systems including evaluating and recommending appropriate backup and archival software, hardware, and media, offsite storage.
Generated test data and check databases consistency to meet the functionalities requirements.
Creating logins and roles with appropriate permissions.
Experience with supporting SQL Server in cloud environment like Building and supporting processes to replicate data from an on-premise Datacenter to Microsoft Azure SQL VM.
Experience in Migration SQL server database to Microsoft Azure platform.
Configured MS SQL Server 2005 in-built log shipping from primary server to standby server for report generation
Working, planning for pre-deployment information and installing third party tools for monitoring purpose like IDERA SQL Diagnostic, Dynatrace AppMon, and Quest Foglight etc.
Configured Various Replication Types between Primary Server and Read–Only servers.
Installing applications and establish the connectivity with the database.8
Creating Stored Procedures to convert database tables into XML format and display via web.
Monitored database performance and rebuilt indexes on tables using Index Tuning Wizard to reduce fragmentation.
Upgrade DTS Packages to SSIS Packages
Assist ETL Developers to write and debug SSIS packages.
Involved in Performance tuning, and optimization of procedures and queries.
Worked with SQL Server Profiler to generate traces.
Controlled and monitored user access to the database, backed up and recovered the database, maintained system security and monitored/optimized database performance for Data warehouse and OLTP applications.
Helped Development Team in deploying and testing the application, which uses SQL Server 2005backend.
Environment: MS SQL Server 2008/2008R2/2012, SSIS, SSRS, Replication, Migration, OLAP, OLTP, Alloy and TSRM Ticketing System, VERITAS net backups, IDERA SQL Diagnostic, Dynatrace AppMon, and Quest Foglight etc.
Client: Molina Healthcare 04/2014 – 04/2016
Location: California
Role: Sr. SQL Server Administrator
Key responsibilities:
Resolved performance Issues of over 50 million records of Mass Adjudication and then reduced run time
Managing and supporting all 50+ SQL Server Instances (Cluster, Virtual ENV)
Involved in WV-DDI project using Attunity Replication Server
Responsibilities:
Involved in Application Release Activities to implement into SQL Server Databases 2008 and 2012.
Actively participated in Critical Services to restore the databases and storage management.
Discover how Datical's database release automation solution helps you deliver better application experiences with today's database deployment process
Responsible for Installation, Upgrades, Migration and Configuration Activities.
Involved in Database Recovery Analysis and Testing and SQL Database Tuning Advisor {DTA}. Addressed Database. Performance Issues, Space Enhancements and Capacity Planning Projections.
Day to Day Operations including Security Administration and Maintenance and User Authentication like (LDAP)
Creating Active directory accounts and giving access to the users.
Worked with Application Development and Reporting Teams to incorporate Objects Creation Process.
Maintained the databases on Highly Availability Architecture and Implemented.
Worked on Locks, Deadlocks, Handling Isolation Level and Concurrency Effects, Detect CPU, I/O, Memory Bottlenecks.
Migrated DTS Packages from SQL Server 2008 to 2012 SSIS Packages. Implemented event handlers and error handling in SSIS packages and notified process results to various user communities.
Managing and supporting Delphix Database Virtualization Platform
Performing Cloning and Refreshing the database with De-source copy (Delphix)
BizTalk servers used to connect the SQL Server database and get the information from it for their reporting purpose.
Monitoring the servers by using SQL Server 2008 tools like SQL Server Management Studio (SSMS), SQL Server Profiler, SQL Server Agent, and Database Tuning Advisor (DTA)
Performance data collected around the clock as a persistent source for trending and support.
Visualization and Trending services to track and report on the impact of recommendations.
Developed standards and guidelines to guide the use and acquisition of software and to protect assets.
Created, back up, restore of production databases into development environments.
Performed SQL server backups by using lite speed.
Modified the existing databases to enhance the application product development process.
Understands business requirements and translates them into high quality SSRS report deliverables.
Able to build and maintain automated ETL processes by coding-SQL and DTS Packages.
Testing and implementing ETL mappings and scripts.
Implemented Event Handlers and Error Handling in SSIS packages.
Responsible for providing 24 X 7 critical production support
Environment: MS SQL Server 2008 and 2012, Windows 2003 Server, SSRS, SSIS, MS Visual studio 2008, T-SQL and DTS Packages, LiteSpeed, solar winds monitoring tool
Client: Olive Data Centre 03/2013 – 03/2014
Location: Hyderabad, India
Role: Sr. SQL Server Administrator
Responsibilities:
Supporting Database Administrator for UAT, Performance and Production Environments.
Installed, Configured and Monitored SQL Server 2008R2 and 2012 Database Servers.
SQL Server Database Upgraded from 2005 to 2008 R2.
Implemented Log shipping activities in SQL Server 2005 and 2008 R2 into remote servers.
Created and maintained User Authentications and Authorizations defined by Client requests.
Refresh the production copied data into UAT and Development Environment upon request.
Implementation of SQL Server 2012 Always on High Availability in Windows server 2012 64-bit environment.
Supported, Developed and Migrated DTS packages into SSIS Packages.
Created packages in SSIS with custom error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.
Created the automated processes for the SSIS Packages run sequentially using SQL Server Agent job.
Supported and Developed schema object type write-ups for an application development teams.
Using SQL Server Profiler traced bottlenecks and re-writes the query to improve performance.
Proposed and rebuilt index paths to reduce fragmentation by monitoring database table usage access paths.
Implemented backup and archival software, hardware, media, and offsite storage solutions.
Configured Replication for Data Warehouse Servers from Application Servers.
Created and scheduled daily, weekly and monthly Database Backup, Mirroring, and Replication scripts.
Created on Data Models deployment, Data Integrity, and Views and Stored Procedure activities.
Created Views, Stored Procedures, Functions and Triggers for application
Implemented Database Mirroring with HA mode in SQL Server 2008R2.
Environment: MS SQL Server 2008/2008R2/2012, SSIS, SSRS, Replication, Migration, OLAP, OLTP, Alloy and TSRM Ticketing System
Client: BCU, London 06/2009 – 11/2012
Location: London, UK
Role: SQL Server Administrator
Responsibilities:
Installed and configured SQL Server 2008/2008R2 Enterprise and standard edition in the production environment.
Installed, Configured and Monitored SQL Server 2008R2 and 2012 Database Servers.
Installed service packs and security fix on production, test and development servers.
Installed, configured and maintained MS SQL failover clustering for mission critical servers
Involved in monitoring the backup jobs and resolved the issues for failover jobs.
Created manual Log shipping environments for standby servers.
Involved in securing SQL Servers and assign the permissions for users and roles.
Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
Worked with various SSIS packages which involve Transactions, restart ability and roll back techniques.
Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process
Supported and build Erwin created forward engineer data models provided by Data Modeling team.
Addressed server performance issues by Performance monitor using I/O, memory and CPU counters.
Used index tuning wizard, SQL Profiler and SQL Query Analyzer for performance issues.
Tunes SQL queries and stored procedures to improve the SQL Server performance.
Created maintenance plans for integrity checks and server optimization process.
Created database backup strategy for production, test and development environments.
Responsible and support engineer for disaster recovery procedures and restore the production databases.
Involved in database restore and refresh process for various environments.
Environment: MS Windows Server 2008 R2 Enterprise Edition, MS SQL Server 2008/2008R2, SQL Profiler
Client: Vaagdevi Engineering College 02/2007 – 10/2008
Location: Hyderabad, India
Role: SQL Server Administrator
Responsibilities:
Responsible for support on QA, Preprod and Production servers.
Installed SQL Server 2000 and 2005 on windows 2000 and 2003 servers, installed service packs and security fix on production, test and development servers.
Installed, configured and maintained MS SQL fail over clustering.
Involved in monitoring the backup jobs and fixed the failed jobs. Created manual Log shipping environments for standby servers.
Involved in securing SQL Servers and assign the permissions for users and roles.
Involved in improving the server performance using Performance monitor using I/O, memory and CPU counters.
Experienced in involving SQL Server performance using index tuning wizards, SQL Profiler and SQL Query Analyzer.
Experienced in creating backup strategy for production, test and development servers.
Involved in disaster recovery procedures and restore the production databases.
Involved in database restore requests and refresh the database between productions, test servers.
Created the maintenance plans for integrity checks and optimization for production, test and development servers.
Tuned SQL queries and stored procedures to improve the SQL Server performance.
Environment: MS SQL Server 2005/2000, Windows 2000/2003 Server Operating systems.