SUMMARY

• Database administration and security professional wif an 11 - year track record of building and supporting the architecture, design, implementation, and configuration of highly available, secured and resilient database systems.
• Team leader wif proven skill leading a full spectrum of information management technology and giving security-based direction in technical standards, planning, and strategy.

TECHNICAL SKILLS

Platforms: Oracle (11g, 12c, 18c and 19c) Databases, Amazon Web Services (AWS), Azure, Unix OS.

Software Tools: AWR, ASH, ADDM, Toad, Sql Developer, Tortoise SVN, Tectia, ServiceNow, Jira, Remedy, TKPROF, HTTPS, SIC Benchmark, SOC1, SOC2, SOX, EXPLAIN PLAN, GDPR, NIST, AICPA, PII, Oracle Enterprise Manager OEM 12c & 13c Cloud Control, Unix shell scripts, Oracle 12c Gloden Gate, RAC, & Data Guard, FGA, Oracle Vault, Agile. Kanban, DevOps, TDE, TLS, SSL, SSL VPN, Web filters, RMAN, RHEL 6.3, Solaris, ASM, Oracle Grid infrastructure, PLSQL, SQL, RDS, S3, VPC, EC2, Route53, ELB, CloudWatch, AMI, Subnets, Internet Gateway, Route Table, Log Miner, GG.

PROFESSIONAL EXPERIENCE

TEMPPrincipal Oracle Database Administrator (DBA)

Responsibilities:

• Automated monitoring and cleanup tasks to reduce database outages and redesign dropped the number of incidents from 50+ daily incidents to about 5.
• Coordinated work wif off-shore and production support to manage databases for a 24-7 on-call database administration support line.
• Utilized business data to plan for sizing capacity and consolidation of applications into containerized pluggable databases saving the SEC about 20% of annual infrastructure expenses.
• Facilitated Oracle upgrades from 11g database to 12.2 and 18c/19c and performed regular health checks to resolve any problems in the upgraded environment.
• Employed and corrected a physical standby Data Guard for high availability and disaster recovery purposes.
• Queried databases using SQL and PL/SQL and server scripts to verify data integrity.
• Fixed invalid database components and successfully upgraded and patched legacy database from oracle 11g to 19c dat had been abandoned due to invalid data dictionary components.
• Developed, tested and maintained a Disaster Recovery plan proving beneficial using Data Guard Broker in multitenant environment between two data centers.
• Assigned to support of 100+ mission-critical database instances at moment's notice due to company support staff transitioning and learned all applications on-the-fly wifin 2 months and tan supported wifout any major outage for 1.5 years.
• Reduced planned upgrades time by 6months through consolidation of source and target data centers using Network File Systems (NFS).
• Reset the bar on how database code should be promoted in production and streamlined the IT staff on best backup and recovery solutions based on database requirements.

Senior Database Security and Compliance Specialist

Responsibilities:

• Performed user recertification, created a patch tracking system, and applied data encryption dat improved overall system security findings and vulnerabilities by 85%.
• Led day-to-day customer service team and exceeded obligations to internal customers by 80%.
• Implementing user level security, object level security, data encryption, data masking, and Fine-Grained auditing using DBMS FGA package.
• Analyze and prioritize activities to deploy Security patches to all core Infrastructure technologies.
• Responsible for reporting back on progress of compliance
• Contribute to creating metric reports dat track team success. Drive accountability to ensure ISSACA audit standards is maintained to zero breach in compliance.
• Ensure tools used in the role to maintain accurate and TEMPeffective risk profile along
• Provide technical assistance in response to audit reports
• Enabled unified auditing across all production environments to consolidate audit data
• Facilitated team success by crafting metric reports and reinforcing accountability to zero breach compliance wif ISSACA standards.
• Collaborated wif Information Security, Network Security and compliance teams to validate dat data security design, processes and procedures align wif broader agency policies, standards and requirements.

Cloud Ops Database Administrator

Responsibilities:

• Monitored and maintained 30 TB data transition from on premise databases to AWS Redshift.
• Performed metadata conversion from Oracle to Redshift using Schema Conversion Tool - AWS SCT
• Used AWS SCT sort keys and distribution keys redshift database optimization
• Replicate database objects in AWS Redshift via Change Data Capture - CDC
• Installed and configured SQL client such as Aginity workbench for O&M tasks in redshift
• Loaded data into S3 in the form of CSV files
• Loaded data from S3 into Redshift using AWS copy command
• Followed AWS DMS best practices to load data into redshift
• Created database objects in AWS Redshift
• Loaded database tables from external database into AWS S3 buckets

Enterprise Data Warehouse Database Administrator

Responsibilities:

• Built and started database warehouse migration from a standalone system to a RAC cluster database wif a disaster recovery site using Data Guard.
• Install and configure new RAC databases on ASM to host US courts enterprises data warehouse (EDW) for the Office of Financial Management (USPTO-OFM).
• Created and maintain database administration documentation.
• Work wif cross team members of OS, BO/BI, CDC and data architects to develop and deploy EDW applications.
• Installed oracle client on SAP data services and business object servers.
• Installed oracle client on Tom Cat web servers.
• Reviewed and improved database architecture setup.
• Deinstalled and reinstall poorly built RAC clusters across two data centers for (USPTO-OFM).
• Installed and / or cloned Oracle databases to create/refresh development and test environments.
• Enhanced database security through role separation and profile parameter improvements.
• Performed database patching for bug fixes and to mitigate security vulnerabilities.
• Implemented tables indexes and Data partitioning Strategies dat improved database ETL performance by 60%
• Tested recovery and supported continuity of operations procedures (COOP).

Confidential, Columbia, MD

Database Administrator/Assistant Lead

Responsibilities:

• Built and deployed quality reporting systems to send real-time data to the database management system involving the Physician Quality Reporting System (PQRS), Hospital Quality Reporting System (HQRS), and Fraud Prevention System (FPN).
• Designed and executed a HIPPA compliant database on Oracle 11gR2.
• Upgraded databases from Legacy, Red Hat, Enterprise, and Linux to Oracle 11.2.0.3.
• Designed and executed a HIPPA compliant database on Oracle 11gR2.
• Upgraded databases from Legacy, Red Hat, Enterprise, and Linux to Oracle 11.2.0.3.
• Spearheaded the development and application of ETL standards and procedures for the data warehouse environment.
• Provided database status reports on daily operations meetings wif entire CMS staff as DBA team lead during the Tech Lead's absence.
• Spearheaded the development and application of ETL standards and procedures for the data warehouse environment.

Oracle Database Administrator

Responsibilities:

• Drove a team or architects, modelers, and developers as the sole database administrator accountable for planning, designing, and applying Target’s first enterprise inventory and order management database dat consolidated the architecture and synchronized orders from the Target.com website to in-person stores.
• Planned an upgrade for all critical production databases from 9i to 10g on Linux and Data Guard.
• Played instrumental technical role in Oracle design, performance, security, troubleshooting, and configuration enhancements, minimizing production bugs and establishing Oracle best practices.
• Rolled-out RMAN backup strategy, enhancing data availability and integrity.
• Implemented a standard process to refresh terabytes of data from different environments and masking.
• Enhanced managements of 50 plus databases wifin 24/7 environments via strategic allocation of resources.