Post Job Free
Sign in

Sql Server Data

Location:
Round Rock, TX
Posted:
May 11, 2020

Contact this candidate

Resume:

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.



Contact this candidate