SUMMARY:

• Oracle DBA/Systems Administrator: database support, maintenance, installation, monitoring, and tuning of all databases. Mixed platforms such as: UNIX, Red Hat Linux, Windows.
• Ability to prioritize multiple responsibilities, multi - task and work effectively with other members of the technical team(s)
• Installing & configuring Oracle clusterware & Database Software
• Performing Grid and RDBMS upgrades
• Good hands-on experience with IAM development and privileges
• Including identity management, access management, and access governance. Experience developing identity management strategies, architectures, implementation plans and solutions
• Experience with resource provisioning, user life cycle management processes, identity and access governance which includes: role based access control, access request and certfication
• Knowledge of ASM, DDLs, DMLs, RMAN, Database Security, Performance Tuning, ORATOP, SQL Developer, SQL LOADER, RAC, Data Guard, Weblogic, Oracle VM, AWS, S3, EC2, EBS volumes, policy documents, multifactor authentication, automation, terraform, GitHub, Jenkins, Docker, Ansible, Splunk, and Vagrant
• Perform general technical trouble shooting and give consultation to development teams
• Evaluate Oracle features and Oracle related products and establish and maintain sound backup and recovery policies and procedures
• Responsible for monitoring server health and making response recommendations
• Eager to wear multiple hats and add support where needed

TECHNICAL SKILLS:

• Windows OS 2000/XP/Vista/7/8/10
• Oracle Databases 9i/10g/11g/12c--RAC/ASM/GRID
• Shell Scripting
• Troubleshooting
• Windows Server 2008/2012, Oracle VM/UNIX/LINUX/AIX, Confidential Cloud

PROFESSIONAL EXPERIENCE:

Confidential, Providence, RI

Database/Systems Administrator Information Security Officer

Responsibilities:

• Responsible for effective provisioning, installation/configuration, operation, and maintenance of systems hardware and software and related in Oracle over Linux environment.
• Perform regular security monitoring to identify any possible intrusions. Create, change, and delete user accounts per request.
• Performed daily backup operations, ensuring all file systems and system data are successfully backed up to the appropriate media, recovery tapes or disks are created, and media is recycled and sent offsite as necessary. In addition to performing regular file archival and purge as necessary. Maintaining operational, configuration, and disaster recovery procedures.
• Repair and recover from software/hardware failures. Coordinate and communicate with impacted constituencies. Applied OS and database patches and upgrades on a regular basis, and upgrade administrative tools and utilities. Add and configure new services as necessary.
• Perform ongoing performance tuning
• Protects system by defining access privileges, control structures, and resources. Recognizes problems by identifying abnormalities; reporting violations. Implements security improvements by assessing current situation; evaluating trends; anticipating requirements.
• Maintains quality service by following organization standards. Maintains technical knowledge by attending educational workshops; reviewing publications. Contributes to team effort by accomplishing related results as needed. Supporting federal government requirements for NIST Risk Management Framework Assessment and conducting IT security risk assessments on environment
• Safeguards information system assets by identifying and solving potential and actual security problems. Determines security violations and inefficiencies by conducting periodic audits.

Oracle Database Administrator

Responsibilities:

• Maintaining documentation and coding standards, lessons learned best practices, problem resolutions and quality improvement documentation for POC
• Unboxed and setup servers, SAN, and workstations
• Provide 24/7 hotline calls on issues related to any databases
• Install Oracle software on newly created servers in support of the infrastructure enhancements
• Configure Oracle networking components such as the SCAN, listeners, private interconnect, etc.
• Create Oracle database instances using DBCA to conform to Oracle's optimal flexible architecture (OFA) standard
• Create and manage tablespaces (datafiles), redo logs, controlfiles on Windows, Unix and Linux platforms
• Configure Oracle Enterprise Manager and maintain data integrity, managing profiles, resources and password security
• Create and manage users, privileges and roles
• Experience in database scalability, load balancing, availability, manageability, capacity planning
• Knowledgeable of standby/failover
• Knowledge of One-set patches, Oracle Critical Patch Update (CPU), and Patchset Updates (PSU) for Oracle versions 9i/10g/11g/12c
• Skilled in database optimization, monitoring and performance tuning for servers, SQL queries
• Provided on the spot troubleshooting and monitoring using Oracle tools and/or third party tools such as oratop, Toad, SQL Developer
• Knowledge of RAC, Data Guard; Led project of RAC installation and Data Guard setup
• Use RMAN to perform full and incremental backups and recovery, in addition to duplication and migration
• Administration tasks for production, test, development environments
• Responded and adjusted to multiple demands, shifting priorities, ambiguity and rapid changes in the work environment
• Implemented database security by enforcing roles and profile management.
• Documented all security practices and create daily management reports