CORE COMPETENCIES:

• Enterprise Database Administration
• Business Intelligence
• SQL Server Database Replication and Disaster Recovery Methods
• SQL Server Migration/Upgrade
• Database Security Management
• Database Design & Development
• Performance Tuning Techniques
• SQL Server Automated Backups & Recovery
• Strong Interpersonal Skills
• Effective Leadership
• Excellent Project Management
• Clear Written & Verbal Communication Skills

TECHNICAL PROFICIENCIES:

Applications Related Tools: Business Intelligence Tools like Power BI, SSIS, SSRS, SSAS, Team Foundation Systems - Source Control, SSDT, Crystal Reports, ORM Tool - Entity framework model and Custom End-Tier Model, APEX SQL Diff, Microsoft Azure, Red Gate SQL Monitor, TOAD, SQL*PLUS, Oracle Applications 11i, R12(Oracle Financials and Supply Chain), Reports 10g, Forms 10g, Discoverer, XML Publisher, Secure Shell, Blade Logic Server Automation, MongoDB Compass, Idera SQL Diagnostic Manager, Idera ER/Studio Data Architect, SQL Server 2016 Data Migration Assistant, Visual Studio 2012, 2015, 2017, Azure DevOps Server 2019

Languages: T-SQL, PL/SQL, Visual Basic for Applications, HTML, XML, Power Shell Scripting, DAX, Python

Databases: SQL Server 2005/2008/2008 R 2/2012/2014/2016/2017 , Oracle 10g/9i, Sybase ASE 11.9, MS Access, MongoDB 3.4, MySQL, MarkLogic Server

Operating Systems: Windows, MAC OSX, Linux, Ubuntu (VMWare, Hyper- V)

PROFESSIONAL EXPERIENCE:

Lead Database Administrator

Confidential, WASHINGTON, DC

Responsibilities:

• Core concentration in designing the below four areas
• Database Health Check
• Continuous Integration and Continuous Deployment
• Data Warehouse and Data Marts
• Business Intelligence
• Common Services Platform Dashboard
• Automated Database Audit Notifications
• Using Power BI to implement Self Service Business Intelligence
• Integrating Application Logs, Error Logs, Audit Logs and Diagnostic Logs from Common Services with Power BI
• Implemented Organization wide Operating Systems Dashboard
• Designed Self Service Database Dashboard and Application Portfolio
• Integration of multiple SharePoint lists and Calendars
• Capacity Management Metrics, Database and Server Inventory statistics via Power Shell and SSIS Packages
• Custom-Implemented Database Standards and Deployment Metrics to evolve Database Health Check with Power BI. This helped as One Platform for the development teamSpearheaded Migration of 15 Database servers containing 1000+ databases with over 3TB of data
• Lead DBA in migration of SQL Server 2008 R2 to SQL Server 2016 Databases
• Maintained perfect coordination between different team members and users. Project was accomplished much before the actual deadlines under my direction. With this, our Team was awarded another million-dollar worth in Revenue for the contract
• SQL Server Upgrade included
• Databases
• Database projects
• SSIS Packages
• Massive Database cleanup of obsolete users, logins, accounts across all environments in Software development Lifecycle
• SQL Server to MySQL Database Migration for Drupal Databases.Restructured Source Control to facilitate Database Automation
• Deploying database objects via Source Control
• Deployed SSRS Reports via Source Control
• Facilitated migration of TFS to DevOps Server 2019.
• Working on Integration of Git with Azure DevOps Server 2019 along with CI/CD Pipelines.

ENVIRONMENT:

• WINDOWS 2016
• SQL SERVER 2016
• POWER BI
• VISUAL STUDIO 2017
• IDERA ER/ STUDIO
• IDERA SQL DIAGNOSTIC MANAGER
• Azure DevOps 2019

Confidential

DATABASE ENGINEER / Consultant

Responsibilities:

• Chief Architect in designing a complete automation process for Privileged User Monitoring Review.
• This process consolidates about 40GB of Audit data from various data sources via SSIS Packages and delivers an end product which includes email notifications, weekly reports and in parallel helping to reduce the manual effort from 40+ hours to less than 2 hours.
• Active member of the Database Engineering Team in providing solutions, improving performance, automations, spinning newer environments, capacity planning, performance reports and delivering end-to-end product(s).
• Architected a Centralized Database Engineering Dashboard by gathering metrics, statistics and other metadata about 1500 Database Servers and around 9000+ databases.
• Continual effort to consolidate the Database Servers capacity from 8+ different database platforms, archive weekly data, designing, developing and implementing the Dashboard Database.
• Upgraded SSRS 2008 reports and Mobile Reports to Power BI Reports.
• Spearheaded and personally involved in a Total makeover of the Database Engineering Dashboard with the help of Power BI Reports with top notch features like Drill-down Visualizations, highly interactive pie and bar charts, viewing and exporting specific set of data selected by the user.
• Effective combination of database design and power bi reports helped in successfully re-inventing the wheel.
• Played the role of a Database Tester for an automation project which deals with integrating shell scripts as a part of One-Stop Build Application via Version One - Agile Methodology
• Hands-on experience with Change Control, Incident Management and Raising requests etc.
• Part of the initial setup of the in-house MongoDB Environment.
• Successfully completed Self-Training courses from MongoDB University. 1) MongoDB for DBAs 2) MongoDB Performance
• Multiple nominations towards Customer appreciation

ENVIRONMENT:

• WINDOWS 2012
• SQL SERVER 2008 R2/2014/2016
• POWER BI JUNE 2017
• UNIX SHELL SCRIPTING
• SSRS MOBILE REPORTS

Confidential

Sr. DATABASE ADMINISTRATOR

Responsibilities:

• Maintained, supported and fine-tuned multiple Database Servers under different environments of Software Development Life Cycle (Development, QA, Production Simulator and Production). Each server consists of at least 50 databases which also includes Case Sensitive Collations.
• Active member of the Database Administration Interview Panel.
• Solely involved in Design, Development and Implementation of Source Control for Database Projects related to multiple applications of U.S. Dept. of Agriculture - Foreign Agricultural Services Agency.
• Handled major Database Releases every week with Microsoft Team Foundation Server (Source Control) acting as the repository for the database scripts.
• Part of the Design, Maintenance and Implementation group of DBA Team.
• Co-lead Database Administration during Sybase ASE 11.9 to SQL Server 2008 R2 Migration. SQL Server Migration Assistant was used extensively during the Migration Process. This helped about 70% of the Migration and the rest 30% were involved in Post Migration Fixes viz. conversion, incompatible stored procedures and functions to be on par with SQL Server 2008 R2.
• Involved in the process of migrating all the current database(s) and its servers to SQL Server 2012 including a different domain. This involves SSIS Packages, SQL Jobs, Logins, Maintenance Plans, verification of different service accounts and beta testing for any compatibility issues.
• Deploying SSRS reports in each environment of Software Development Life Cycle. (SDLC). This included developing a custom command shell script to download the SSRS Reports stored as binaries in the database and upload to corresponding report servers.
• Attended Designing Database Solutions for Microsoft SQL Server 2014 Training (20-465) which plays an emphasis on Cloud based platform Microsoft Azure.

ENVIRONMENT:

• WINDOWS 2008 R2
• SQL SERVER 2008 R2 / 2012
• VISUAL STUDIO 2012
• SSRS REPORTS

Confidential

DATABASE ADMINISTRATOR

Responsibilities:

• Involved in building and managing enterprise database systems designed to handle high volume, sensitive court case and official public records transactional data.
• Performed client on-site migration of Legacy court systems transactional data to SQL Server database environments with flawless conversion techniques. The work involved developing a detailed Data Conversion Document, Migration and Implementation techniques. Database configuration and DDL migration was performed through execution of application release scripts. Developed a framework for script execution in automated manner via SQLCMD.
• Developed a single-entry SQL Server database synchronization stored procedure for the clients’ database schema production releases to rename about 10000+ database views in hierarchical order for 42 Databases.
• Involved in daily Scrum project management process and helped with release planning, which comprised of establishing a line of communication between team members of different departments and the client.

ENVIRONMENT:

• WINDOWS 2008 R2
• SQL SERVER 2005/2008/R2/2012
• SSRS / SSIS 2008
• SQL CMD

Confidential

DATABASE ADMINISTRATOR

Responsibilities:

• Provided smooth Integration between the technical team and the Client by assuming the role of an Analyst, SME and Technical Lead as required during various steps of Software Development Life Cycle.
• Developed Oracle SQL Loader scripts to extract, transformed and loading (ETL) data into table.
• Performed Actuarial data conversions on various data products, working across functional teams through resolution including final review with Sales and Client Service teams. Also responsible for importing Client Data from Excel to SQL Server 2005 databases with the help of Macro/VBA.

ENVIRONMENT:

• WINDOWS 2008 R2
• Excel Macros - VBA
• ORACLE 9i, 10g
• SQL SERVER 2005,2008