Resume

Sign in

Sql Server Manager

Location:
Hyderabad, Telangana, India
Posted:
November 27, 2018

Contact this candidate

Resume:

Sunil T

Contact no: +1-540-***-****

Email: ac7svv@r.postjobfree.com

PROFILE

Around 12 years of IT experience as a Senior SQL Database Administrator on a variety of Windows Platforms with SQL Server (2000,2005,2008,2012,2014,2016) Versions, Always on Availability,Clustering,Mirroring, replication,Logshipping, Installation, Configuration, Migration, Sizing and Space management, Backup and Recovery, Performance tuning and troubleshooting.Experience in,MYSQL,Oracle and NoSQL databases like MongoDb. Experience in data loading/extraction using DTS,BCP, Import/Export,. Experience in Various monitoring tools like Idera,SCOM configuration, installation, monitoring for the application running environments.Configuration, run-time administration, upgrade and 24x7 supports for production databases. Expert understanding of SQL utilities, including DBMS packages, Perfmon,Database Tuning Advisior. Excellent work ethic with ability to work alone and in a team environment. Strong analytical/problem solving, interpersonal, written and verbal skills.

TECHNOLOGY/SKILLS

Operating System: Windows 2000/2003/2012 Server, Windows XP/NT/7, Red Hat Enterprise Linux 3.0/4.0/5.0/10

Databases: SQL Server 2000,2005,2008,2012,2014,2016,MySQL.,MongoDb.

Programming Languages: SQL, Shell Scripting, PL/SQL, HTML,PHP.

Database Tools:,SSIS,SSRS,DTA,Red gate,Veritas Netbackup

EXPERIENCE

Comcast, Reston, VA December 2017- Present

Lead/Senior Database Administrator

Environment: SQL Server 2000/2005/2008/2012/2014/2016 Enterprise, Windows Enterprise Server 2012,Oracle SSIS, Always on, replication,Mirroring, MySQL,Ideara monitoring and Dell service operation manager (DSOM) .

Responsible for administration and support of SQLServer 2008,2008R2,2012,2014,2016 databases.

Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition..

Applied PSU/CPU and Grid patches for security purpose and covered all issue in 11g/12c.

Responsible for monitoring and making recommendations for performance improvement in hosted databases, which involves index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Administer database user accounts. Create, modify and deactivate user accounts; assign and monitor user access

Performed Database Refresh to the lower environments and fixing Orphaned Users.

Troubleshooting database Connectivity & network related Issues.

Rebuilding / monitoring the indexes at regular intervals for better performance.

Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.

Good Knowledge of using SSRS (SQL Server Reporting Services).

Performed Production support and on Call duties.

Executed Change management scripts on weekly basis.

Created monitoring scripts to alert for production issues.

Monitored overnight batches and fixing them in case of issues.

Reviewed DB Scripts from the development team before releasing them into the Production.

Designed and implemented Security policy for SQL Servers.

Tested and Implemented procedures to detect poor database performance, collecting required information, and root cause analysis

Administration and management of the entire development, QA and production environment.

Installed and configured MySQL on Linux and Windows environments.

Managing/Troubleshooting MySQL in production and developer environments on Linux.

Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.

Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.

Assisted with sizing, query optimization, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.

Worked with the engineering team to implement new design systems of databases used by the company.

Effectively configured MySQL Replication.

Designed databases for referential integrity and involved in logical design plan.

Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.

Coordinated with software development teams for fixing technical issues and database errors.

Conducted detailed analysis of business process and application requirements to prepare design documents.

Supported technical team members in installation, configuration and maintenance of SQL servers.

Maintained detailed technical documentation such as design documents and module specifications.

Worked MongoDb cluster setup, Sharding, MongoDb Replication.

Worked on Mongo Ops Manager to enable the monitoring for mongo databases.

Wide Ope West LLC, Denver January 2016 – December 2017

Senior Database Administrator

Environment: SQL Server 2000/2005/2008/2012/2014/2016 Enterprise, Windows Enterprise Server 2012, SSIS, Always on, replication,Mirroring, MySQL,Ideara monitoring and Dell service operation manager (DSOM).

•Administer database user accounts. Create, modify and deactivate user accounts; assign and monitor user access

•Analyzing the Tables and Indexes on performance base regularly.

•Monitoring Log spaces and Data files utilization.

•Monitoring the user sessions and take appropriate action to kill the inactive sessions.

•Created and tuned various materialized views.

•Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

•Installing second instance to the already existing cluster setup.

•Performed Database Refresh to the lower environments and fixing Orphaned Users.

•Troubleshooting database Connectivity & network related Issues.

•Rebuilding / monitoring the indexes at regular intervals for better performance.

•Recovering the databases from backups in disasters.

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

•Responsible for monitoring and making recommendations for performance improvement in hosted databases,which involves index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

•Designed and implemented comprehensive Backup plan and disaster recovery strategies.

•Extensively worked on DBCC commands and Dynamic Management Objects.

•Meet the SLA (Service Level Agreement) established.

•Documented database structure, changes, problems, issues for future reference.

•Monitoring of database size and disk space in Production, Staging & Development environments.

•Configured Transactional Replication and Log Shipping with SQL Server Management Studio.

•Conducted Performance Tuning using SQL Profiler and Fog Light Performance Analysis.

•Configured Database mail, linked servers in SQL server 2008.

•Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.

•Good Knowledge of using SSRS (SQL Server Reporting Services).

•Performed Production support and on Call duties.

•Executed Change management scripts on weekly basis.

•Created monitoring scripts to alert for production issues.

•Monitored overnight batches and fixing them in case of issues.

•Reviewed DB Scripts from the development team before releasing them into the Production.

•Designed and implemented Security policy for SQL Servers.

•Tested and Implemented procedures to detect poor database performance, collecting required information, and root cause analysis.

Client : E. I. du Pont de Nemours and Company November 2015 – January 2016

Senior SQL Database Administrator

Environment: SQLserver 2005,2008,2008R2,Remedy

Migration of legacy environments to SQL Azure (PAAS, IAAS) using Azure Data migration tool.

Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

Expertise in troubleshooting Replication issues.

Configured the Snapshot Transaction replication.

Expertise in Installation of SQLserver 2008 2008R2 for Standalone and RAC Environments.

Expertise in applying patches from SSCM and Manual

Addition of Datafiles to the production and standby database if any of the table spaces in critical state.

Resolving Database connectivity issues & Resolve application to database connectivity issues

Managing database security. Creating users and roles and assigning different roles to users.

Creation & Rebuilding of Indexes on tables as maintenance activities..

Performed the Switchover and Switchback for RAC Critical databases.

Identify the locking on database objects and resolve them appropriately by identifying and killing the blocking sessions.

Analyzing DB level & Schema level statistics at regular intervals.

Refreshing UAT/ development databases from production databases using export and import & BCP

ICICI Lombard October 2013 – November 2015

SQLDBA, Hyderabad

24x7 SQL Database Administrator for Production, Development and Standby databases and provided on-call support

Installed, configured and maintained SQL software.

Migration of databases from SQLserver 2005 2008R2 R2..

Experience on SQL Cluster and Monitoring Cluster databases

Configured Physical Standby Databases with logshipping

Monitored Standby Databases and perform switchover mechanisms using mirroring and Logshipping

Applied various patches on regular basis to SQLserver

Performed Backups (Full, Differential,Log), Recoveries

Created Materialized Views/Materialized Views Logs for data replications

Monitored Alert log and wrote scripts in SQL for quick health check of the databases

Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK

Daily Health Check Up of the Database using Poweshell and SSRS

Created users, granting and revoking rights and privileges as and when required in oracle database.

Conducted complete analysis of database capacity and performance requirements.

Implemented procedures for analysis, consolidation and tuning of databases for efficiency.

Supported technical team members in monitoring of systems and technical platforms for availability.

Coordinated with technical teams for installation and testing of upgrades and patches.

Suggested new database technologies and processes such as data warehouse and related reporting technologies.

Involved In DR activities

IBM INDIA PVT LTD March 2011 – October 2013

Database Administrator

Designed and configured high availability solution Database Mirroring.

Created logins and users and mapping the users/logins to the specific Database/Server roles.

Reviewed existing business procedures and recommended improvements and implemented the changes.

Involved in capacity planning, sizing and database growth projections

Scheduled Full, Differential and Transactional log backups for the user created and system databases in the production environment using the SQL Native Client Backup.

Deploying SSIS package and SSRS report in the production environment.

Performed lower environment refresh from the production databases.

Fixed Orphan users.

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

Used SQL Server Profiler to monitor and record database activities of particular users and applications.

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

Query performance tunings and complex issues fixations.

Perform and execute data extraction, transformation and loading using ETL tools for legacy data.

Troubleshooting Stored Procedures, jobs and SSIS packages.

Designed & Created Tables, Views, Triggers, and Stored Procedures using SQL Server 2008.

Altered the existing SSIS Package as per the client’s change request.

KARVY COMPUTER SHARE PRIVATE LIMITED, HYDERABAD June ’09- March ’11

Database Administrator

Responsibilities:

Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.

Involved in Analysis and Design Documentation, collecting user requirements and maintained good documentation.

Defined relationship between tables and enforced the referential integrity constraints.

Created Clustered and Non-Clustered Indexes to boost up the query performances.

Tuned the SQL queries using SQL profiler.

Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.

Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.

Understanding the table structure and flow design as per SRS and implementing the logics to migrate the data from client database.

Participate in implementation of new releases into production.

Solving the request raised by user support.

Monitoring the server for High availability of the servers

Involved in implementation of the ERP product at different sites. Took part in user training as a Functional Process Engineer at on site and fixed the bugs raised during transactions.

North Gate Technologies Limited, HYDERABAD May ’07- June ’09

Mysql DBA / PHP developer

Responsibilities:

Monitoring the spaces on all the Servers.

Monitoring the Log Space for successful execution of all the specified jobs.

Retrieving the failed and cancelled job steps.

Wrote Scripts for verifying Daily Backups, Log Space Utilization etc.

Debugging stored procedures

Tuning the Database Servers for Performance Testing

Manage backup and recovery of databases

Writing and executing scripts based on customer request

Security Management

Making calls regarding any database issues and troubleshooting and resolving Issues.

Monitoring Nightly maintenance process.

Resolving Problems related to Data transfer issues.

Environment: MySQL, PHP, Apache.

CERTIFICATIONS & TRAININGS:

Microsoft Certified DBA

Mongo trained DBA from Mongo university

ITIL certified

EDUCATION

MCA from AndhraUniversity 2005, India



Contact this candidate