SUMMARY

• A MCSA SQL Server/ Oracle/ DB2/ SAP HANA DBA with over all 11+ years of extensive experience in SQL Server & Oracle, 6+ years’ experience in DB2, SAP & IMS Relational Database Management Systems. Hands - on expertise in establishing Database standards, recommending tactical technology solutions, providing technical support, conducting database strategic planning and providing extensive Database management and administration support at all project levels.
• Successfully supported millions of end users in about 150 databases in both SQL Server, Oracle and SAP platforms in Linux, UNIX, Windows and Azure servers.
• Installed, administered and managed databases in various shared services projects on RDBMS (DB2/ IBM Database, Oracle and MS SQL Server) and Hierarchical DBMS platforms in Windows, Linux/Unix, and IBM Operating Systems.
• Provided a 24/7 remote third-party support using Oracle Grid Control to plan database security strategy, up grading databases as required and implemented daily back-up and recovery as needed.
• Experience in senior level team leadership skills.

TECHNICAL SKILLS

• SQL Server Configuration Mgr., SQL Server AlwaysON tech, SQL*Plus, Oracle Enterprise Manager, Idera Precise/ Diagnostic Manager, Dynatrace App. Monitor, Oracle Grid Control, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SSIS, SSAS, SQL Developer, SQL Loader, SQL Tool, Oracle Recovery Manager(RMAN), Automated Workload Repository (AWR), Scheduler, Data Pump, Real Application Clusters (RAC), Partitioning, Active Data Guard, Unix Shell Scripting, Automatic Storage Management (ASM), Data Archiving, Putty, Cygwin, TOAD, Apache Hadoop, Secure CRT, Enterprise Reporting with Oracle Reports. DevOps, JIIRA, Bit Bucket, DB Maestro/Jenkins for environment development, management and database change tracking.
• HP OpenVMS System Software: High Availability, security administration, scalability, flexibility responses to changing business demands.

PROFESSIONAL EXPERIENCE

Senior SQL Server/ Oracle DBA

Confidential, Andover, MA

Responsibilities:

• Supported millions of end users in about 150 databases in Oracle, SQL Server and SAP HANA platforms in UNIX, Linux, Windows and Azure servers.
• Responsible for all SQL server version installations, failover clusters, performance tuning, backup and restore, and routine server maintenance.
• Used SQL to retrieve data/ interface with a relational database (SQL database).
• Used SSRS a SQL Server component, to design and render nice reports from SQL Server database.
• Used SQL Server Analysis Services (SSAS), Business Intelligence stack, to develop Online Analytical Processing (OLAP) solutions.
• Created cubes using data from data marts / data warehouse for deeper and faster data analysis and used Apache Hadoop for data processing.
• Used SQL server Integration Services (SSIS) for ETL for integration tasks, copied flat files with a file system task and then imported into a table using a data flow task.
• Responsible for high level database configuration and installation as well as Oracle/ SQL Server database migration on Amazon Web Services (AWS).
• Involved in Schema, Database backup, restore and refresh in SSMS as well as performance tuning in all SQL server platforms.
• Worked on a shared Services program servicing over 85 Government Agencies and Financial organizations databases on SQL Server/Oracle/DB2 platforms, using effective tools (DB Maestro, Enterprise Manager, Bit Bucket, Jenkins and DevOps.
• Wrote simple and advanced PL/SQL scripts, Data Definition Language (DDL Statements) used to create triggers, create and replace objects in a schema, to create backups, for cron and scheduling automated jobs, to update tables and reviewing scripts from developers.
• Provided configuration management and database administration expertise across the Advantage ERP, including all products and releases as well as planning and implementing all level of Oracle E Business Suites applications.
• Involved in database security, the release and completion of various projects while managing about a team of 16 database administrators administering and managing about 32 database administrators in both the US and Indian hub
• Responsible for installing, administering and managing databases in various shared services projects on RDBMS (DB2/ IBM Database 2, Oracle and SQL) and Hierarchical DBMS platforms in Windows, Linux/Unix, IBM Operating Systems.
• Involved in database refresh/ restore, creating and administering new databases, providing advises on database problems resolution directly to clients.
• Supported various applications like SIEBEL, One Gate, OBIEE, Life-ray, Web Logic, Web Servers and directories.
• Designed and developed documents (database design document, database management plan), which were presented to the state as a blueprint for the VT HBE project.

SQL / Server- Sr. Operations/Infra DBA

Confidential, OH

Responsibilities:

• Worked as the Sr. Operations & Infrastructure DBA on Assurecare MedCompass software, a case management & Utilization Management Software which is an outcome-driven solution that allows health organizations improve patient experience and quality of care as well as reduce costs to achieve the Triple Aim, while also enhancing the work life of healthcare providers.
• Worked as a Sr. Operations/Infrastructure DBA with the development/QA/Testing team on Load tests in Training & breakfix environments preceding production, monitoring and diagnosing, using tools like IDERA Precise, Diagnostic manager, cacti, to ensure successful user count testing and maximum performance is achieved before production.
• Managed large pool of SQL server instances, by being responsible for all round maintenance, performance tuning, security access and all high-level SQL environment tasks in Non-production (BreakFix, Training, Stress and UAT) and production environments.
• Responsible for Index rebuild, reorganizing, updating statistics, database integrity, data and log files management.

SQL / Oracle Server DBA

Confidential

Responsibilities:

• Responsible for creating, maintaining and administering SQL Server databases, using command line and SSMS Installed and Configured Oracle Enterprise Red Hat Linux operating system versions and Windows 2008 servers for Oracle Relational (RDB).
• Wrote and developed PL/SQL scripts, Data Definition Language (DDL Statements), for database maintenance and management purposes.
• Performed application installation, space estimation, performance/memory tuning, 24/7 server/database monitoring, configuration and troubleshooting.
• Involved in creation of triggers, create and replace objects in a schema, to create backups, for cron and scheduling automated jobs, to update tables.
• Set up new databases and provided all database related support for the production environment as well as provided consultancy services as needed to other organizations.
• Led a project with a team of 5 and successfully analyzed, recommended and implemented an active Oracle Data Guard for United Health groups and Wal-Mart in Georgia to improve Oracle data protection, data availability and disaster recovery to enable easier monitoring and management system.
• Diagnosed the installed database with improved Oracle 11g packages as well as resolved connectivity issues.
• Provided a 24/7 remote third-party support to RachReub IT solutions, using Oracle Grid Control to plan database security strategy, up grading databases as required and implementing daily back-up and recovery as needed.
• Installed Oracle software, planning the database & security strategy, enrolling system users and planning for their Oracle Network access.
• Performed Multidimensional Databases (MDB) installation and creation, installing Oracle grid infrastructures & Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company.
• Coordinated and provided security architectural design and implementation, database security, the release and completion of various projects while managing about a team of 16 database administrators.
• Carried out Oracle Database maintenance; base lining, performance tuning, alert configuration, using snap shots taking by Automated Workload Repository (AWR) / Automatic Database Diagnostic Monitor (ADDM) to generate performance reports.
• Monitored database performance, securing & protected information/database with unique secure configurations, data encryption and made procedures as well as with sophisticated auditing skills.
• Responsible for presenting and analyzing database performance reports and improvement recommendations to client company’s senior executives.
• Ensured fast and secure access to business applications round the clock and working with business analysts to bring databases to the intended standard of the projects.
• Implemented, administrated, and maintained daily backup and archived data on tape.
• Created user accounts & system/user-level database objects managed user privileges.