SUMMARY

• Experienced database administrator with 7 years background designing, implementing, and managing oracle databases in large scale production, development, and test environments across multiple platforms. Extensive technical skills, excellent communication, and support skills with advanced understanding of oracle, PostgreSQL, SQL server and AWS database services. Interested in a database administrator role.
• Monitoring, troubleshooting and performance tuning; Oracle DB 12c, 11g, 19c on Oracle Enterprise Linux, Unix, Windows server using CLI, SQL DEVELOPER, OEM, SHELL SCRIPTS, TOAD, TKPROF, ASH, AWR, ADDM, ORACLE SQL OPTIMIZER
• Moving data / databases (migrations and refreshes); same server, different servers and cloud migrations on AWS RDS, AURORA, POSTGRE, MYSQL, SQL SERVER using RMAN, DATA PUMP imp exp, SQL*LOADER, TRANSPORTABLE TABLESPACES, DMAF, SMS, DMS, SCT.
• RMAN Backup, restore and recovery strategies; user managed, RMAN physical and logical backups. Managing recovery catalog database and recovery related tasks (automating administration of backup strategies) with RMAN. Recovering critical and non - critical database files.
• EXPERT in Oracle Golden Gate configuration and maintenance for data replication.
• EXPERT in configuring and maintaining oracle HA/RAC and ASM, performing upgrades and applying patches.
• EXPERT in configuring and maintaining data guard for disaster recovery.

PROFESSIONAL EXPERIENCE

Confidential, NY

Database Administrator - Cloud Architect

Responsibilities:

• Installing, configuring, and maintaining Oracle Enterprise Edition, SQLserver databases in accordance with database administration guidelines, standards and procedures for database development, implementation, testing, and migration using Agile Software Development practices.
• Designing and building infrastructure for optimal extraction, transformation and loading of data from various data sources using AWS, as well as SQL and NoSQL data technologies. providing solutions that employ container and serverless patterns using AWS Fargate, AWS Lambda AWS cloud to realize business capabilities in a safe and secure manner.
• Designing the architecture for migrating on-premises applications, data warehouse and data marts to containers and data lake on AWS Cloud and implementing AWS cloud services like CI/CD pipelines (Jenkins), Lambda, DynamoDB, S3, SQS, SNS, CloudFront, Sage Maker, API Gateway.
• Performing database RMAN and user managed backups, archival, recovery and restore operations to ensure effective data protection and minimal data loss.
• Configuring, monitoring, and administering Data Guard for Disaster recovery
• Installing, Configuring, monitoring, and administering Grid Infrastructure RAC (2 node) with ASM for high availability through transparent application failover, load balancing, troubleshooted single client access network and database instances, CRS resources and storage related issues to ensure for optimal performance of application services.
• Performing duties related to the on-going operation of the database infrastructure including (capacity planning, proactive and reactive monitoring, refreshing data for development teams).
• Implementing Database security and protection standards and best practices using Transparent data encryption (column, table, and database encryption), user profiles and account management, audit policies to meet compliance requirements.
• Supporting standard Service Requests (create schemas, create objects, grant privileges, kill sessions) in a timely manner to meet customer needs per SLAs.
• Documenting changes, implementations and created shell scripts for maintenance and to automate tasks.
• Training and familiarizing new dba staff with systems, procedures and tools utilized in the environment to enhance dba team performance.

Confidential, MD

Oracle Database Administrator

Responsibilities:

• Configured, Implemented, and supported Oracle Golden Gate for data replication between environments. Configured Source and target Oracle Golden Gate Agents, including collision resolution configuration for bi-directional and unidirectional replication configurations for reporting and failover instances. Extracted/generated reports from OGG to get replication statistics on performance, bottlenecks, collisions details and replication rates. Actively monitored and maintained OGG configuration using Veridata.
• Installed, configured, tested, monitored, upgraded, and tuned new and existing Oracle and PostgreSQL instances of assigned databases including software installation and upgrades, best practices in database backup and recovery, capacity planning, performance tuning and monitoring, and data extraction as needed.
• Created new databases. Cloned and duplicated databases for development, testing and production environments to support software development teams.
• Monitored and troubleshooted database Performance and provided support for database related issues to ensure optimal performance per client SLA’s.
• Provisioned database users with approved access requests. Interacted with development and end-user personnel to determine application data access requirements, transaction rates, volume analysis, and other pertinent data required to develop and maintain integrated databases.
• Upgraded, maintained, and patched the database systems and related administration tools to ensure systems were up to date with the latest security patches and software versions.
• Developed, implemented, performed, and monitored backup and recovery procedures to address business needs.
• Performed database and data migrations, refreshes as needed for operational support of production and non-production systems/DBs and new deployments to the cloud.