HEMANTH
actlnm@r.postjobfree.com
Senior MS SQL Server 2012/2008/2005 DBA
PROFESSIONAL SUMMARY
* ***** ** ** ********** in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2012, R2, 2008 and 2005 in Production, QA, Reporting, Staging, UAT, Development, Replication and Clustered Server Environments.
Production Support:
Expert in handling production systems in 24/7 environment.
Good knowledge in Administering and managing Databases ranging several gigabytes..
Worked in OLTP and OLAP environment that includes Production (24x7), QA and development
databases in SQL Server.
Database Administration:
Installed and configured MS SQL Server2012/2008 R2/2008 and 2005 systems in all
Environments.
Knowledge in upgrading and migration systems from MS SQL Server 2005 to MS SQL Server
2008\2008R2 and from 2008R2 to 2012 with hotfix and service packs.
Good knowledge in tuning MS SQL Server 2008/2005 systems for optimal performance
Good skills in handing MS SQL Server systems in Clustered environments on 2008/2005
Published Reports to SharePoint Server utilizing Business Intelligence Development Studio.
Scheduled Reports to be delivered to SharePoint Document Library.
Experience in implementing Disaster Recovery and High Availability concepts like Log-
Shipping, Mirroring, Always on Availability Groups, Replication (Snap Shot, Merge and
Transactional with Updatable Subscriptions), Clustering (Active/Passive).
Implemented the new SQL Server 2005 concepts like Data partitioning, Online Restore, Fast Recovery, Database Snapshot, DDL triggers, Online indexing, DMV’S SQLCMD,T-SQL debugger, CTE, Secure Sockets Layer, certificates, and symmetric /asymmetric key and dedicated admin connection.
Good at SQL Server 2008 enhanced features like Filtered Indexes, Activity monitor, Multi
Server Query, Policy Based Management, Data compression, Backup compression,
Resource Governor, Performance Data Collector, Facets, and Transparent Data
Encryption.
Strong SQL Server Developer Skills including writing Transact-SQL Queries,stored procedures, user defined functions, views and Good understanding of Normalization /De-normalization, Database design and modeling (logical and physical).
Developed and Deployed SSIS packages for Import, Export and Bulk inserting data, Processing SSAS Cubes with multiple Transformations from various data sources.
Expertise in performing data transformations between servers using Export/Import, SQL Loader, BCP, DTS, SSIS, bulk insert, Copy, Xcopy and RoboCopy.
Performance Tuning:
Sound knowledge of performance tuning MS SQL Server 2008/2005 for best performance
Experience in fine tuning parameters on operating systems
Knowledge on Ticketing tools.
Good skills in using SQL Server 2008/2005 profiler trace for bottlenecks and long running
queries
Good knowledge in fine tuning stored procedure for super performance.
Good knowledge in fine tuning queries taking a long time.
Good knowledge in understanding query plans and statistics data.
Good Knowledge in Querying the databases using the Powershell scripts.
Experience in Creating, Suggesting and implementing Indexes (Clustered, Non Clustered and
Unique).
Experience in managing Alerts, Operators, Proxies and Jobs through SQL Server Agent and Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
Worked on using tuning wizard in MS SQL Server 2008/2005
Expertise in Performance Tuning, Client/Server Connectivity, Improving Efficiency of
databases performing Database Health Check using DBCC Utilities, Rebuilding indexes,
Updating Statistics, Partitioning Tables and Indexes, Scheduling Maintenance Tasks,
Avoiding Locks, deadlocks, Long running queries and Blocking.
Intensive experience in monitoring and tuning SQL Server database performance using DBCC trace flags, SQL Profiler, DMV’s, and Index Tuning Wizard, data base tuning advisor, Activity Monitor, Windows Performance Monitor and Power Shell.
Good experience in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS and Crystal reports across various environments. Expertise in generating Ad-hoc reports, data driven subscription, drill down reports, parameterized reports, linked reports, sub reports in SSRS. Hands on experience working with analytical and diagnostics reports.
Backup and Disaster Recovery:
Implemented sound backup strategy for all MS SQL Server 2012/2008/2005 database servers
Timely full backup / Differential backup and transaction log backup for all production,
Development & QA systems.
Experience in database upgrades and applying software patches to databases as per
application/client requirements.
TECHNICAL SKILLS
RDBMS: SQL Server 2012/2008R2/2008/2005.
Database Tools: Management Studio, BI Development Studio, SQL Profiler, Data
Transformation Services (DTS), SQL Server Integration
Service(SSIS), Sharepoint,SQL Server Analysis services(SSAS), SQL
Server Reporting Services(SSRS),QueryAnalyzer.
Languages: SQL, TSQL, Visual Basic 6.0, HTML.
Web Tools: MS-Front Page, Internet Information Server (IIS), MS-Outlook
Express.
Operating Systems: Windows 95/98/2003/2008 R2/2012/2012R2 and win 7, XP, MS-DOS.
Data Modeling Tools: IDERA, REDGATE, LITESPEED.
EDUCATION
Bachelors in Electronics and Communications.
JNT University,Kakinada,India.
PROFESSIONAL EXPERIENCE:
Client: LIFE-LOCK, AZ Jun 2015 - Present
Sr MS SQL Server DBA
Description: Life Lock is a leading provider of proactive identity-theft protection products and services for consumers and consumer risk-management services for enterprises. As a Senior Sql Server DBA,. responsible for all the production servers. Worked with developers, business analysts, other team members and clients to review the business requirements and translate them into database objects.
Responsibilities:
Installation and Maintenance of SQL Server 2012 and 2008R2 on Dev, QA, UAT and Production environments.
Triaging and resolving the alerts on a daily basis:-
i.Disk Space low on SQL Drives & Mount points
ii.Huge log files than set threshold
iii.Log Files larger than the threshold.
iv.High Memory Utilization
v.High CPU Utilization
vi.Open Transactions
vii.Long Running Transactions
viii.Refreshing the Databases
ix.Locking, Blocking & Deadlock issues.
Strong experience in working on Very Large Databases (VLDB) over 4 TB for OLTP & OLAP
Expertise in Always-on Availability Groups(AAG) and HA/DR setup and configuration.
Implemented new features of SQL 2012 like Always on, Column Stored Indexes & Contained
Databases in newly migrated servers.
Successfully implemented the Capacity planning for different servers.
Extensive knowledge on Backup and restore database process.
Good knowledge on Idera third party tool for database backup and restore.
Created and scheduled SQL JOBS thru SQL Agent.
Working closely with Development & Application teams to guide with best practices on writing
TSQL queries.
Writing Powershell scripts to make enhancements to existing functionality.
Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity
Worked on Remedy tickets like Servicenow.
Worked on Foglight performance tools.
Configured SQL Server Mirroring for High Availability across all production servers in SQL
Server 2008 R2.
Involved in migration of databases from SQL Server 2008 R2 to SQL Server 2012.
Worked on creating new users and roles.
Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
Configured Database mail, linked servers in SQL server 2012.
Managed SQL security for all users.
Created maintenance plan for good running database health.
Good knowledge on Log shipping and replication
Working with SCOM to monitor server across all the domains.
Good knowledge on system maintenance procedure like upgrade all Microsoft Products,
Patches, defrag the all Drives, apply OS updates (including thoroughly tested service pack).
Applied application specific updates (SQL post SP4, Exchange post SP3 hot fixes).
Good knowledge on upgrade process from 2005 to 2008 & 2008R2.
Provide good support to the Developer and QA Environment.
Involved in DR (Disaster recovery) environment
Created the standard operating procedures (SOP) for SQL Clustering, replication and log
Shipping.
Configuring and maintaining transaction and snapshot replication to replicate the data to
remote servers.
Deploying solution files for SSAS cubes across environments. Partitioning existing cubes using date parameter.
Created SSIS packages to process SSAS cubes and scheduled them using SQL agent.
24 X 7 On-Call rotation for production support
Environment: MSSQL 2012/2005-2008-2008R2, VMware, Citrix Server, IIS, windows OS 2008, win 7, Windows Cluster Server, BIDS 2005/2008/R2, SSDT 2012, SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, SSRS, Remedy, Lite Speed, TSQL, Stored Proc’s, SOX, Triggers, UDF’s, Constraints, DTS, BCP, Data Compression, Partitioning, Joins, DDL, DML, Cursors, Server Migration, Batch Files, Centralized Schema Repository, SAN, PowerShell, Active Directory, ODBC etc.,
Client: CHARTER COMMUNICATIONS, MO. Mar 2014 - May 2015
MS SQL Server DBA/ Developer
Description: Charter Communications, through its subsidiaries, provides entertainment, information, and communications solutions to residential and commercial customers in the United States. Involved in variety of areas including monitoring, analyzing, troubleshooting, securing, encrypting, tuning and maintaining SQL Server and related database products including integration with tools.
Responsibilities:
Managed and Administrated the SQL Server 2012/2008R2/2008 production and Non-production servers.
Administered and maintained production/Development servers with more than 2 TB of database size with complex structures.
Monitoring of database size and disk space in Production, Staging & Development
Environments.
Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
Conducted various meetings and conferences with application teams to meet corporate
milestone for database consolidation and data migration.
Enhanced Performance of Database by implementing table partitioning on multiple tables with hundreds of GB sizes, tuning by creating table partition by date range, and also by creating multiple data file groups for max utilization of I/O’s.
Most of the servers are Virtual Machine (VM).
Extensive knowledge on Internet Information Services (IIS).
Worked on Command Prompt (CMD).
Extensive knowledge in Virtual Machine (VM) and install the main versions of VM VMware
VsphereClient.
Successfully implemented Database Mirroring with High Availability Mode in SQL 2008 R2 and installed SQL Server in a cluster Environment..
Configured Transactional Replication and Log Shipping with SQL Server Management
Studio as well as basic account management and troubleshooting with connectivity.
Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions. Business Intelligence package design. Created tables and performed data imports and restores for successful migration. Scripting development and troubleshooting for various security syncing scripts to new databases as well as creation of database roles for granting Stored Procedure rights.
Good knowledge on CITRIX servers and Uptime Monitoring Systems.
Using third party tool like LITE SPEED for backup and restore the databases.
Worked on Remedy tickets like Change Management Request v3.0 (CMR).
Good knowledge on system maintenance procedure like upgrade all Microsoft Products,
Patches, defrag the all Drives, apply OS updates (including thoroughly tested service pack).
Upgrade the latest Net Backup client on the systems.
Documented up gradation procedures from MySQL to SQL Server and Oracle to SQL Server.
Gave a good support to the Developer and QA people.
Involved in creating SSIS packages. And wrote some SQL queries.
Developed and implement complex T-SQL, VBScript and PowerShell scripts for administration tasks.
Created the standard operating procedures (SOP) for SQL Clustering, replication and log
Shipping.
Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On Warning, On Pre and Post Execution, On Task Failed etc.)
Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
Configured Database mail, linked servers.
Built SSIS packages to import data from different sources and transform in the format required and load.
Deployed SSRS RDL files cross environments. Managed security using shared data sources for reports.
Experienced in configuring and maintaining transaction and snapshot replication to
replicate the data to remote servers.
Created the DTS packages to import and export the data from Oracle, MS Access and text
files to SQL Server.
24 X 7 On-Call rotation for production support
Environment: MSSQL 2005/2008/2008 R2, VMware, Windows 2008 server, Windows Cluster Server, BIDS 2005/2008, SQL Server Management Studio, Query Analyser, SQL Profiler, Performance Monitor, SSIS, SSRS, CA Service Desk, IT Service Catalog, SOX, Avamar, TSQL, Stored Proc’s, Triggers, UDF’s, Constraints, DTS, BCP, Data Compression, Partitioning, Joins, DDL, DML, Cursors, Server Migration, Batch Files etc.,
Client: MASTERCARD, MO SEP 2012-Feb 2014
SQL SERVER DBA
Description: MasterCard’s products and solutions make everyday commerce activities – such as shopping, traveling, running a business and managing finances – easier, more secure and more efficient for everyone. Handled the co-ordination between various locations. Configured databases across DR site with successful replication of production DB’s.
Responsibilities:
Managed and Administrated SQL SERVER 2008/2008R2 highly transitive Production Environment and Active passive clustered environment.
Worked to the max database of size 2 TB.
Migrated databases from SQL Server 2005 to SQL Server 2008R2 and documented the process with Pre-Migration and Post-Migration steps.
Handling Memory configurations for SQL Server 2008R2 and SQL Server 2008 on Windows
2008.
Implemented the SQL Server 2008/2008R2 concepts like Data partitioning,Snap shot
isolation, database mirroring, database snapshot, CTE, DDL triggers,online indexing, DMV’s, DMF’s,PIVOT, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and
dedicated admin connection.
Worked with Distributed Partitioned Views (DPV) for Load balancing between the Servers.
Configured more than 64 GB ram on 64 bit Environment.
Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a
part of Security Policies for various categories of users.
Migrated DTS packages to SSIS packages and Designed and developed SSIS packages using
different control flow tasks, Transformations and dataflow tasks.
Checking Database Health by using DBCC Commands and DMV’S.
Monitored and modified Performance using execution plans and Index tuning.
Recovered the System and User databases from suspect mode.
Involved with maintenance of ACTIVE/PASSIVE Cluster Environments.
Managed SQL Servers in 32/64 bit Clustered environments.
Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
Implemented transactional replication for data refresh.
Managed all Publisher, Distributor and Subscriber database environments for the replication
Expert in sizing and utilizing the Temp database in an efficient way.
Used log shipping for synchronization of databases.
Prepared Documentation for the Disaster Recovery plan
Implemented new topics like CLR integration on Development Server.
Wrote and debugged Stored Procedures and (DDL /DML)Triggers, Functions as per client
requirements
Extensively worked on trouble shooting and fine-tuning of databases for its performance
Designed and implemented comprehensive Backup plan and disaster recovery
Worked extensively in Query analyzer and profiler for tuning queries using variable for
characteristics and query costs.
Daily routine Developer/DBA tasks like handling user’s permissions and space issues on
Production and Semi-Production Servers and handling maintenance Jobs.
Handled monthly Database Refresh in QA-Test environment for testing of new Deployments
Did Performance Tuning of the Stored Procedures.
Routine Developer/DBA jobs like Backups and Restores
Good experience in data modeling and metadata services.
Used APPLY clause and also implemented with CROSS and OUTER APPLY to join tables
and table variable functions.
Hands on experience in trouble shooting database issues.
Update statistics, database integrity check and Backup operations
Installed, Configured, managed security for SSIS, SSAS, and SSRS.
Deployed SSRS RDL files cross environments. Managed security using shared data sources for reports
Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
Monitoring SQL server performance using profiler to find the performance and dead locks.
Worked on call 24/7 Support.
Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear
Case for Data Archival.
Environment: SQL Server 2008R2/2008 with clustering, Replication, T-SQL, BugZilla, DTS, SSIS, RedGate, Profiler, MOM, SQL Sentry, Share point,Sql Server 2008,Oracle 10g,TFS,LiteSpeed
Client: AIRTEL, Bangalore, India. May 2010 – June 2012
SQL Server DBA/ Devoloper.
Description: Bharti Airtel Limited is a leading global telecommunications company with operations in 20 countries across Asia and Africa. Headquartered in New Delhi, India, the company ranks amongst the top 4 mobile service providers globally in terms of subscribers. Main concentration in developing queries. Migrated Large databases without any data loss.
Responsibilities:
Installed SQL Server 2008 applied service packs and security fix for all servers.
Configured and maintained Log shipping architecture to provide backup server solution for 4
environments.
Implemented transactional replication for data refresh
Managed all Publisher, Distributor and Subscriber database environments for the replication.
Upgraded server from MS SQL Server 2005 to MS SQL Server 2008
Implemented SQL Server Mirroring on SQL 2008/2005 environments
Created the DTS, SSIS packages to import the data from MS Access and Oracle server to
SQL Servers.
Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and
oracle)
Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
Used containers for repetitive control flow tasks
Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import,Export control extensively in SSIS
Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS.
Scheduled package execution in SSIS
Installing of packages on multiple servers in SSIS
Extensively worked on SSIS for data manipulation and data extraction, ETL Load
Created extensive reports using SSRS ( Tabular, Matrix )
Installed, configured and maintained MS SQL Fail over clustering to provide server high
Availability.
Involved in tuning SQL Server databases using available tuning methods like index tuning
wizards, profiler and execution plans.
Involved in setting up transactional replication in production environment.
Created the standard documents for Disaster recovery testing and implemented them.
Experienced with database sizing and capacity planning for production servers.
Experienced with creating logical and physical database design for development projects.
Experienced with improving SQL Server using windows performance monitor to improve the
server performance.
Involved in securing the SQL Server environment and involved in setting up the user
permissions.
Experienced with creating database maintenance plans for efficient operations.
Created the backup schedule for production, test and development servers.
Worked with developers to do the database schema changes and database restore requests.
Involved in restore operations to refresh the data from production to test servers.
Experienced in troubleshooting production servers and fixed the user and application issues.
Environment: MS SQL Server 2008/2005, Windows 2000/2003/2008 Server Operating systems, SSIS, Windows Cluster Server, Windows Server 2003, SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, Team Track.
Client: Makro Technologies, India. MAR 2008 - MAY2010
Jr SQL Server DBA
Description: Makro Technologies is a leading global consulting and technology Services Company has a excellent domain competencies in Healthcare, Pharamaceutical, Financial, Telecom and many other. Established in 1996, Makro became most successful company of its kind.
Responsibilities:
Worked on SQL Server 2005 with latest Service Packs.
Involved in Performance Tuning on Production, QA and Staging servers of the current
project.
Involved in Monitoring Performance of different production servers.
Implemented Database mirroring for disaster recovery.
Maintained various databases for Production and Testing using SQL Server 2005.
Planning the location of data, index, and Transaction log files on the disk.
Performance tuning, and optimization of procedures and queries.
Worked with SQL server Profiler.
Created the backup and restore strategy for production and development environment.
Created Database Maintenance Planner for the Performance of SQL Server which covers
Database Integrity Checks, Update Database Statistics and Re-indexing.
Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
Managing schema objects such as tables, views, clusters, indexes, procedures, triggers &
maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
Administering the MS SQL Server by creating user logins with appropriate roles, dropping
and locking the logins, monitoring the user accounts, creation of groups, granting the privileges
to users and groups.
Database and Transaction log backups & restoration, backup strategies, scheduling the
backups. Backing up system & user databases and restoring them.
Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
Used BCP and Bulk Insert utilities and Worked with SQL Server Reporting Services (SSRS).
Environment: MS SQL Server 2005, Windows Server 2003, SSIS, SSRS, SSAS,Mirroring.