SUMMARY:

• Oracle DBA/Systems Administrator database support, maintenance, installation, monitoring, and tuning of all databases. Mixed platforms such as: UNIX, Red Hat Linux, Windows.
• Provided workable, practical solutions to major corporations, contribution included not only design, but also seeing the design through implementation and organizing production operations, maintaining data integrity, managing profiles, resources and password security
• Ability to prioritize multiple responsibilities, multi - task and work effectively with other members of the technical team(s)
• Planning, designing, and supporting RAC /ASM environment
• Installing & configuring Oracle clusterware & Database Software
• General knowledge of HIPAA and privacy rules
• Knowledge of ASM, DDLs, DMLs, RMAN, Database Security, Performance Tuning, ORATOP, SQL Developer, SQL LOADER, RAC, Data Guard, Weblogic, Oracle VM
• Perform general technical trouble shooting and give consultation to development teams
• Installation, configuration, and upgrading of Oracle server software and related products
• 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
• Ability to learn new software applications quickly
• Eager to wear multiple hats and add support where needed
• Created and maintained policy standards to meet 3 rd party vendor needs such as: Information Security Policy, Acceptable Use policy, Incident Response Plan, Risk Management Program and various other IT Security policies
• Safeguards information system assets by identifying and solving potential and actual security problems. 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. Determines security violations and inefficiencies by conducting periodic audits. Upgrades system by implementing and maintaining security controls. Keeps users informed by preparing performance reports; communicating system status. 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.
• Self-directed, highly motivated, with a strong work ethic

TECHNICAL SKILLS:

• Windows OS 2000/XP/Vista/7/8/10
• Oracle Databases 9i/10g/11g/12c: RAC/ASM/GRID
• Windows Server 2008, Oracle VM/UNIX/LINUX/AIX

PROFESSIONAL EXPERIENCE:

Confidential

Database/Systems Administrator

Responsibilities:

• Responsible for effective provisioning, installation/configuration, operation, and maintenance of systems hardware and software and related in Oracle over Linux environment.
• Continuous evaluation of current systems security posture and monitors activities associated with IT security compliance. Manages the development of information system security plans and procedures, and ensuring that they are in compliance with federal laws, related Confidential standards, and agency IT security policies and directives.
• 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.
• Repair and recover from software/hardware failures. Coordinate and communicate with impacted constituencies.
• Provided technical assistance to remediate critical vulnerabilities and security weaknesses through the completion of Plans of Action and Milestones (POA&Ms). Conducts and documents risk and vulnerability assessments of planned and installed IT systems to determine level of risk to confidentiality, integrity, and availability of Agency systems and data
• 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 periodic performance reporting via AWR or Segment Advisor for spacing to support capacity planning, and performance tuning of server and database which may include hardware upgrades, and resource optimization as required.
• Maintaining operational, configuration, and disaster recovery procedures.
• Continuous evaluation of current systems security posture and monitors activities associated with IT security compliance. Manages the development of information system security plans and procedures, and ensuring that they are in compliance with federal laws, related Confidential standards, and agency IT security policies and directives.
• Established risk-management procedures and ensures that risk-management techniques are applied to new or modified IT systems. Scheduled and conducted vulnerability scans, analyses, surveys, or reviews of IT systems to assure that appropriate levels of safeguards exist to protect against perceived threats. Planned and directed the development of security criteria and guidelines for users of IT systems.
• Analyzed the development of information systems requirements and plans for systems integration. Evaluated the adequacy of change management by reviewing the configuration change process and policy. Developed and evaluated testing strategies, plans, or scenarios.
• Reviewed and evaluated security policies - identified the need for change based on new security technologies or threats.
• Wore multiple hats that include: physical security, application and data security, system software security, contingency planning, security education and training.

Confidential

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 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 recoveries
• 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
• In addition, Visio, Oracle form reports. Crystal reports