SUMMARY

• Certified Sr.SQL Server DBA with 9Years and 3 months of experience in MS SQL SERVER 2017/2014/2012 , 2008R2/2008/2005 Database Administration in Production, Test and Development and SIT environment.
• Hands on Experience inAmazon web services LikeIAM,EC2, EBS,S3,RDS(sql server) Cloud watch and CLI tool.
• Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2017/2016/2014/2012/2008 R 2/2008/2005.
• Experience in building policies for access control and user profiles using AWS IAM, S3 controls with bucket policies.
• Expertise in Querying RDBMS such as SQL Server and RDS.
• Experience in handling very large databases in OLTP and data warehouse environments, which are in Terabytes size.
• Expert in RDBMS software installation, database server builds, applying patches, applying patches in VM environments (VTM), upgrading, configuring, troubleshooting of SQL SERVER on Windows 2003/08/12/16 servers and Clustered VMware Environments.
• Expertise in new features Data Compression, Transparent Data Encryption (TDE), Resource Governor, Policy Based Management, Backup Compression and Change data capture.
• Knowledge in Disaster Recovery plans by configuring Clustering, Log - shipping, Mirroring and Replication (Snapshot and Transactional).
• Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes.
• Experience in configuring Replication and troubleshooting the issues with transactional replication.
• Experience in query optimization and performance tuning.
• Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Expert in tuning the long running Queries and Store Procedures by examining the execution plans.
• Hands on experience in troubleshoot the tempdb growth and configuration settings.
• Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries.
• Excellent skills in database Backup, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defrag Tables, Replication, Linked Servers and Database Maintenance Plan.
• Hands on experience using DMVs and DMFs to finding and solving Performance Issue.
• Expert in Detecting and Resolving Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
• Expert in creating and debugging Views, Functions, Indexes, Cursors, Stored Procedures, Triggers, optimizing code and improving Efficiency.
• Expert in migrating the DTS Packages to SSISPackages by using Package Migration Wizard.
• Worked Extensively on ETL process using SSIS packages.
• Expertise in configure the PerfMon and Extended Eventsto troubleshoot the performance issues.
• 24/7 on call production support.
• Hands on experience on ITIL process.
• Expertise in automating the system by using System Center Operations Manager (SCOM).
• Hands on experience on configure the Solarwinds DPA alerts.
• Basic knowledge on SAP ME/MII application.
• Expert in raising the Service Requests and keep tracking of requests.
• Good Team player, Strong Communication skills and interpersonal with Self-motivation.

TECHNICAL SKILLS

Relational Databases: SQL Server 2017/2016/2014 / 2012 / 2008 / 2008 R2 / 2005.

Database Tools: SSMS, Query Analyzer, SQL Profiler, BCP, ODBC, SQL OLEDB, DBCC, DTA, PerfMon, Extended Events,ADO, ADO.NET, Business Intelligence Studio(SSIS

Languages: C#, XML,HTML, SQL, T-SQL

Operating Systems: Windows 2016, Windows 2012, Windows 2008R2, Windows 2003, UNIX. AWS EC2.

Web Servers: IIS 5.0/6.0/7.0, Amazon web services (AWS), Virtual Private Cloud (VPC).

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

ETL: SSIS, SSRS, DTS.

Virtualization: VMWare ESX/ESXi, Amazon AWS/EC2.

Monitoring: Solar winds DPA, App dynamics.

Ticketing Tool: ITSM, Cherwell,Service Center

Cloud Computing: AWS (EC2, ELB, S3), Azure, AWS Elasticache, Cloud Formation, Cloud Watch, CloudTrail, IAM, CloudFront, Glacier, Route53, RDS, DMS.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005/2008 , MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor. Active Directory, SQL Navigator, Sybase Data Tools, SQL Profiler, SQL Networking, Activity Monitor, DTA, PerformancePoint, Sybase Data Tools, SQL Profiler, SQL Networking, Activity Monitor, DTA, PerformancePoint,, Site Recovery Manager (SRM), SAP ME/MII.

Environment: s: SIT/DEV/QA/Production

PROFESSIONAL EXPERIENCE

Confidential

SQL server Database Administrator Consultant

Responsibilities:

• Identify problematic tables and prepare Implementation plan for cleanup the tables.
• Create database tables based on SAP MII application functionally.
• Create user defined stored procedures to run multiple transactions in limited duration on SAP MII application.
• Design triggers for automatic executions after user committed transactions.
• Create User defined functions based on SAP MII application requirement.
• Create Views and Synonyms to collect the sales data for Reporting Purposes.
• Configure SQL JDBC connections between database servers and SAP MII application servers.
• Import the application required data to databases from SAP MII application binary file systems.
• Work on database development activities on Development environment and subsequently make changes on Quality and Production environments.
• Work on ITIL process to implement the make database changes on each environment (I,e Development, QA and Production environment).
• Work on provide the SQL database accesses to respective stakeholders and share the credentials in encrypted format.
• Develop T-SQL queries for better performance.
• CreateLinkedserver between the Netviewer database and Reporting database.
• Create Views and Synonyms to collect the sales data for Reporting Purposes.
• Configure the automatic database maintenance jobs for continuous monitoring.
• Monitor the database server’s performance through performance counters.
• Monitor the day to day transactions from Solarwinds DPA and Identify T-SQL long running queries.
• Analysis long running queries and create the indexes, recommend for query tuning.
• Work on query analysis and ensure locking and blocking should not occur during parallel process.
• Analysis the SQL query execution plan and duration and if any significant changes find the root cause and resolve the issue.
• Capture column fragmentations and work on for column defragmentation.
• Develop auto rebuild, re-organize and update statistic maintenance jobs for column defragmentation.
• Review and monitor SQL servers and Instance resources to insure continuous database operations (I.e, database storage, memory, CPU, network usage and I/O contention).
• Involve in all Deployment phases (I,e D1,D2A,D2B and D3) to streamline the plants are in-line with SAP MII application requirements.
• Work on make changes on SQL database objects (I,e tables, Stored procedures, functions) per application requirements on Development environment and subsequently move to Quality environment.
• Test the required changes on QA environment and move same changes to Production environment.
• Work on establish the connectivity with database server and SAP MII application.
• Work on troubleshoot the production issues and find out the root cause analysis.
• Perform the database development activities in tables, stored procedures and Functions during cutover and application maintenance window in each deployment phase servers as required.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Create SQL server instances and databases with appropriate initialization parameters and database structures.
• Check for the database maintenance failed jobs, investigate the route cause analysis and resolve the issue.
• Co-ordinate with respective stakeholders and SAP MII application team and identify the records with respective column key parameters within the respective table (I,e Delta changes) between each Deployment phase.
• Compare and Identify delta changes on during each deployment.
• Work on import the same delta changes on required databases.
• Work on identify and cleanup the data that not require further after discuss with SAP MII application team for better performance.
• Work as part of a project team to coordinate database development and determine project scope and limitations.
• Review the errors from SQL server error logs and work on fix the issues.
• Plan coordinate and implement security measures safeguard production and sales order data against to unauthorized users.
• Support to SAP Basis administrator team while configures the SAP MII application for providing database level input parameters.
• Troubleshoot the issues on configure the SAP application with respective database level.
• Work on Third party application vendors to understand the application functionality and provide recommendations and feedback to Leadership team.
• Responsible for Performing SQL server upgrades, conducting performance analytics, and tuning and system sizing and configuration.
• Monitor SQL instances and logs and take corrective actions if problems arise.
• Attend troubleshoot calls and resolve the issues during Hypercare.
• Support responsiveness to outages and issues.
• Collaborates with developers/application designers in solving critical defects of application before release dates.
• Developed a .bat file to shrink the log file after successful log backup file job completed on Cummvalut
• Excellent communication skills, both written and verbal are required for this position.
• Perform other tasks and duties as assigned by supervisor.
• Installed application on AWS EC2 instances and configured the storage on S3 buckets.
• Amazon IAM was used to maintain the user credentials and also involved in creating custom IAM policies to various groups defined within the organization.
• Created SQL native backup jobs in AWS environment servers.

Environment: SQL Server 2005/2008R2/2012, T-SQL, Windows Server and SAP Manufacturing Integration and Intelligence, AWS, Cloud Watch, S3, EBS, EC2, RDS, DMS, EC2, Cummvalut

Confidential

SQL Server Database Administrator

Responsibilities:

• Installation, configuration and upgradation of SQL server 2012,SQL servers 2014 and SQL server 2016 on Windows 2008 and Windows 2012 based on Enterprise Distributed Security (EDS- IBM) standards.
• Upgrade/migration of several instances and databases from SQL Server 2000 to SQL Server 2005/2008, SQL Server 2005 to SQL Server 2008/2008 R2, from SQL Server 2008/2008R2 to SQL Server 2012/2014.
• Preparing the documentation and implementing the Disaster Recovery Plans using Database Mirroring, Log shipping and Replication with different topologies for production databases.
• Involved Disaster Recovery excise and got CREDO awarded.
• Configure the Server administration in various environments - Window 2000 & 2003 with Active Directory Services (AD, DNS, DHCP).
• Migrating the Database from SQL server 2000 to SQL server2008 and from SQL server 2008 to SQL server 2012/SQL server2014 on SIT/DEV/QA/PRODUCTION region.
• Hands on experience on taking Database backup and Restore on SQL server2008/SQL server2008R2/SQL server2012/SQL server2014 from SQL server 2000/SQL server 2005.
• Migrated the DTS packages from SQL server 2005 DTS to SQL Server 2008 and above into SSIS packages incoordination.
• Configuring of SQL Server new features like Always On Availability Groups, Contained Databases, Change data capture (CDC), online index rebuilds, Central management server, Transparent Data Encryption (TDE), User-Defined server roles.
• Used multitask data pump in DTS/ETL.
• Assist with database transaction and security audits.
• Troubleshoot and problem solving of SQL related issues, including advising on customer issues.
• Attending the Production troubleshoot calls on 24*7.
• Reviewing T-SQL code and maintaining coding standards in all SQL Server environments.
• Hands on configuring Tempdbwith considerable Memory and Raid Levels for better performance.
• Creating and Maintaining Trace Audits for Security events.
• Involved in the meetings with Line of Business for requirements gathering and modified procedures according to the business requirements.
• Created and used Materialized views and DB links for remote instances to retrieve data from other databases.
• Created and Modified existing functions and procedures based on business requirements.
• Setting up Connection Strings and connecting SQL Server Databases from application front.
• Involving on application migration activities from windows 2003 to windows 2012.

Environment: SQL Server 2005/2008R2/2012, T-SQL, Windows Server, HTML 4.0, JavaScript, Access, SQL Query Analyzer, BI Data Tools (SSRS, SSIS, SSAS), Mysql

Confidential

SQL Database Administrator

Responsibilities:

• Managing of database objects like Tables, views, indexes.
• Created views for easier implementation on web pages, and wrote triggers on those views to provide efficient data manipulation.
• Backing up entire user’s database and scheduling backup process.
• Successfully resolved deadlock issues by creating traces objects using SQL Server Profiler.
• Worked on Server Native tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Responsible for migration of databases from one version to other versions and applying patches.
• Migrated SQL server 2005 databases into SQL server 2008 databases by In-place upgrade and also used upgrade advisor tool for up-gradation.
• Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
• Implement the New features like Table and Index Partitioning for Larger Tables in SQL Server 2005 for achieving performance enhancement.
• Created logical and physical design of new database to fit new business requirements and implemented new design into SQL Server 2005.
• Actively participated in gathering of User Requirement and System Specification

Environment: SQL Server 2005/2008, T-SQL, Windows Server, HTML 4.0, JavaScript, Access.

Confidential

Database Engineer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• DBA activities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Calculate disk space and table space requirements and Involved in capacity planning, estimating and sizing of tables.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Involved in Data modeling to develop the database design using Erwin.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database Links and formatted the results into reports and kept logs.
• Provided 24/7 critical production support for data issues and given appropriate solutions.

Environment: SQL Server 2005, T-SQL, CVS, Windows NT/2000/XP.

Confidential

Software Engineer

Responsibilities:

• Installed SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012 with latest service pack and hot fixes and documented the same.
• Implementing high availability using Replication, Log shipping and mirroring technologies
• Set up maintenance tasks such as database backups, consistency checks and Database optimizations.
• Install, Configure and deploy SSIS, SSRS and SSAS.
• Performance tuning, trouble shooting and monitoring using Performance Dashboard reports.
• Database Tuning Advisor, SQL Profiler, Server Side Trace, Dynamic Management views (DMV).
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data.
• DBA activities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Calculate disk space and table space requirements and Involved in capacity planning, estimating and sizing of tables.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Involved in Data modeling to develop the database design using Erwin.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots andmaterialized views for remote instances.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on userinputs.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, databaseLinks and formatted the results into reports and kept logs.
• Provided 24/7 critical production support for data issues and given appropriate solutions.

Environment: .NET Framework 3.5, Visual Studio 2008,C#.net,ASP.Net,Web Services, SQL Server 2005.