SUMMARY

• Experience in installing, configuring and upgrading of SQL Server 2012/2008/2005 applying Service Packs and Hot Fixes.
• Wide knowledge on Implementing and monitoring of security at Server, Database and Objects level.
• Experience in performing Backup and Restore using different backup medias, Involved in creating and documenting Backup strategy & Disaster Recovery plan for production and development servers within specified maintenance Window.
• Actively involved in Installation, Configuration and Maintenance of Microsoft SQL Server Active/Active, Active/Passive Clustering.
• Configured a ‘warm standby’ by implementing Log Shipping as a fault tolerance mechanism for some of teh critical operational databases.
• Good experience in Automation Configuration by Creating Jobs, Alerts and Maintenance plans.
• Hands on experience with SQL Server Management Studio and T - SQL in constructing triggers, tables, user functions, views, indexes, covering indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Hands on experience on using Extraction, Transformation and Loading (ETL) tools like Data Transformation Services (DTS), SQL Server Integration Services (SSIS), BCP and Bulk Insert.
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle and Flat file using BCP, Bulk Insert and DTS utility.
• Hands on experience setting up Resource Governor for performance tuning.
• Knowledge on SQL Server and Database Monitoring and Tuning for better performance using different tools like Database Tuning Advisor, Systems Performance Monitor, Event viewer, SQL Profiler.
• Extensive knowledge in resolving Deadlocks, Optimizing SQL queries, Stored Procedures to improve performance to teh optimal level.
• Experience in implementing database consistency checks using DBCC utilities.
• Experience in connecting remote SQL servers as Linked Servers.
• Good knowledge of RDBMS and Database design issues like Normalization and De-normalization.
• Knowledge on Oracle Architecture. Performed maintenance tasks like taking backups using RMAN, performance tuning using TkProf, creating objects like packages, procedures, and functions.
• Experience in Data Modeling using Erwin Design Tool.
• Worked with third party monitoring tools like Idera diagnostic manager, Quest lite speed.

TECHNICAL SKILLS

Operating Systems: Windows Server 2012, 2008R2, 2008, 2003.

Databases: Microsoft SQL Server 2016, 2014, 2012/2008R 2/2008/2005/2000, Oracle Database Platforms

NO SQL/MySQL Databases: Cassandra, Mongo DB, PostgreSQL

Programing Languages: T-SQL, SQL, PL/SQL, PowerShell, HTML, C#, C/C++ &XML.

Database / ETL Tools: SQL Server Integration Services (SSIS), SSAS, DTS, Query Analyzer, SQL ProfilerTOAD.

Data Visualization tools: Microstrategy, Cognos, Tableau, Pentaho, Birst, Microsoft Power BI

Reporting Tools: SQL Server Reporting services (SSRS) and Report Builder.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

SQL Server DBA/Developer

Responsibilities:

• Project to perform huge data transfers between various servers. Involved in installation, configuration, and upgrade Microsoft SQL Server 2008 to 2016; using stand alone and in some cases in place installation as recommended by teh upgrade advisor.
• Troubleshooting slow running queries and teh health of servers utilizing teh activity monitor, performance monitor, dynamic management views, database command consoles and other third-party tools (Idera, Fog light, Imperva)
• Performed huge data transfers between various servers using BCP and SSIS for developer requests, Environment Migrations, Backing up and Archiving Data for various business requests.
• Designing Azure deployments based on client requirements, best practices, and following patterns and best practices developed by teh Agile team
• Migration of workload into Azure and expanding active directory from on premise to Azure
• Set up test, QA and production database environments.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Security Administration by creating user logins with appropriate roles, dropping and locking teh logins, monitoring teh user accounts, creation of groups, granted privileges to users and groups.
• Created Databases and Database Objects like Tables, Stored Procedures, Views, Triggers, Roles, Defaults, user defined data types and functions.
• Monitoring teh data files, log file space issues, blockings, and Temp DB space issues.
• Performed backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Setting up monitoring through batch scripts. Responsible for monitoring.
• Made recommendations for performance improvement in hosted databases which involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Installed, upgraded and applied teh latest service packs/hot fixes. Provided High availability through Log Shipping, Mirroring, Replication (Transactional). Production database administration of critical databases.
• Hands on experience with Big Data using Mongo DB, Cassandra, Microsoft Azure, Hadoop and other data visualization tools like tableau, Pentaho and Birst.

Confidential, Atlanta GA

SQL Server Developer

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of SQL Server 2012 on windows 2012 Servers.
• Involved in Set up, configuration and maintenance of Database Mirroring. Involved in installation of service packs and hot fixes, hands on experience using BI Cognos and Tableau, Data Warehousing and F.S Domain knowledge.
• Implemented Database Mirroring and Log Shipping and Always On to provide high availability. Responsible for Backup and Restore operations of Databases and Transaction logs on daily basis.
• Created Backup Strategies and Scheduled Backups for Disaster Recovery. Implemented and maintained Database Security operations such as Creating users, logins, Assigning Roles and assigning privileges at Server and Database Level.
• Scheduled and monitored all maintenance activities including database consistency checks, index defragmentation issues using teh DBCC commands. Worked on SQL Profiler, Tuning Advisor (DTA), Windows Performance Monitor with various objects and Counters, and DBCC commands to record and enhance teh overall performance.
• Ensured all Scheduled Administrative Jobs like Backup and Restore are running completed on time.
• Worked on monitoring and tuning of SQL scripts and long running queries.
• Used SQL Profiler for Monitoring memory, processor, Disk me/O, SQL Queries. Transformed data to and from various data sources by creating SSIS packages.
• Used BCP command line utility for data import/ Export. Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data.
• Resolved Deadlocking, Blocking and locking issues by creating a trace using SQL Profiler.
• Created database objects like tables, stored procedures, indexes, views, triggers, functions and cursors using T-SQL statements, worked with DML and DDL for retrieval and modification of teh data.
• Wrote complex Queries and Stored Procedures to generate reports every day for Server’s Health check, hand on experience using NO SQL, CASSANDRA, Mongo DB and IBM UDB other.

Confidential

SQL Server DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2012/2008 R2 on Test, Development and Production Environments. Implemented AlwaysOn High Availability in Microsoft SQL Server 2012.
• Involved in Major Migration Projects between data centers. Implemented and Maintained SQL Server Replication.
• Design and implementing security configurations using best practices and standards. Implementing and maintaining SOX controls and best practices for database security under SOX compliance.
• Working on role-based security models along with understanding of Active Directory best practices for databases/applications.
• Worked on huge projects like Data Center move and IP address change of all teh SQL Servers, Upgrading Production Servers and documenting teh process.
• Created Linked Servers between different Servers in SQL Server 2012 and SQL Server 2008 Environments and also between 32 and 64-bit Servers to access database objects in remote locations.
• Performed database consistency checks using DBCC Utilities and handling data corruption in user databases and identifying teh bottlenecks caused by complex queries using Activity Monitor, SQL Profiler and Performance Monitor.
• Used native tools like SQL SENTRY Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Designed teh Database Recovery Plan and implemented teh Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Designed and developed a full-scale reporting solution for a multi-client environment using Microsoft SQL Server 2008 and Microsoft SSRS 2008/2012. Created Tables, Triggers, Cursors and modifying Stored Procedures with change requests sent from development teams and working closely with Web/Change Management teams.
• Created SSIS Packages to get data from other sources to some of teh SQL servers and scheduling them as daily and weekly jobs.
• Created a SSIS Replication package from Production to 12 pool servers.
• Created Logins and Roles with appropriate Permissions.
• Fixed teh failed PRINCIPALS (logins), user permissions and security in Active Directory and at teh SQL Server Level.
• Used IDERA SQL Diagnostic Manager for Performance monitoring, analyzing and troubleshooting.