Sql Server Oracle

Dodji K. Gomez

***** ******* ******

Germantown, MD 20874

TEL: 301-***-****

**********@*****.***

OBJECTIVE

Experienced Oracle Database Administrator (DBA) with in depth knowledge seeking an opportunity to support and contribute with my skills to the organization success.

U.S Citizen

PROFESSIONAL SUMMARY

Support Operations and Monitoring by working with different teams on an agreed upon Continuous monitoring solution which include: AWS CloudWatch implementation on instances, AWS CloudTrail logging, ELB Access logging, S3 logging and aggregation, SIEM solution for extended monitoring, Log correlation and event monitoring solution, architecting a solution for Penetration/Scanning Testing and Monitoring, Intrusion detection required to meet security controls, Encrypted storage solutions.

Broad expert-level database technical knowledge and skills on RDBMS engine like Oracle, MS SQL Server and Open Source (MySQL and Postgress) databases; expertise in offering database technical evaluation and recommendation on database design and architecture, integration and development, database high availability solution, database replication architecture, database backup, disaster and recovery strategies, grid computing and cloud management, database monitoring and management, performance tuning, database audit and security compliance and daily database operation and maintenance.

Amazon Cloud Administrator consultant. Design and Provision both Open Source RDBMS (Postgress and MySQL) and Oracle RDS on Amazon public cloud for top financial institution.

Strong experience in supporting Production, Planning, Reporting, QA, Development, Unit Test, System Test, Integration test, Certification Test databases under almost all flavors of UNIX (Oracle Enterprise Linux, Red Hat, Sun Solaris, AIX).

Specialized in Oracle Databases Versions (12c, 11gR2, 10g, 9i), Oracle RAC Versions (12c,11gR2,10g), Enterprise Manager 12c, OEM 12c, GoldenGate.

Experienced in Performance Tuning such as tuning of application, shared pool, buffer cache, I/O distribution, rollback segments, and redo mechanisms.

Experience is data encryption using Oracle TDE tools to protect our client’s PII and to adhere to the industry standard.

Specialized in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN)

Strong knowledge in Migrating Oracle 10g to 11g (RMAN, DATAPUMP).

Strong technical and analytical skills with excellent interpersonal and communications abilities.

Exposure in database administration with complete understanding of oracle architecture

Performing schema refreshes from prod to non-prod environments using full RMAN restore, DataPump and network import.

Resolving connectivity and trace issues as it relates to Listener, LDAP and TNS resolution issues.

Displays a high level of energy, integrity and ethics with the exceptional ability to deliver outstanding results within stipulated deadlines.

Experienced in 24 * 7 environments including on call support and supported over 20 developers in environment with over 200 databases.

PROFESSIONAL EXPERIENCE

Capital One Bank 9/2014-Present

Database Administrator, Principal Associate SME (DevOps, Open Source)

Responsibilities:

Amazon AWS experience including EC2, S3, Glacier, Route53, VPC, EBS, networking with VPCs, computing with EC2, storage with S3, Elastic Load Balancing, RDS for databases, monitoring with CloudWatch, CloudTrail, and access management with IAM, and Security Groups

Provide both onsite and on call Tier 2 and Tier 3 support for over 200 instances on both several RDBMS engines like Oracle and NOSQL engines and multiple platforms like AIX, HP-UX, Red-Hat, EC2, Solaris and Oracle Linux.

Design and configure databases across different environment to include Development, QA, Staging and production environments in physical, virtual servers, public and private cloud environment (AWS).

Provided Database administration, management and schema design for MySQL, PostgreSQL.

Updated earlier releases of PostgreSQL to version 9.6.1 on 6 servers running Fedora Core 7.

Designed, developed and maintained PostgreSQL database architecture.

Assisted in designing and management of PostgreSQL database schemas and tables.

Experience with Ora2pg, a tool for migrating databases from Oracle to PostgreSQL

Design and deploy several Golden Gate replication configurations like Bidirectional replication with collision handling controls, one-way replication, broadcast replication and mix of broadcast and bidirectional. Automate several golden gate shell monitoring and alerting scripts in addition to OEM GG plugin diagnostics and monitoring plugin solution.

Design, configure, deploy and maintain active physical Dataguard 11g (Active/Passive) on more than 10 instances in our environment and also leveraging some of the instances with Golden Gate replication to achieve high availability.

Proficient in Installation, Troubleshoot, Maintenance, Patching, Upgrades, Design and technical Support for Oracle (11g and 10g) Databases, Active Data Guard, Golden Gate Replication, and Grid Control 11g/12c.

Maintenance and development of database objects like Queues, Tables, indexes, Stored Procedure, constraints, triggers, Table & Index Partitioning, DB links, users, roles, profile and SQL NET and Listener.

I am proficient in SQL Server […] installations, migration, capacity planning, automated Backup Implementation and tuning.

Develop and document disaster recovery procedures in accordance with the Financial institutions policies

Design database structures, auditing, security, managing patches, and other tasks as needed to ensure regulatory compliance and a proactive security posture.

Experience is data encryption using Oracle Wallet to protect our client’s PII and to adhere to the industry standard.

Pennsylvania Employees Benefit Trust Fund (PEBTF) 10/2013 - 9/2014

Oracle DBA

Responsibilities:

Provide both onsite and on call Tier 3 and Tier 4 support for over 30 instances on Red-Hat Linux platform

Installed and Configured Oracle11g instances software on Linux; upgraded several databases from Oracle 10.2.0.1 to 10.2.0.4 to 11.2.0.6 and apply Oracle Critical Patch Update (CPU) patches on our databases as needed.

Performed database design tasks such as enforcing referential integrity standards; create database tables and table dependencies such as indexes, stored procedures, functions, packages, triggers, views, materialized views etc.

Create databases and documents procedure to migrate and refresh databases between the development and production environments.

Installed Oracle 10g and 11g on Sun Solaris 10, Linux (Oracle Enterprise Linux & RedHat) and Windows; maintained the software at the latest stable release level including testing and verifying the installed components

Maintaining various SLAs including ticket response and resolution time.

Performed tuning such as database tuning, SQL tuning such as query optimization (RULE and COST BASED), AUTOTRACE, and SQL Profile.

Worked with IT support to ensure secure access to database and applications by configuring and limiting access to servers and folders; managing users, groups and memberships, managing LDAP directories using Oracle Identity Manager (OID/SSO), tuning, capacity planning and connectivity issues.

Performed various DBA Maintenance task such as rebuilding indexes, validating constraints, reorganizing tables using the move command.

Performed SQL Server Administration by using SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Profiler/Server Side Trace, Database Tuning Advisor(DTA), Query Analyzer.

Apply SQL Server Service Packs and Cumulative Updates as required.

Setup technical procedures and administrative policies for production, test and development databases physical design, administration, maintenance, tuning, backup and recovery. Allocated system storage and plan future storage requirements for the database systems.

Used Oracle Transparent Data Encryption to encrypt tables and Tablespaces that contains PII data.

G4s Government Solutions, Washington, DC 06/2010 - 09/2013

Oracle DBA (Contractor)

Responsibilities:

Designed and developed the process to monitor disk space usage, CPU utilizations, memory utilization, disk I/O, network database connection.

Cloning Oracle database through RMAN Duplicates; maintaining the oracle backups and recoveries through RMAN.

Performance analysis of oracle databases through OEM and SQL Tuning the database with the developer for query optimization.

Installed Oracle 10g and 11g on Sun Solaris 10, Linux(Oracle Enterprise Linux 4 & 5,Redhat 5) and Windows; maintained the software at the latest stable release level including testing and verifying the installed components

Performed database design tasks such as enforcing referential integrity standards; create database tables and table dependencies such as indexes, stored procedures, functions, packages, triggers, views, materialized views etc

Used Oracle Transparent Data Encryption to encrypt tables and Tablespaces that contains PII data.

Performs daily health checkup of production which includes testing databases and performance of the Oracle Infrastructure.

Implemented database refresh with the hot backup using Duplicate or full Export/Import to do table level and full database defragmentation.

Performed SQL Server Administration by using SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Profiler/Server Side Trace, Database Tuning Advisor(DTA), Query Analyzer.

Applied SQL Server Service Packs and Cumulative Updates as required.

Implementing and maintaining SQL Server solutions in an Enterprise environment.

Responsible for installation, configuration and complete administration of different versions of SQLServer (2008 to 2012) .

Developed some Unix shell scripts to automate database operation and database monitoring.

INTERCOM, Arlington, VA 03/2009 to 5/2010

Database Administrator (Contractor)

Responsibilities:

Wrote several ad hoc scripts for daily DBA activities such as backups, user creations, granting roles and privileges, archiving of alert logs, verifying error entries and checking for space usages/overages.

Created and configured database by making changes to the Initialization Parameters in parameter file and dynamically in session.

Performed backup and recovery using Oracle 10g's user managed backup such as automated or manual cold backup and hot backup procedures.

Performs daily health checkup of production which includes testing databases and performance of the Oracle Infrastructure.

Created and configured database by making changes to the Initialization Parameters in parameter file and dynamically in session.

Administrative task that includes but not limited to: setting up schedule jobs using Oracle Scheduler, OS Crontab and Oracle OEM Grid Control (11g); Altered, Modified and Created Tables, Views and Sequences; Managed archives logs and redo logs; Created users, assigned Privileges and Roles; Modify tablespaces and object storage.

In depth knowledge and skilled in backup and recovery using RMAN recovery utility.

Execute Oracle 10g/11g Installation and upgrading Software and Database projects.

EDUCATION QUALIFICATION

University Of Maryland, College park, MD

B.S. Accounting.

TECHNICAL SKILLS

Oracle 11gR2/10gR2 installation, Patch sets Upgrade, Critical Patch Update. Upgrade 10g to 11g including data guard, Oracle Enterprise Manager Administration, SQL Loader Utility, Linux Administration, RMAN Configuration, Data Encryption and Data Pump Migration Utility. SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Profiler

OS/ Tools: Microsoft Window Server 2003/2008. Linux RedHat 5&6, Centos, SQL*Loader, SQL Developer, OEM and TOAD.

Contact this candidate