Dominic Kumar Kumar

Work History

Work History

Senior Database Administrator

Infonovum Technology
Englewood, CO. Senior Database Administrator

Senior Database Administrator

Mahindra Satyam
Santa Clara, CA. Senior Database Administrator

Senior Database Administrator

MEDai
Senior Database Administrator

Senior Database Administrator

Safeguard Properties Inc
Cleveland, OH Senior Database Administrator

Senior Database Administrator Sme

SME-Oracle Real Application Clusters &
Senior Database Administrator, MXEnergy is one of the largest independently owned natural gas suppliers and electricity suppliers, serving CA, TX, OH, IL, IN, MI, PA, NY, MA, CT, NJ, FL and GA deregulated territories in the United States and Ontario and British Columbia in Canada. MXEnergy offers a variety of fixed and variable rate options and a customer care team. Managed 70+ Oracle 9i, 10g/11g on Windows, Solaris, HP-UX, UNIX and Red Hat/Oracle Linux Servers. Responsible for Design and Implementation of High Availability of Production Database(Oracle Fail Server, Oracle DataGuard and Oracle Real Application Cluster 3-Node) of Lodestar, Tibco, GIS and Siebel Database. Supervised the Upgrade project of Lodestar and Siebel Oracle Database from 10g(32-bit) to 11g(64-bit) which improved Customers Calls and huge number of billing with less time. Designed and implemented 5 2-Nodes RAC on Red Hat Enterprise Linux ES 4.0 for in-house built Oracle 10g Database. Used vmstat, ps, top, mpstat, sar, free, iostat, netstat tools to monitor and tune Linux/Solaris Servers. Used OSWatcher and OSWatcherGraph to monitor the performance of Linux/Solaris Servers for CPU and Disk usage analysis. Used webmin GUI tool to ease Administrative tasks for Linux/Solaris Servers. Used cron to schedule Database Alerts/batch jobs. Used ORION to test the performance of Disk I/O on SAN on Linux Servers. Used AWR, ADDM, Automatic SQL Tuning Advisor, TKProf and SQLTrace to resolve/tune performance issues. Tuned complex SQL Queries to improve the performance for billing and reporting purposes. Implemented daily monitoring jobs, automatic alert notification when database is down or preset thresholds have been exceeded, installation of new database upgrades, patches, create databases, primary database objects like table spaces, tables, views, synonyms, snapshots, partitioning and sizing tables, indexes etc. Implemented table partitioning to store year to date transactions which increased in performance during select operations. Performed tasks associated with tuning of database systems for performance and efficiency enhancements, reviewing the logs, available space

Senior Database Lead Sme

Weatherford Laboratories
Houston, TX Senior Database Lead(SME-Oracle DataGuard & SQL Server Replication), Weatherford Laboratories is engaged in all facets of rock and fluid analysis for the purpose of evaluating hydrocarbon resources around the world. Their services include core retrieval, analysis and management; geochemical assessments; unconventional reservoir evaluation; and, consulting and engineering services. Additionally, they have developed a wealth of proprietary instrumentation and software in the constant pursuit of more accurate data. With locations on six continents, Weatherford Laboratories provides laboratory services to every major oil and gas producer and is experienced in all play types, on and offshore. Participated in Design and Architecture meetings and proposed technical solutions to implement business continuity plan requirements Oracle and MS SQL Servers. Managed 40+ Oracle Real Application Clusters(RAC with ASM), 40+ MS SQL Server Clusters and 100+ Oracle and MS SQL Server instances. Designed and Implemented the SQL Server Replication and Oracle DataGuard Architecture across six continents. Deeply studied and researched the application, database and schemas for SQL Server replication and Oracle DataGuard. Used ER modeling tools such as Erwin to get an overview of the Database Schema. Used DBA Repository Database schemas to monitor all Instances and Reporting those using SQL Server Reporting Services. Designed 4-Node Oracle Real Application Cluster to improve performance of master inventory server and monitor them using Oracle Cluster Health Monitor tool. Prepared Documentation and tested Backup and Restoration of Oracle Database using RMAN. Prepared Maintenance schedules for Backups, System Optimization, performance and Tuning, and Database Integrity on Production Databases. Used PowerShell for SQL Server to monitor and reports. Daily support included Performance and Optimization of queries on Production databases. Provided Regular monitor of the system for bottlenecks(CPU, RAM, Disk IO and Networking) using various tools. Used TKProf, SQLTrace, STATSPACK and SQL profiler to optimize queries and enhance the performance of database server for fast retrieval of data for the application. Created and maintained user security according to SOX compliances. Responsible for monitoring day-to-day tasks of team members to maintain consistency, effective communication, and tasks completed on time, project related

Senior Database Administrator Sme

El Paso Corporation
Houston, TX Senior Database Administrator(SME-Oracle Dataguard), El Paso Corporation provides natural gas and related energy products in a safe, efficient, and dependable manner. El Paso's Pipeline Group is the nation's leading interstate natural gas pipeline franchise as measured not only by mileage, but more importantly, by access to key supply regions and major consuming markets as well as by unparalleled connectivity to those markets. We transport more than a quarter of the natural gas consumed in the country each day through our 42, 000 mile interstate natural gas pipeline system. Supervised and participated in the study of operations and procedures and recommend changes to improve methods, procedures, service levels, and operational efficiency. Develop a strong understanding of Application Architecture and Business Processes of Exploration and Production applications like Tobin Eland, GasMaster and Openwells. Managed and Administrated 150+ MS SQL Servers and Oracle Database Servers on Microsoft Windows and Red Hat Enterprise Linux. Served as Project Lead in Upgrading Tobin Eland Application from Oracle 9i to Oracle 10g. Led the Upgrade Project of eCalendar for Tobin Eland Application. Installed and maintained Patch levels on Oracle and SQL Servers for bug-free environments. Installed 100+ Oracle and SQL Server binaries on 100+ Server using Oracle's Response file and SQL Server's Unattended installation Scripts. Created standards and processes for installing, configuring, security compliance and monitoring Oracle and MS SQL Database Servers. Demonstrated continuous effort to improve operations, decrease turnaround times, streamline work processes, and work cooperatively and jointly to provide quality, seamless customer service. Performed SQL code reviews during key points of the SDLC and enforce compliance with SQL coding and data modeling standards. Worked with business units to understand application change requirements and goals and aid the development of scalable, available, and high performance schema changes in the databases. Lead the Disaster Recovery Drill(Oracle-Oracle DataGuard & MS SQL Server-Database Mirroring) to pre-test and prepare the DBA's, System Administrator, Network Administrators and Application during real disasters and performed accelerated risk assessment and related impact analysis, including the establishment of RTO/RPO. Upgraded single-node to Cluster(SQL Server 2008 R2), which decreased downtime and increased the performance of the

Senior Database Administrator[performance Focal Point

Shell Trading
Senior Database Administrator[Performance Focal Point-North America] (SME-Database Performance Tuning, RAC & DataGuard), Shell Trading, a part of Shell, explore, produce and trade a wide range of energy resources. Shell Trading supports the Shell businesses-Oil Products, Gas and Power and Chemicals, by trading natural gas, electrical power, crude oil, refined products, biofuels, chemical feedstocks, environmental products and freight. They also manage one of the world's largest fleets of Liquefied Natural Gas(LNG) carriers and oil tankers and provide maritime expertise to Shell companies and external customers. Participate in Design and Architecture meetings and proposed technical solutions to improve database performance for Oracle RAC(4-node) with ASM. Created and Analyzed Baseline Metrics or Certified(Benchmark) Baseline Metrics for Production(Important) and Development Servers using Load/Stress Testing using Hammerora/Swingbench Open Source Tools. The Pre-testing reduces any future load breaks which may cause due to Real-time Production Activities. Develop a strong understanding of Application Architecture and Business Processes of Trading. Supported OpenLink Endur Application, for purging the amended deals and tune objects to benefit Locked Statistics. Designed and Tuned SGA Parameters for OpenLink Endur, for cost analysis. Coordinate with Vendor during patch/bug releases and perform pre and post performance benchmarking. Conduct sessions with Technical team and Business team to bridge and rectify all pain-points pertaining to performance related issues. Diagnose and analyses Database and Application trace files for identifying the delay in the calls from Database and Applications. Prepare and execute performance and stress tests to determine the capabilities of the end-to-end Database and Applications under different load patterns conditions. Apply diagnostic tools-AWR, 10046 Trace files, OSWatcher, LTOM, SQLT, and Desktop Performance Counter to identify Database bottlenecks in code and/or hardware configuration. Prepare and present the performance tuning metrics to management every week. Design and implement Oracle Dataguard stagey using business RTO/RPO requirements. Monitor production database using AWR and custom snapshot history reports for performance tuning. Implement appropriate Oracle RAC database settings based on the results of performance

Education

Education
May 1998 - Apr 2002

Bachelor of Engineering, Computer Science

University of Madras

Skills

Skills

Oracle RAC

Data Modelling

Performance Tuning

Oracle

DataBase Performance

ITIL

Certifications

Certifications

Pro Tools Expert Post

Avid

Pro Tools Expert Music

Avid

Media Composer Certified Professional

Avid

Cisco Certified Network Professional (CCNP).

Cisco

Information Technology Infrastructure Library (ITIL)

Microsoft Certified Business Management Solutions Specialist – Microsoft Dynamics SL 6.5.

Microsoft

Microsoft Certified Systems Administrator (MCSA) + Messaging.

Microsoft

MCSE: Data Platform (SQL Server 2012)

Microsoft

MCSE: Business Intelligence (SQL Server 2012)

Microsoft

Oracle Certified Professional - Oracle 9i, 10g & 11g

Oracle

Oracle Certified Expert - Oracle 10g RAC

Oracle

Oracle Certified Expert - Performance Tuning

Oracle

Scrum Fundamentals Certified Credential