Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Shabani Biboze

White Plains,MD

Summary

Oracle DBA with over 12 years of information technology experience. Solid understanding and experience in Oracle technologies in 10g, 11g, 12c, 18C, 19C & 21c including RAC, ASM, Data guard and Goldengate. Install, tune, maintain and monitor Oracle database, products, and services on both Production and Development; including, but not limited to, capacity planning, database performance tuning, backup and recovery, and change/configuration management. Perform Installation, Patching, Upgrade, Migration, Cloning, troubleshoot issues/errors/Incidents, Collaborate with Oracle Support for bugs & issues resolutions and personal research. Experience to work with various Oracle features like Flash-Back Recovery, Data pump, RMAN, ASM, ASH, AWR, ADDM, ASMM, Automatic Undo management and Recycle Bin to accomplish my work. Experience in database migration, cloning and replication using different tools like RMAN, Goldengate, Data pump, AWS DMS, AWS SCT, SSMS, SSDT and Oracle SQL Loader. Design and plan the best database backup and recovery strategies and implementation. Experience on backup and restore Oracle databases using RMAN, SSMS and Data pump utility. Installation. Configuration, Upgrade and performance tuning of Oracle RAC, Data guard and ASM for High Availability and disaster recovery. Configure TDE for database security. High experience on Oracle GoldenGate for data replication and database migration. Tuning SQL statements using SQL tuning advisor, Explain Plan, SQL Trace, TKPROF and STATSPACK. Knowledge to maintain WebLogic server, installation, upgrade, patching, troubleshooting and deployments. Experience in Installing, configuring, administration and maintenance of mission critical client databases in SQL server 2008, 2008R2, 2012, 2014, 2016, 2017 and 2019 versions. Extensive experience upgrading SQL Server (In place Up and Side by side Up grade) based on application compatibility and fixing the orphan users. experience on configuring and maintaining SQL Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index rebuild, index reorganize based on fragmentation. Strong experience on identifying and troubleshooting database health, integrity checks and fixing them. Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security. Deploy and configure various AWS RDS instances and security group. Worked and managed multiple AWS RDS instances such as Aurora, Oracle, MSSQL, MySQL, and PostgreSQL. Migrate Oracle databases to AWS RDS using AWS DMS and Oracle data pump utility. Defined AWS Security Groups which acted as virtual firewalls that controlled the traffic, allowed reaching one or more AWS EC2 and RDS instances. Hands on experience in encrypting data using AWS Key Management Service (KMS). Worked tools like Ansible, chef and Puppet for automation. Significant Knowledge of scripting skills in bash/ksh, PowerShell, Python, Perl. Significant skills in project management methodologies like Agile, Kanban, Jira, Confluence and DevOps. Significant knowledge of containerized application such as Docker and Kubernetes. Deploy and manage database in the containerized application Docker and Kubernetes. Significant knowledge of managing and build Kubernetes cluster on cloud in EKS, AKS, GKE and OKE. Significant knowledge on code version control tool such as GIT, GITLAB and AWS S3 Bucket migrating on-premises workloads to Oracle Cloud Infrastructure. Participated in disaster recovery planning and testing for OCI environments. Conducted performance tuning and capacity planning to optimize OCI resources. Monitored OCI environments, performed troubleshooting, and resolved incidents promptly. Collaborated with cross-functional teams to identify and address infrastructure-related issues. Implemented security best practices to ensure the confidentiality and integrity of data on OCI. Managed and optimized OCI resources to ensure cost-efficiency while meeting performance requirements. Implemented and managed Oracle Cloud services such as Compute, Storage, Networking, and Identity and Access Management.

Experienced with SQL Server database management, ensuring optimal performance and reliability. Utilizes strong skills in performance tuning, data backup, and recovery to enhance database efficiency. Track record of implementing effective security protocols and maintaining high data integrity.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Senior Oracle & MS SQL Server Database Administrator

Unissant Inc and SMDI Inc under contract with U.S. Department of Health and Human Services (HHS)
10.2017 - 10.2024
  • Company Overview: Administration for Children and Families - Washington, DC
  • Worked as a Team Lead in the design and implementation of large, complex database solutions
  • Consulted with IT staff and clients to determine the impact of new or revised applications on information architecture
  • Maintained and monitored Oracle & SQL Server database, products, and services on both Production and Development; including, but not limited to, capacity planning, database performance tuning, backup and recovery, and change/configuration management
  • Designed, developed, and implemented complex physical databases across multiple platforms, technologies, and computing environments
  • Build and migration to AWS RDS including MySQL and Postgres DBs
  • Performed Oracle database performance analysis and optimization, defined bottlenecks and managed testing and production implementation
  • Monitored, administered, and troubleshoot database issues using OEM Grid, Toad, SQL Developer, and SQL command line
  • Worked with Oracle Support when necessary to resolve Service Request (SRs)
  • Hands on experience on performance tuning and troubleshooting skills for Oracle 12c/19c
  • Implemented TDE encryption and tablespace encryption in Oracle 19c
  • Performed Installation, Configuration, Migration, Maintenance and Performance Tuning, Backup/Restore;
  • Performed deep impact analysis of problems, projects, or technical solutions
  • Closely cooperated with vendors and external service providers
  • Developed and implemented processes
  • Performed database administrative procedures using the latest tools and technologies
  • Worked closely with technical and client management to ensure implementation of database management and support tools for complex business application development requirements and processes in accordance with the latest enterprise direction (e.g., diverse development platforms, technological environments, software, hardware and tools)
  • Worked with AWS RDS oracle database migration
  • Provided training, knowledge transfer and professional development on new technologies and applications to staff
  • Secured database servers by performing regular checks to ensure servers are properly hardened
  • Created several shell scripts for automation including database backup
  • Edited and executed scripts to create and modify functions, procedures, triggers, packages and package bodies, constraints, and views, as requested on different databases
  • Participated in several software release efforts
  • Used Ansible an automation engine to automate tasks that are either cumbersome or repetitive or complex, like configuration management, cloud provisioning, software deployment, and intra-service orchestration, on AWS cloud services (EC2, IAM, S3, RDS, VPC, SNS, CloudWatch)
  • Capacity planning, server consolidation and disaster recovery MSSQL SQL server, SSRS, SSIS
  • Performed problem resolutions and root cause analysis along with recommending and implementing solutions
  • Administration for Children and Families - Washington, DC
  • Environment: Oracle 11g/12c &19c, VMS, Sun Solaris, Windows Server 2003, MS SQL Server 2008/2014/2017, Red Hat Linux, TOAD, RMAN, MS SQL server, S3 Bucket, Putty, WinSCP, EC2, S3, Amazon RDS, ELB, EBS, VPC, Auto Scaling, Cloud Formation, Cloud Watch, Code Deploy, IAM, Route 53, SES, SNS, SQS, Cloud Trail, MySQL, ColdFusion, MS Access, SharePoint, SSRS, WebLogic

Senior Oracle & MS SQL Server Database Administrator

AcisTek Corp and Quadrant Inc Under Contract with U.S. Department of Health and Human Services (HHS)
01.2017 - 10.2017
  • Company Overview: Administration of Children and Families - Washington, DC
  • Worked as a Team Lead in the design and implementation of large, complex database solutions
  • Consulted with IT staff and clients to determine the impact of new or revised applications on information architecture
  • Maintained and monitored Oracle database, products, and services on both Production and Development; including, but not limited to, capacity planning, database performance tuning, backup and recovery, and change/configuration management
  • Designed, developed, and implemented complex physical databases across multiple platforms, technologies, and computing environments
  • Performed database administrative procedures using the latest tools and technologies
  • Worked closely with technical and client management to ensure implementation of database management and support tools for complex business application development requirements and processes in accordance with the latest enterprise direction (e.g., diverse development platforms, technological environments, software, hardware, and tools)
  • Provided training, knowledge transfer and professional development on new technologies and applications to Junior DBA and the Team
  • Secured database servers by performing regular checks to ensure servers are properly hardened
  • Created several shell scripts for automation including database backup
  • Edited and executed scripts to create and modify functions, procedures, triggers, packages and package bodies, constraints, and views, as requested on different databases
  • Monitored, administered, and troubleshoot database issues using OEM Grid, Toad, SQL Developer, and SQL command line
  • Worked with Oracle Support when necessary to resolve Service Request (SRs)
  • Used Ansible for basic deployments
  • Performed Installation, Configuration, Migration, Maintenance and Performance Tuning, Backup/Restore, Capacity planning, server consolidation and disaster recovery MSSQL SQL server, SSRS, SSIS
  • Performed problem resolutions and root cause analysis along with recommending and implementing solutions
  • Administration of Children and Families - Washington, DC
  • Environment: Oracle 11g/12c &19c, VMS, Sun Solaris, Windows Server 2003, MS SQL Server 2008/2014/2017, Red Hat Linux, TOAD, RMAN, MS SQL server, S3 Bucket, Putty, WinSCP, EC2, S3, Amazon RDS, ELB, EBS, VPC, Auto Scaling, Cloud Formation, Cloud Watch, Code Deploy, IAM, Route 53, SES, SNS, SQS, Cloud Trail

Senior Database Administrator

System Plus Inc Under Contract with US Department of Labor
04.2016 - 10.2016
  • Company Overview: Office of Federal Contract Compliance Programs (OFCCP) - Washington, DC
  • Performed Oracle database administration tasks include configuration management, backup/recovery, performance optimization, and space management
  • Worked with development teams and 3rd party vendors throughout the development life cycle regarding optimal use of database resources and features
  • Performed database space management and monitoring
  • Assisted with migration and/or load of application data into the database environment
  • Ensured standardization of systems implementation, support techniques, and adherence to formal processes, change control, best practices, and total quality practices in all activities
  • Administered and support Oracle versions 9i, 10g, 11g, 12c and 19C on UNIX (AIX and Solaris), Linux (RHEL) and Microsoft Windows 2008/2014 platforms
  • Automated Ansible playbook to install and patch Goldengate
  • Monitored and maintained database (checking alert logs, space management, undo management, gathering database statistics
  • Worked with Oracle Support to resolve Service Request (SRs)
  • Office of Federal Contract Compliance Programs (OFCCP) - Washington, DC
  • Environment: Oracle 10g/11g/11g RAC/9i, Oracle 12c, VMS, Sun Solaris, IBM DBA2, Red Hat Linux, TOAD, RMAN, SQL server, OEM
  • Putty, WinSCP, Window Server 2003, RAC, ASM, Data Guard, EC2, S3, RDS, ELB, EBS, VPC, Auto Scaling, Cloud Formation, Cloud Watch, Code Deploy, IAM, Route 53, SES, SNS, SQS, Cloud Trail

Oracle Database Administrator

FedEx
06.2012 - 04.2016

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, UNIX & LINUX, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL Plus, SQL, Loader, OEM, TOAD 10.0, EC2, S3, RDS, ELB, EBS, VPC, Auto Scaling, Cloud Formation, Cloud Watch, Code Deploy, IAM, Route 53, SES, SNS, SQS, Cloud Trail

Oracle Production Support Database Administrator

Tribune Company
06.2010 - 06.2012

Environment: Oracle 11.1.0.4, 10.2.0.3, 9i, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL

Plus, SQL, Loader, OEM, TOAD 10.0, EC2, S3, RDS, ELB, EBS, VPC, Auto Scaling, Cloud Formation, Cloud Watch, Code Deploy, IAM, Route 53, SES, SNS, SQS, Cloud Trail

Oracle Database Administration

Central Financial Technology of Russia
01.2008 - 06.2010

Environment: Oracle 10g/11g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM

Education

BS - Automation and System Control Engineering

Peoples Friendship University of Russia

Skills

  • Relational database (Oracle, SQL Server, PostGreSQL)
  • Data backup, restore and migration
  • Cloud database management (AWS RDS instances, Azure and OCI)
  • Database security (TDE, SSL/TLS, Wallet)
  • Replication management (Gold Gate, AWS DMS, Azure ADM etc)

Certification

  • Public Trust Clearance - HHS & ACF
  • CompTIA Security+ Certification
  • OCA - Oracle Certified Associate (11g)
  • OCP - Oracle Certified Professional (12c)
  • Oracle Cloud Infrastructure 2023 Foundations Associate
  • AWS Certified Solutions Architect Associate
  • AWS Certified DevOps Engineer Professional
  • Microsoft Azure Administrator Associate
  • Management and support of CFT-Bank system Certificate

Languages

English
Professional Working
Russian
Limited Working

Timeline

Senior Oracle & MS SQL Server Database Administrator

Unissant Inc and SMDI Inc under contract with U.S. Department of Health and Human Services (HHS)
10.2017 - 10.2024

Senior Oracle & MS SQL Server Database Administrator

AcisTek Corp and Quadrant Inc Under Contract with U.S. Department of Health and Human Services (HHS)
01.2017 - 10.2017

Senior Database Administrator

System Plus Inc Under Contract with US Department of Labor
04.2016 - 10.2016

Oracle Database Administrator

FedEx
06.2012 - 04.2016

Oracle Production Support Database Administrator

Tribune Company
06.2010 - 06.2012

Oracle Database Administration

Central Financial Technology of Russia
01.2008 - 06.2010
  • Public Trust Clearance - HHS & ACF
  • CompTIA Security+ Certification
  • OCA - Oracle Certified Associate (11g)
  • OCP - Oracle Certified Professional (12c)
  • Oracle Cloud Infrastructure 2023 Foundations Associate
  • AWS Certified Solutions Architect Associate
  • AWS Certified DevOps Engineer Professional
  • Microsoft Azure Administrator Associate
  • Management and support of CFT-Bank system Certificate

BS - Automation and System Control Engineering

Peoples Friendship University of Russia
Shabani Biboze