SUMMARY:

• Over 10 years of IT experience with focus in Database and Managed Cloud Technologies including SQL Server and Oracle Database Administration including installation, configuration, space management, backup and recovery, database security, troubleshooting, performance turning, clustering and high availability.
• Expertise in working on database hosted by Oracle Managed Cloud Services
• Expertise in Oracle database administration on versions 11g/10g/12c on different environments such as UNIX, RHEL, OEL and MS Windows
• Enforcing Database security by creating and assigning Roles, Profiles and Privileges to various Users (Schemas) on different Objects.
• Expertise in space management acting with dump files, table spaces, data files, archive files, redo logs with experience in work with Automatic Storage management (ASM) .
• Experience in administration of ORACLE with up to 10 clusters Using Real Cluster Application (RAC) .
• Created procedures and scripts to Run, stop, and check jobs in ORACLE
• Worked with UDM sessions (User defined Metrics). Metrics used to maintain end get better performance in the database
• Extensive experience in daily batch and report monitoring, space management, creating and rebuilding indexes, statistics collection and other Oracle housekeeping tasks.
• Expertise in maintain databases available and healthy (prod and non - prod environment).
• Experience in backup, monitor, and maintain management using ORACLE Data Guard.
• Involved in the installation, configuration and extended support to Oracle 11g and 12c two Nodes using RAC (Real Application Cluster) with ASM file system on Red Hat Enterprise Linux platform.
• Experience working with Global teams, providing round the clock operations support ensuring compliance with SLA.
• Proficient in Verbal and Written Communication skills, speaking three languages (Portuguese, English, and Spanish).
• Proven Leadership and interpersonal skills, commitment, result oriented, strong analytical and problem solving skills who can work independently or as part of a team.

TECHNICAL SKILLS:

Languages/Scripts: C, JAVA, HTML, SQL, XML, CSS., Shell Script.

RDBMS: MS SQL Server, Oracle 10g, 11g, 12c, MySQL. BladeLogic Database Automation

Tools: and utilities RMAN, OEM, TOAD, Oracle SQL Developer Eclipse IDE, Net Beans, Active Directory, VMware, Virtual Box, Xlaunch, BMC Remedy Ticketing tool.

Operating Systems: Linux 7, RHEL, UNIX, MS Windows Server.

PROFESSIONAL EXPERIENCE:

Confidential, Gaithersburg, MD

ORACLE and SQL DBA

Responsibilities:

• Provided support for Oracle and SQL server Databases - Disaster recovery, performance analysis and tuning, index maintenance, and monitoring of data. Administer, maintain, and implement policies and procedures for ensuring the security and integrity of the database.
• Troubleshooting issues and tune memory parameters on oracle databases for better performance.
• Created scripts to check parameters of the database like Listener .
• Identified and resolved issues of locked sessions in Windows and UNIX environments. Used scripts to check the logs and kill it.
• Created several scripts to check, create, update, and delete users, objects, and roles .
• Documented all process to access alert and UNIX logs using VI
• Created scripts to check and recompile invalid objects
• Created script to see if a process is running in UNIX.
• Documented all the ASMCMD commands.
• Documented all the procedures to create a database grid
• Created a document on how to use BLADE LOGIC AUTOMATION . This is a tool to update databases all together. Its function is automate process.

Environment: SQL Server, ORACLE, Hyper V, CISCO dashboard, DATTO dashboard, Active Directory

Confidential, Gaithersburg, MD

ORACLE DBA

Responsibilities:

• Successfully installed and configured Oracle 11g and 12c databases on, Red Hat Enterprise Linux, and Windows.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control and Remedy ticketing tool.
• Implemented oracle 12c active standby database for test database environment.
• Implemented and documented Oracle 12c and Oracle Linux 7 installation to be used by fresher DBAs as training in Oracle virtual box.
• Managed user privileges, Roles, Auditing, Profiling, locking, unlocking, creating and updating accounts.
• 24x7 on-call support for 2 databases of 2.0 TB 4 Node production 10g and 11g RAC databases.
• Configured Listener and TNSnames, Starting, stopping, checking status, configuring parameters and diagnosing any issue with it.
• Management of Database Maintenance Activities to achieve optimum database uptime.

Environment: Oracle SQL Developer, Putty, ORACLE VM, XLaunch, RMAN, AWR.

Confidential

Oracle and SQL DBA

Responsibilities:

• Responsible for supporting ORACLE and Microsoft SQL Databases. Administration of Real Application Cluster (RAC) databases. Worked with senior DBA’s installing databases, preparing cluster, configuring and Installing Oracle RAC on RHEL. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager or manually.
• Created users, roles, objects, and privileges.
• Installed databases 10g and11g in Red hat environment through DBCA.
• Created and documented script to check, create and rebuild indexes.
• Created scripts and documented scripts to Solve space issues in UNDO and TEMP table spaces. Besides the issues with logs inside the servers.
• Documented scripts to manage archive logs
• Created scripts and Documented procedures to check and kill session locks.
• Worked and documented managing database of passwords with Cyber-Ark Enterprise Password Vault
• Configuring listeners and TNSnames.
• Worked with advanced queues
• Checked fixed gaps between main and DR databases
• Worked with Imperva firewall, opening ports and letting the communication of some servers.
• Worked with ORACLE Wallets, opening and checking the status.
• Created documentation to Dropped and created DBlinks

Environment: ORACLE 11g/10g, UNIX, SQL Developer, PL/SQL, Shell scripting, RMAN, AWR, Putty. Imperva firewall, BMC Bladelogic