Objective:

Understanding the need of internal and external stakeholders to deliver solutions through my management and technical expertise in Database technologies in designing, administration, development, programming, architect and reporting background in the area of OLTP, ETL, OLAP, Big Data and NoSQL Applications in On-premises and Cloud technologies (Azure, AWS).

Summary:

•Over Nineteen years of experience Installing, Configuring and Maintaining SQL Server. Worked with versions 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019, 2022 on on-premise Physical, Virtual(VM) as well as Azure SQL Servers

•Extensive experience with designing logical and physical data model for VLDB using PowerDesigner/ Erwin(5+ years)

•Experience Creation and maintenance of databases, creating roles and managing user permissions, Backup and Restore activities, Resolving Deadlocks and optimizing complex queries and trouble-shooting problems.

•Extensive experience configuring and supporting advanced technologies like Clustering, Mirroring, Always On, replication and log shipping.

•Provided secondary level support to Oracle databases (9i/10g).

•Programming and performance tuning in PL/SQL, T-SQL. Created triggers, stored procedures, functions and packages.

•Wrote custom scripts and DTS/SSIS/SQL Data tools packages for ETL processes using ANSI SQL, T-SQL, VBScripts, VB.NET, and C #.

•Experience working with .net applications. Wrote scripts using PowerShell.

•Experience configuring various monitoring solutions such as Site-Scope, Orion and MOM

•Experience managing high volume OLTP databases in a high availability, 24 x 7 operating environment.

•Proficient creating, implementing, maintaining, assigning roles and security suites in IBM (DataStage), and MSBI suites-SSIS/SSRS/SSAS.

•Expert in creating reports using Business Objects and SSRS

•Follows Kimball groups design principles in dimensional modelling.

•Experience with Dimensional modelling ROLAP/MOLAP/HOLAP

•Involved in software life cycle analysis, development, planning and maintenance.

•Helped BI’s analyze data using Power Pivot and Power View.

•Integration of warehouse system from relational databases (Oracle/MSSQL/FoxPro, Ingres(Unix based), MySQL) SFTP(Secure file transfer), FTP and various web services

•Followed both waterfall methodology and Agile based approach during development process.

•Experience in complete life cycle development in data warehouse environments.

•Installation, configuring VMWare Esxi 5.5

•Experience with non-relational databases like MongoDB.

Education

MBA(Master of Business Administration), IT Management(WGU, Missouri)(Awarded Excellence award for Capstone Business project)

MS(Master in Sciences) Electrical/Computer Engineering (Saint Mary’s University, San Antonio TX)

P.G.D.C.A (Post Graduate Diploma in Advanced Computing)(India, Pune University)

BE(Bachelor in Engineering) in Instrumentation and Control Systems(India, Bombay University)

MongoDB university

Certifications and achievements

AWS

AWS SAA: AWS Solutions Architect Associate

https://www.certmetrics.com/amazon/public/badge.aspx?i=1&t=c&d=2020-05-09&ci=AWS01255181

CLF-C01: AWS Certified Cloud Practitioner

https://www.certmetrics.com/amazon/public/badge.aspx?i=9&t=c&d=2020-01-27&ci=AWS01255181

Microsoft

MCSA(Part-1): Transition your MCTS on SQL 2008 to MCSA: SQL 2012(70-457)

MCSA: Microsoft certified Solutions Associate SQL2008

MCTS: SQL Server 2008 Implementation and Maintenance (70-432)

MCTS: SQL Server 2008 Business Intelligence Development and Maintenance (70-448)

Microsoft Certified Technology Specialist (MCTS) Certified in MSSQL-2005(70-431)

Microsoft Certified Professional in Database design and implementation for SQL 2000(70-229).

Brainbench certified in SQL 2005 administration (Better than 89% candidates did).

Brainbench certified in SQL 2000 administration (Better than 92% candidates did).

MongoDB

M001:MongoDB Basics

http://university.mongodb.com/course_completion/4b0154f5-bae3-4f5f-9349-26caccf6

M101P:MongoDB for Developers http://university.mongodb.com/course_completion/8eda2409-797a-4d69-897c-464b3eb3

Technical Skills

1)Databases:

a)Relational: SQL Server 7.0,2000,2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019 MySQL, Microsoft Access, Oracle 7.3/8i, 9i, 10G

b)No-SQL: MongoDB

2)ETL Tools: SSIS, DataStage

3)Distributed computing: Big data, Hadoop(Horton works Data Platform), Ambari, Hive, Pig, Zookeeper, Sqoop, Zeppelin, Oozie, Tez, Scala(Spark), HBase

4)Reporting Tools: Business Objects, SSRS

5)Cloud Experience in AWS: Designing robust cloud architect using AWS services with VPC, EC2, ASG, ELB, CloudFormation, S3, CLI, Route53, Cloudwatch, IAM, Amazon RDS, DynamoDB, KMS, Organizations, EBS, EFS, Redshift, Cloud formation for using infrastructure as a code.

6)Components: RDS, Active X Controls, Com, ODBC

7)Languages: ASP, Visual Basics 4/5/6, VB.net, ASP.net, C#, WMI, SQL, T-SQL, PL/SQL, HTML, VB Script, Java Script, C, C++, Scala

8)Platforms: Windows NT/2000/2003, Windows Server 2003, 2008, 2012 DOS, UNIX, Red hat Linux, Ubuntu, CentOS Oracle VM virtual box, VMWare EsXi 5.5, Mongo shell

9)Third party Tools: PowerDesigner, Erwin, SQL Safe, Eclipse, Red gate products, SQLIO, Guardium, Qualis, MongoDB Compass, Atlas for MongoDB, Imperva, Solar winds, DPA(Database Performance Analyzer)

10)Free Tools & Scripts: Brent Ozar’s first responder kit. Ola Hallegrens scripts, SQL Sentry Plan Explorer

11)Repositories: TFS, Git.

Management Skills

Evaluating company performance through balance sheets

Project scheduling, resource allocation

Use of statistical tools for decision making

Leadership skills to get maximum out of team

Negotiation and conflict management in communication

Problem Solving

Presenting to stakeholders

Implementing technology strategies that include vision, standards and direction of technology in line with organizational strategy

Professional Background

Anthem

St. Louis, MO

Sr. (Lead) Database Administrator

Apr/17/2014 – Current

Anthem is the largest managed health care, for Profit Company in the Blue Cross Blue Shield Association. It has an annual revenue of more than $90 Billion with a global work force of 46000+ employees.

As a Sr. Database Administrator/Programmer, some of my responsibilities are:

Leads Database efforts across organization through project planning using management tools such as Gannt Chart, resource planning, communication with app owners, and business stakeholders.

Instrumental in budget planning, Capacity planning, managing licenses for servers, third party tools licensing and Vendor management for HealthLink SQL/ETL servers.

Worked with Business and IT partners to identify, prioritize and lead development and implementation process.

Worked with Anthem teams to install Imperva SecureSphere software, installing ciphers on SQL Servers for database governance.

Create, monitor alerts for SSIS, DataStage jobs, performance and maintenance of servers.

Migrated multiple SQL Server Servers/applications from SQL Server 2005 to SQL Server 2012/2014/SQL2016, 2019, 2022 on premise as well as Azure environment.

Configured HA/DR environment using Always On, Clustering, Log Shipping Replication as per the requirement and business needs.

Redesigned/Programmed packages from older DTS version to xml SSIS packages, while replacing Active X script tasks to VB.NET scripts as appropriate.

Migrated DataStage servers (ETL system) from 8.5 to 8.7, 11.5 and then 11.7.

Performance tracking and tuning servers. Monitoring, disk I/O, CPU, Network pressure.

Performance tuning SQL Queries, DataStage performance.

Handle production support tickets for SQL Server and ETL systems(SSIS, DataStage)

Created ETL system for our HealthLink Data Warehouse system. This system had feeds from AniTa (Unidata), Oracle, people soft system to SQL server data-warehouse system. ETL system was designed using DataStage as well as SSIS packages.

Install upgrade and apply patches to SQL Server as well as ETL systems for any vulnerabilities reported by Qualis scans (SQL Server, DataStage etc.)

Configure Servers for security management and principles as defined by Guardium scans and Microsoft/IBM best practices. Configure encryption at rest through TDE and in-flight encryptions through certificate installations in SQL Server.

Build health care reports (Claims (HMO, PPO, workers compensation, Payer), Providers) using business objects from Universes and Ad-hoc reports as requested by business partners.

Provide development support to programmers.

Performance tune/develop servers/data warehouse / reports as needed

Project plan changes in releases by going through release management meetings, change control, e-form, and tech. specs, SNOW and board approval process. Used Agile methodology

Designed various stored procedures, functions triggers and CTEs depending on requirements. Analyzed their execution and graphical plans for optimum performance.

Support Vendor application built around exchange of data between AWS and on-premise systems.

Manage various users’ roles/Groups permissions.

Go to guy for working with multiple teams in organization like Infrastructure, EDI team, AniTa team, programming team, working with business analysts, marketing and so on so forth.

Involved in data cleaning, conversion/ETL process keeping in mind corporate guidelines principles, standards and procedures to meet regulatory and compliance guidelines so that data could also be used for audit requirements.

Follows Agile principles, contributes with teams using Confluence and tracking of tickets through JIRA.

Worked with infrastructure in setting up SQL environments and application environments

Performance tuning using advanced concepts such as Query store

Southwest Power Pool

Little Rock, AK

Contractor

Feb/1/2014 – Apr/17/2014

Worked as a contractor for client a called Southwest Power Pool as a Senior Database Administrator.

Maintain security, assign permissions based on ticketing system

Designed various stored procedures, functions triggers and CTEs depending on requirements. Analyzed their execution and graphical plans for optimum performance.

Analyze servers with various counters to check for any I/O contention, cache hit ratio, network (packets sent/received), Server waits (Memory, locks, log), Sessions (deadlock, blocking), CPU (Processor queue length, Usage %), Databases transaction/sec etc.

Helped BI’s analyze data using Power Pivot 2013 and Power View 2012

24/7 on call support.

Installed service broker on each server to adhere security policies like failed login attempts, database changes, schema changes etc.

Documented and created charts, diagrams using word/excel, Visio for better tracking of current process, providing insight and knowledge transfer.

Managed permissions and security.

Created power shell scripts for multi-server administration and implementation.

Design packages in SSDT and SSIS.

Public Consulting Group (PCG)

Richmond, VA

IT Sr. Specialist (Dev./ETL/DBA)

Jan/1/2009-Jan/31/2014

Worked in multiple sectors including; education, health, human services, and public partnership projects as an IT Senior Specialist in designing, implementing and maintaining various database driven environments in PCG’s different domains.

Created cubes based on data mart and bus matrix.

Involved in setting up of clustering environment, Log shipping and Database Mirroring in various Production environments.

Manage almost 70 servers from Production, QA and Dev environments.

Installation, maintenance, and training of SQL server, SSIS, reporting servers (SSRS 2005/2008 /2008R2).

Set up Database/FTP/ETL jobs maintenance plans and Alerts.

Performance tuned database and queries.

Implement various security models in designing SSIS packages.

Manage various users’ roles/Groups permissions.

Building ad-hoc reports based on requests.

24/7 on call/Alert support.

Build and maintain T-SQL/PL-SQL, XML, XSL and XSLT scripts, indexes and complex queries to get higher performances and cater business requirements.

Designed reports using Flash and .Net technologies.

Deals with client both internal and external to PCG to offer technical expertise so that business can make most informed and educated decision.

Responsible for Integrating DB with multiple PCG products for periodic/instantaneous refresh of data between different relational/non-relational databases, files, web services etc.

Aid developers with performance management, database design and programming (T-SQL) principles.

Involved in data cleaning projects

Gathered requirements from business for OLAP architecture (i.e. defining KPI’s, Matrices, Goals, hierarchies, drill through etc.)

Dimensional modelled star schemas primarily architecture from relational databases and data warehouses.

Evaluation of hardware and software architecture.

Converted and designed packages for PPL, Ieponline, and Health care i.e. various practice areas for PCG.

Helped BI’s analyze data using Power Pivot 2013 and Power View 2012

Involved in data conversion

Followed agile methodology for development

Protect data at rest through TDE(Transparent Data encryption)

Migration of legacy system data

Used data analysis and data profiling in during requirement phase, ETL phase adhering to Kimball principles.

Monitoring regulatory and compliance guidelines in ETL processes(such as data retention and audit requirements)

Harmonizing, cleaning, preparing and using data for dataset development, reporting and analysis

Implementation of corporate policies, standards and procedures during upload process in warehouse and/or relational environments.

Xperts, Inc

Richmond VA

Sr. Database Administrator/ ETL developer

May/2007 to Jan/2009

Xperts, Inc. is fastest growing company in the region and is divided into two main components namely Consulting services and the product division, with primary focus on special education management software. Special education management systems consist of EP Online and Med Online. IEP Online concentrates on student and staff information and med Online takes away stress from Medicaid recovery process.

Primary responsibilities (But not limited to):

Train I.T team towards best software practices for database principles

Manage almost 40 servers from Production, QA and Dev environments.

Designed ETL packages (DTS, SSIS) to automate data transfer and map from various sources like DB2, Informix or Oracle (8i, 9i, 10G) SQL Server 2000, SQL Server 2005 to MSSQL Server 7.0, 2000 or 2005.

Installed, Configured and maintained SQL 2008 in Dev and QA

Build and maintain T-SQL/PL-SQL, XML, XSL and XSLT scripts, indexes and complex queries to get higher performances and cater business requirements.

Involved in setting up of clustering environment, Log shipping and Database Mirroring in various Production environments.

Performance tuned database and queries.

Strengthened up security against slammer attacks.

Migration from Oracle to SQL Server database

Installing configuring and managing Reporting services(SSRS)

Building reports based on client request.

Interacted with user community in order to analyze current business needs, and then design, document, develop and developed normalized tables, S.P, views, DTS packages to meet those needs.

Set up Database maintenance plans and Alerts.

Set up disaster recovery high availability environment.

Followed agile methodology for development

Involved in ‘Data conversion’ from different source systems to destination.

Vendor export files from SQL Server database

Managed many projects.

Migration of legacy system data.

Was involved in data cleaning/ETL process keeping in mind corporate guidelines principles, standards and procedures. This was done to meet regulatory and compliance guidelines so that data could also be used for audit requirements.

First Health Care Services

Richmond, VA

DBA/ ETL developer

10/2006 to 04/2007

First Health is a unique national managed health care company that offers comprehensive services to payers across the country—including all 50 states, the District of Columbia and Puerto Rico. Serving the group health, workers' compensation and state public program markets, and our core competency is managing total health care costs while educating and empowering consumers.

Responsibilities:

Provided support to 44 database Servers. Support included to Production, QA and development database servers. This included SQL servers on Active/Active and Active/Passive clusters.

Involved in migration from SQL 2000 to SQL 2005

Analyzed performance by running Profiler Trace analyzed the output.

Analyzed execution plans for queries and procedures and optimized the same.

Backed up databases and performed recovery as required.

Perform unit testing to validate mappings, debugged mappings for failed sessions and populate the target database

Created automated jobs as required and debugged root cause of failure in case they failed as part of daily routine.

Created automated failure Alerts process for reporting procedures utilizing MS SQL Mail.

Managed Security and created logins and roles and assigned appropriate permissions.

Resolve tickets to satisfy business and application needs.

Tested application compatibility with database and helped resolve issues.

Assisted in constructing Releases management processes.

Consolidated databases to improve efficiency of Servers.

Sprint PCS

Kansas city, KS

DBA/data warehouse engineer (10/2005 to 09/2006)

Provided support to an internal website used by engineers to get near-live operational measurement data of hardware devices. The Data is pulled by parsers which were written in .net and ran every half-hour. This data was stored in a relational database, converted to data mart and was reported using cubes in SSAS.

Created cubes using SSAS.

Maintenance and processing of cubes on nightly basis.

Provided support to 20 database Servers. Support included to Production, QA and development database servers. This included SQL servers on Active/Active and Active/Passive clusters.

Backed up databases and performed recovery as required.

Designed logical and physical data model for VLDB using Erwin

Installed and Configured SQL Server 2000 and 2005

Upgraded databases from SQL Server 2000 to SQL Server 2005

Worked with SSIS and analyzed new features.

Provided 24x7 support

Analyzed performance by running Profiler Trace and Perfmon and analyzed the output.

Analyzed execution plans for queries and procedures and optimized the same.

Configured Transactional replication.

Managed Security and created logins and roles and assigned appropriate permissions.

Analyzed index fragmentation and schedule rebuild of indexes.

Analyzed and Installed Security patches as required.

Provided support to Analysis services and troubleshooting ETL job failures.

Created and migrated data with DTS packages.

Troubleshooting in .net applications.

Generated ADHOC reports as requested on demand.

Provided User training and support.

Prithvi Power Engineers

Noida, India

SQL Server Developer/DBA/Engineer (12/2000 - 07/2002)

Provided support to Development, QA and Production Servers

Worked on SQL Server migrations from SQL Server 7.0 to SQL Server 2000 on standalone machines and in clustered environment.

Worked on DTS, OLAP. SQL Mail installation, configuration and testing.

Installed and configured SQL Server 7.0/2000 in cluster environment.

Used Windows NT performance monitor and SQL Profiler to troubleshoot performance.

Designed tables and tuned indexes for effective retrieval of data

Developed T-SQL scripts for database backups, new logins/users, index distribution, customized maintenance jobs using stored procedures and triggers.

Importing and exporting data using DTS and BCP.

Migrating Access databases to SQL Server 2000.

Installation of H/W and interfacing with computers using RS-232 I/O chip

Contact this candidate