SUMMARY:

• A highly accomplished, results - oriented technology expert in database administration, cloud solutions architecture, system infrastructure, network configuration, backup and recovery strategy, storage management, capacity planning, database migration, performance tuning, and managed services. An adaptable problem solver who improves operational processes to enhance productivity and efficiency of mission-critical systems. Knowledge of software development life cycle models as well as adapted Agile and traditional project management principles and practices

TECHNICAL SKILLS:

Databases: Oracle, PostgreSQL, Oracle Exadata, RDS, MySQL, AWS Aurora, DynamoDB

Languages: SQL, PL/SQL, Ansible, JSON, Unix Shell Scripting, AWS SDK Python (boto3)

Technologies: Data Guard, Golden Gate, AWS CLI

Cloud Technologies: AWS - RDS, EC2, RedShift

Utilities: TOAD, SQL Developer, pgAdmin, SQL Workbench, Apache Kafka

Tools: Remedy, ServiceNow, CA Scheduler

Operating Systems: Linux, Solaris, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Mclean, VA

Technology Lead

Responsibilities:

• Adapted and used CI/CD build process for deployment code using shell scripting.
• Using ServiceNow for Tracking Tickets and Dashboards to meet customer SLA’s.
• Wrote Agile Stories; Acceptance Criteria in CLM.
• Worked on AWS Glue to manage ETL Jobs and H2B - Randomization Process for DOL
• Wrote AWS Lambda function to create a scheduled snapshot for RDS database as per audit requirements.
• Used RDS snapshots to data lakes exports to S3; Designed AWS architecture.
• Build Standby Database using Oracle Restart 18c. Hardening database as per cyber requirements.
• Using Cloud Control 13c - Applied Oracle July 2020 Quarterly patch in 4 environments; database Hardening
• Designed and Deployed data security model for IRS using Virtual Private Database. POAM review
• Currently involved in Designing an ETL process to build a data lake for a federal client. Used Athena to process structured/un-structured data sets.
• Used AWS SDK python scripts to manage Startup/Shutdown Procedures and EC2 instances.

Confidential

Senior Infrastructure Administrator

Responsibilities:

• Supported the MIDAS project for CMS to support the migration of Oracle Databases to AWS, manage workload and resizing Cluster, build Redshift Clusters, plan migration activities, and administer MySQL and Postgres databases
• Worked with the developers on designing the tables, distribution styles and monitoring query performance
• Built the dynamic scripts to Migrate databases from datacenter to cloud.
• Oracle to Postgres Migration using Database Migration Service (DMS) and Schema conversion Tool (SCT)

Confidential

Database Manager

Responsibilities:

• Managed database team of 6 DBA’s and overall planning/implementation of database technologies.
• Migrating from On-Premise Infrastructure to AWS Cloud
• Reduces technical debt over time with root cause identification and resolution of system problems
• Oversaw strategic planning for team, managed day-to-day operations, met requirements of information security, incorporated industry best practices, introduced appropriate tools and systems, and proactively engaged with customers and colleagues to drive outcomes.
• Supervised full-time and temporary staff, managed Microsoft SQL Server and Oracle database environment, worked effectively across organizational boundaries, mentored junior staff, and incorporated new technologies as appropriate.
• Created custom dashboard to monitor Redshift Cluster. Managing workload using amazon redshift.
• Set up databases in AWS using RDS and connected the database to EC2 instance for contingency applications.
• Migrated Legacy Applications into AWS using Life and Shift Techniques. Used Ansible to provision the infrastructure.
• Carried out operational and performance reviews of team members to drive effectiveness.
• Managed implementation of 12c multi-tenant in all environments.
• Secured operation of Oracle databases on Exadata Machine (Linux) and Microsoft SQL Server databases in Windows environment.
• Managed Migration from Oracle to PostgreSQL in Amazon. Managed vendors to Outsource MySQL database.
• Oversaw internal audit requirements and supported SOC1 for databases.
• Planned, coordinated, and managed disaster recovery exercises using Data Guard technology.
• Leveraged strong domain knowledge on Oracle switchover and failover technologies, designed and implemented always on availability group on SQL Server.
• Supported SAS implementation into AWS Cloud and managed automation process.
• Transitioned SQL database team from infrastructure to DBA team. Involved in Enterprise Architecture Review board.
• Ensured exceptional client relations and vendor management.
• Migrated Exadata from X3 to X5 and installed OEM13c on Linux VM Machine.
• Worked on solutions to move elements of infrastructure to cloud and implemented dual authentication across all devices. Built playbooks for automation using Ansible. Used disposable AWS resources.
• Coordinated AWD imaging system upgrade and moved all read-only users from production primary to active standby database.
• Manage Baselines, Remediate Plan of Action & Milestones (POA&Ms)
• Kept senior management informed in biweekly status/project reports
• Key member with domain knowledge and makes critical decisions with other stack holders that impact overall project implementations.

Senior Database Administrator

Responsibilities:

• Implemented CIS security standards in all production environments and met tripwire requirements, data redaction, data encryption on network, and TDE. Implemented HCC (hybrid column compression).
• Coordinated with Oracle Platinum team every quarter on scheduling and conducting patch work, meeting Exacheck requirements.
• Upgraded all databases to 12c and migrated from Solaris 10 to Exadata Machine x3 in 2013 and X3 to X5 in 2016.
• Planned and coordinated all data refresh activities across organization.
• Mentored other team members, monitored nightly loads, and enhanced scripts.
• Upgraded RAC clusters and Applied quarterly patches on all instances across environments.
• Analyzed and implemented SSN conversion project.
• Finished upgrading grid infrastructure from 11.2.0.1 to 11.2.0.3 across multiple environments.
• Worked with infrastructure team to upgrade multiple COTS applications.
• Documented and managed recovery scenarios, startup and shutdown procedures, and DBA team support policy and procedures.
• Planned and coordinated all database activities with application managers.