Nathan T Dhital
Easton, PA ****2
To pursue a challenging career as database administration and Developer or cloud solution architecture in a dynamic organization in information technology by making a long-term contribution to the organization successfully through consistent hard work, sincerity and dedication
22+ years of IT Experienced Oracle Certified Professional with 8 + years of progressive experience in Oracle Database design administration and management of large databases and data warehouse environments (up to half Petabyte size) providing 24/7 support of both development and production 12c/11g/10g databases on Various on Unix, Linux and Windows based Platforms.
Skilled in the design of complex Oracle database architecture based on standalone, clustered and virtualized implementations. Experienced in designing, migrating, operation of Oracle cloud and Amazon database services.
Adept in performance analysis of database servers and storages standalone and clustered environment. Capacity Management competences and proven experiences developing capacity management plans for standalone and clustered configurations.
Skilled in evaluation of current infrastructure and recommend solutions for improvement.
Experienced in data mapping activities, automate data conversation, database migration and data cleansing.
Expert in data modeling using tools ER design and Oracle SQL developer; writing Unix, SQl and PL/SQL scripts.
Planned and implemented DR & high availability solutions using OEL 11g Standby Database using Oracle Data Guard, 11g/12c RAC. Hands-on experience in Oracle DBA cloud.
Expertise with 13c Oracle Enterprise Manager, 12C Grid Control, RMAN, Schema & User management
Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Performance Tuning, capacity planning, UNIX shell and SQL script development, writing PL/SQL packages and documentation.
Experienced in DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
Excellent experience in OLAP and OLTP database systems, implementing and managing large Oracle databases up to half Petabytes size
Experience in working with oracle Golden Gate and replication technology
Experienced in database design, data modeling and multidimensional data modeling; extraction transformation and load (ETL) and data warehouse technology.
Have supported SQL Server (2001, 2005, 200, 2012, 1014) DBA work.
Highly dedicated professional with demonstrated success in designing and implementing database solutions that improve business functionality. Trained and experienced in Project Management and ITIL
Possess diversified technical background programming skill sets with in depth understanding of enterprise system and focus on delivering business solutions. Proficient in PL/SQL language and Unix and Linux cell scripts.
Experienced in database hardening, protection from SQL injection, protection from backlogs and other vulnerabilities. Performed validation of configuration compliance, data hardening and auditing and other securities measures proactively.
High ability to organize and manage time to meet immediate and long-term deadline with a positive attitude to increase productivity. Hands-on project management experience.
Comprehensive problem-solving abilities, commitment towards work, willingness to learn, and strong grasping abilities and detailed oriented.
Strong communication and interpersonal skills with ability to deal with diverse staff and clientele
Ability to build strong trusted working relationships with internal and external business customers, vendors and executive level management; influencing without authority and managing stakeholders/clients’ expectations.
Excellent formal education from US Universities (Two relevant Masters Degrees) and abroad (Engineering degree). A former Fulbright Grantee. Proven desire and commitment to continually learn and apply new technologies.
Database Administration: Oracle 10g/11g/12c, SQL Server 2000-2014, Sybase, Access 97-2005, DB2, Teradata
Platforms: UNIX, Solaris, Linux, AIX, Windows 2003-Server 2012, HP-UX, AIX
High-Availability: Real Application Clusters (RAC) 11g/12c, Data Guard, RMAN, HP Service Guard, VERITAS Cluster Server, Oracle Failsafe
Enterprise Database Tools: BMC, Oracle Designer, CA Erwin, OEM/EM Grid Control (Enterprise Manager), Toad & Quest, Oracle Warehouse Builder (OWB), SQL developer
Application Servers: OAS 4.X.X, 9iAS, OAS 10g, Weblogic 8/9 Apache/Tomcat, IIS
Application Systems: Oracle Applications 10.7-12R, Siebel
Programming: PL/SQL, Unix and Linux scripts, DevOps, Cloud, SAS, VB, Java/J2EE, SQL, C++, Java Script, HTML, PHP, Perl
Other: Erwin, oracle SQl developer, ITIL, PMP, BMC, Golden Gate, Transportable Tablespace (TTS), SPARC SuperCluster, ER Studio, Project Management, Business and System Analysis, ETL, Data Integration, Data Modeling, Data Architecture Design, Data Warehouse, OLTP and OLAP, Apache 1.3, Advanced Replication, Oracle Streams, Oracle financial application systems (GL, AR, AP, HR), Oracle CRM, TCA, UWQ, Forms, Report Writer, MS Project 2000/2002, ERP systems, SDLC, EDI, MS Office Suite (Word, Excel, PowerPoint, Outlook, Visio), ODBC, ftp, Microsoft Internet Explorer, Netscape and Opera Internet browsers, ISO 900 Toolkit, Statistical and Econometric Analysis, AWS, Oracle cloud
Lehigh Valley Hospital, Allentown, PA Role: Sr Oracle DBA/Developer 03/2016- 08/2018
Coordinated in Building an Oracle data warehouse repository by migrating database from SQL Server, Oracle Servers using Golden Gate and Oracle SQL Developer 4.1 for their Information Technology Department.
Designed and modeled of databases using ERWIN tools in OLAP and OLTP environment.
Upgraded Oracle GoldenGate from 11gR2 to 12c. Implement OGG 12c new features in mission-critical production environments.
Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc.
Response for Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments from MS SQL Server and IBM DB2 to Oracle 12c.
Monitored and fully analyzed performance issues in production Oracle databases by using AWR/ADDM/OEM 12c
Involved in Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.
Handled the Backup and Recovery using RMAN, Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
Perform tuning, maintenance and support of Linux 11gr2/12c RAC
Performed Logical backup using and full/partial export/import and Data Pump.
Applied patches which includes CPU as well as PSU patches and used lot of techniques to reduce the patching downtime
Implemented Goldengate bidirectional setup between different data centers.
Responsible for capacity planning, database security, recovery planning and installing patches
Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files. Coordinated with .Net programmers and SQL Server developers to design the flow of operations to ensure proper synchronization between the database and the front end in both connected and disconnected modes.
Performed Backup and Recovery tasks in SQL server 2005 using SQL server Management Studio.
Responsible for providing application development support for Query Optimization, Stored Procedures, Triggers, Indexes etc. for multiple development initiatives.
Performed SQL Server dba role as deemed to be necessary.
Implemented and maintained database security (creates and maintains users, roles and Assign privileges.
Managed data warehouse projects improvement and growths.
Performance monitoring, Alert Log monitoring and backup monitoring.
Created tools and processes to automate jobs and monitor database performance (Shell Scripts)
24 X 7 Production database administrations, Support to Developers, End-Users.
Experience in Infrastructure design, development and operations involving AWS Cloud platforms, EC2, EBS, S3, VPC, RDS, SQS, ELB, Autoscaling, CloudFront, CloudFormation, ElacticCache, CloudWatch, SNS, AWS Import / Export
Environment: Oracle12.1c, DB2, OEM 13c Cloud control, RMAN, SQL*Plus, PL/SQL, Golden gate 11g/12c, Shell scripting, Weblogic Server 11g, Microsoft SQL Server 2005-14, RHE 6, UNIX, SQL*LOADER, Oracle OEM, Putty, Data guard, Oracle Data Integrator, AWS, Oracle Cloud.
Walmart, Bentonville, Arkansas Role: Oracle DBA/Developer 02/2015-2/2016
Design and build complex relational databases and data warehouses.
Worked with technical and end users to understand business requirements and identify data solutions
Educate and provide Develop strategies for data acquisitions, data recovery and enterprise level database
methodology consulting to client and staff of the organization.
Handled responsibilities of providing guidance and mentoring to less experienced personnel.
Provided and implement performance tuning recommendations of all components in Exadata database machine.
Involved in advising and providing guidance and development Disaster Recovery strategies for the Exadata Database machine.
Configured Exadata to meet company internal security requirement.
Analyzed and determined the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
Developed and recorded certified processes/procedures for all potential IT downstream support groups to maintain and upgrade the Exadata database machine.
Integrated of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions
Designed, migrated and operated databases in Oracle cloud and AWS Redshift and EC2
Environments: 11gr2 8 nodes, ASM Exadata, Oracle X2/X3/X4 full rack Exadata machine, DevOps, Oracle 12c.1, OEM 13c Cloud control, Golden Gate, Erwin 10, OEL 6.x, SQL Developer 4.1, AWS, Oracle Cloud
UTC Aero Space Systems, Charlotte, NC Role: IT Database Administrator 08/2014- 12/2014
Played an integral role in developing data consolidation of 5 different companies merger databases.
Designed, developed and performed DB2 and SQL Server databases to oracle 11gr2 using SQL developer.
Goodrich Corporation has been changed to UTC Aerospace Systems because it is bought by the later.
I am working general IT application database administration functions where I handle data modeling, normalization, table structure, indexes, data types, naming conventions, triggers, stored procedures, views, functions, code generation, data import/export, archiving, purging, auditing and performance tuning of Oracle and SQL server databases.
Environments: Oracle (9i-11g), RA, Data Guard, BMC, SLA, SQL Servers
Wellsfargo, East Coast HQ, Charlotte, NC Role: Oracle DBA 08/2013 – 3/2014
Working closely with Database Administrators, Database Team, Applications Team, IT Architect and other DBA’s to monitor and troubleshoot the production issues and facilitate business improvements. Consulted with and advised senior management and multiple clients on high impact data or database management issues, influencing strategic direction.
Work simultaneously with other departments, BMC team and/or outside contractors to resolve system production problems. Also involved in working with Storage Architects and relevant team.
Perform other duties as assigned.
Develop high level DB Performance Reports with Recommendations for future RAC Capacity Planning works. Worked on all document process, related to all regular DBA activities.
Assisted in Database backups, restores and configurations to support testing exercises.
Involved in writing many Unix and SQLScripts and processes to quickly resolve issues in any Oracle database instance.
Assisting development groups with database administration in non-production environments
Responded to production support calls.
Environments: Oracle 11g R2 Rac, OEM 12c, Data Guard, ASM, BMC, SLA, 12C, Grid Control, Sun Solaris, RedHat Linux 6.x and Window 2008 Servers, Oracle Support/Metalink, Toad, SQL Developer, Oracle Clients/Servers.
Caterpillar, Peoria, IL ---Role: Oracle DBA 10/2012 - 04/2013
Responsible in providing Level 2 and Level 3 support of 300+ Production Oracle databases (most of them are RAC and Data-Guard environments) with on-call production support on rotation basis in 24/7environment.
User management, Space Management, Undo Management, Database Monitoring, Listener monitoring, Backup (RMAN) Management, Blocking session, database tuning, SQL tuning
Collection of StatsPack (8i & 11g) and AWR (11g) report
Led the planning, analysis, design, implementation, maintenance, and control of the organization's server-class databases.
Provide customer production and developer support
Support medium scale production database applications on multiple operating systems
Troubleshooting oracle errors and providing support to customers and developers.
Apply patches for oracle databases; Management of Physical Standby database using oracle Data Guard.
Recovery of production databases at the crisis situation in time.
Administration of Backup and Recovery using RMAN.
Management of backup pieces and backup sets using RMAN.
Writing Shell Scripts on various UNIX, AIX, HP-UX and Linux Servers for automation of day to day database jobs like Start up – Shutdown, Export Backups as per necessary.
Alert log monitoring of Oracle Database.
Managing Users: creating users, synonyms, privileges, roles, quotas
Managing table spaces, objects, profiles, storage parameters.
Work on BMC remedy and incident tickets and update / resolve the tickets within the SLA.
Involved in working with TSM and Storage architects and Network professionals in relevant
issues and change management.
Environments: Oracle (9i-11g), RAC, Data Guard, ASM, BMC, SLA, Grid Control, Aix, HP-UX, Linux and Window 2008 Servers, Putty, Autosys, Golden Gate, WinCp, Toad, Grid Control, TSM, RMAN, Oracle Support.
Tampa, Florida 12/2007 – 5/2012
Client- GE Cincinnati, Ohio and worked as DBA support role 08/2010 - 05/2012
Created Multi-Dimensional data model (STAR Schema) and enhanced it to meet the growing requirements.
Captured business requirements identification, analysis and development. Provided mentoring, guidance and general oversight to less experienced staff in a variety of database design, administration and/or modeling
Experienced in deploying robust applications leveraging solutions from Oracle Enterprise Manager Grid Control, Oracle RAC, ASM, Oracle replication, Oracle standby/data guard, backup, restore and recovery operations usage of RMAN metadata, test planning, data integration/extraction transformation and load (ETL), application upgrades and data migrations
Experienced in performance tuning information systems running online transaction processing (OLTP), online analytical processing (OLAP), decision support systems (DSS) applications and implementing Oracle advanced security solutions on heterogeneous network environments
Responsible for providing expert level tier three 24/7 O&M Enterprise System Life Cycle Management Support (ELMS), security systems in GE Aviation Systems, a relevancy search and discovery software in development, test, pre-production and production.
Experienced in documenting/designing system/subsystem specification (SSS) documents
Overall, experience has been gained using Oracle Relational Database Management System (RDBMS), client-server applications, and web-based products in simple and complex High Availability (HA)/Maximum Availability (MAA) network architectural systems on UNIX, LINUX and Windows platforms.
Responsible for designing highly complex logical and/or physical databases; leading highly complex data modeling, mapping, integration, and capacity planning efforts; developing management policies, procedures and standards
Troubleshooter of Database Performance Tuning issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
Created Partitioned tables using Range, hash, list partitioning to improve performance and manageability. Writing scripts for backup and recovery, Import and export procedure.
Handled the databases in designing, developing and implementing enterprise level database systems. Some oracle databases were spatial and graph format.
Environments: UNIX, Linux Servers, Oracle Express, Informatica, Erwin, Business Intelligence, Teradata, Powerbroker, Windows Servers 2008, Oracle 11g/10g, 11i-12R, CA Erwin, Informix, DataPump, Toad,, Autosys, Golden Gate
Client - ADP Total Source, California, Role - Oracle DBA 10/2009 - 03/2010
Installed and configured oracle 9i and 10g, 11g database on Dev/Test/Prod system.
Day to day monitoring like availability of system, listener, database, alter log file, trace file. Developed UNIX shell script to monitor database.
Performed Daily Monitoring of Oracle instances using OEM Grid Control, TOAD to monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
Created Partitioned tables using Range, hash, list partitioning to improve performance and manageability.
Provided disaster recovery by configuring and maintaining physical standby database using oracle Data Guard.
Worked on database cloning to make Production instance available for Test and Development.
Created users and involved in database security by granting roles, privileges, and profile to users.
Created database object like tables, indexes, views, synonyms, sequences.
Developed PL\SQL stored procedure, package, triggers, cursors, and views.
Performed, developed and maintained database backup and recovery using RMAN.
Performed logical backup of database, schemas, tables using Export/Import and DATA PUMP utility.
Analyzed database object tables, indexes to get statistics.
Worked closely with Development DBA teams on trouble-shooting SQL issues impacting database performance and uptime.
A six member DBA team providing support for 10 oracle instances with database sizes for 100 GB to 5 TB.
A 4 member of Oracle DBA team and oracle database size was 100 GB to 5 TB
Environments: Linux Server, Autosys, Crontab, Unix, Oracle 10g r2/11g r2, ASM, RAC, Golden gate, Exadata, Windows Server 2003, Sybase, Dashboards, Toad, SQL Developer.
Client - WalMart, Arkansas, Role - Oracle DBA 01/2009 - 08/2009
Database capacity Planning and Volumetric Analysis for the database more than 0.5 PB. Involved in the Implementation of Data Guard and RAC technologies in mission critical systems and configured Switch over and Failovers with Physical standby database on UNIX environments.
Upgrade/Migration databases from Oracle 9i to Oracle 10g
Installation, Configuration and Administration of Oracle 10g RAC
Configured the Public Network/Private Interconnect for Oracle 10g RAC
Converted a single instance database to Oracle 10g RAC.
Installing ASM environment and migrating database from NON-ASM to ASM.
Setting up and testing the backup and recovery strategies.
A 10 member of oracle DBA team database size was half petabytes (500 Terabytes) with 100 test data instances and 15 production instances.
Environments: Data Guard, OEM, Oracle 10g r2, RAC, non-ASM and ASM, AIX, Linux Servers
Client - Syniverse, Tampa, Florida, Role - Oracle DBA from 06/2008- 12/2008
Fulfill customer service requests for SQL and database tuning, software patches and upgrades, as well as database migration and duplication. Major projects include migrations to upgrade Oracle 9i database to Oracle 10g and hardware and software testing.
Responsible to trouble shooting requests for Oracle bugs, suggestion as an expert development and implementation of backup/recovery strategies, configuring replication environments, as well as database process automation.
Proactively monitor 10g Oracle environments for multiple customers. Resolve database incidents to ensure database availability and stability.
A 5 member of oracle DBA team with database size 50 gb to 450 gb and 30 test and development databases and 10 production instances.
Performed disaster recovery for a production database which went offline after the server was moved to a new Sun box. Recovered a testing server after accidentally deleting all its syslogins entries including sa login
Environments: Crontab, Oracle 10g, AIX, HP-UX, Window Server 2003, Solaris, Export-Import Utilities, Putty, PHP
Client - Voice Power Systems, Tampa, FL Role: DBA 12/2007-05/2008
Coordinated Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning for SQL
Perform security updates for all user types
Responsible in Transitioning from SQL 2000 to SQL 2005. Develop plans and manage and execute complex technical efforts
Perform DTS packages, Perform Link Servers and work with T-SQL, write Stored Procedures, perform Database storage migration
Develop Documentation for all Databases by understanding of complex logical to physical DB structures
The Nielsen Company, Tampa Bay, FL 02/2006- 12/ 2007
Responsible for critical ETL processing operation during peak periods, data structures covered customer record files for entire United States' television rating sampling data.
Data modeling of new instances with both Erwin as logical tools.
Directly supported operation/development of ETL interfaces for background processes from Sybase and SQL Server Databases
Evaluated and resolved issues in three critical production applications including multi-tier fat client DCOM application back-ended by Oracle, metadata-driven, multi-tier Extract Transform and Load (ETL) data warehousing application.
Provide systems integration and architecture leadership oversight to find and close the gaps between various projects in term of common system development processes, configuration management, release management, and the application of IT best practices in the domain of Data Architecture, Business Intelligence, Data Quality, Metadata, and ETL
Prepared and processed documents and metadata file attributes and mappings for legacy migration to Document application
Coordinated IT Infrastructure service delivery management and support contracts
Environments: ETL tools, UNIX, Oracle 9i/10g, RMAN, IBM mainframe, Windows Servers, HP-UX, Putty, Ignite Tuning tools, Sybase, DB2, Perl, Erwin
Hi-Tek Systems Private Limited
Manhattan, New York 08/2003- 12/2005
Client - Special Data Processing Corporation (SDP), Clearwater, FL 10/2003 to 12/2005
SDP is a leader in Magazine Clearing House, sponsoring various sweepstakes and tracking calls from the potential customers and processing their information using state of the art of technology.
Design, model, and implement logical and physical database modifications using ERwin. Tune and optimize SQL and database objects.
Client - CrossRoad Technology, New York City, New York 11/2001-08/2003
Installation, configuration and maintenance of all Oracle 9i and Oracle 9ia Servers in development environments.
Coordinated for all java, ejb, j2ee development for the Sun Microsystems (local office) account. Installation, maintenance, development, test, quality-assurance, necessary training of the 3-tier systems using Java technology.
Involved from the development and system point of view in the architecture of BEA Weblogic integration adapter for Oracle 8i/9i application in UNIX, edit and figurate the UNIX script to add jar files, in the Weblogic Production environments for Web Logic Server 6.x through 8.0.
Performancebase.com, Manhattan, NY
Project Manager/Permanent Employee 5/2000 - 8/2001
Led a team of 45 employees for website creation that included production timetable, cost control and project
Coordination. Maintained documentation for a possible clients’ requirements
Conducted one on one session with the clients to assess client needs and expectations and ensure project delivery within deadline.
Responsible for status reporting, client communication & coordinating with the project management team for timely completion and quality maintenance of projects
Implemented new production methodologies that resulted in optimizing employee’s time to finish the tasks, thus enhancing employee efficiency
Responsible for streamlining work processes in various teams that include quality control, human resource, communication management and design
Contributing to company’s growth by means of business development, Client retention and securing strategic partnerships
Interacted directly with CEO, project managers, VPS, developers for the relevant technical issues of this Human Resource Management Portal development company.
Masters in Quantitative Methods
Concentration: Quantative and Management
University of Nebraska at Lincoln, 1993
Lincoln, Nebraska, USA;
Worked as Teaching assistant and Instructor
Masters in Information Systems
University of Nebraska at Omaha, 1989
Omaha, Nebraska, USA;
Worked in International Telecommunication center as database Scientist
Bachelor of Science in Engineering
National Institute of Technology (NIT), 1980
2013: Kenexa Prove It! Oracle 11g and UNIX Shell Programming Tests – Passed with 78% Score.
2009: Oracle Database 10g Administrator Certified Professional (OCP)
2009: CompTIA Linux+