SUMMARY:

• Work closely with other technical teams to ensure delivery of database services within performance target set
• Create and maintain all databases required for development, testing, and production usage
• Ensure that all systems are backed up and monitored according to the business requirements
• Pro - active and reactive performance analysis, monitoring, troubleshooting and resolution of issues
• Skilled in Oracle ASM administration
• Create and maintain a physical non-managed standby database
• Setup and maintain Oracle Grid Control
• UNIX shell scripting and programming skill
• Strong analytical and problem solving skill
• Excellent oral and written communications skill
• Installation, configuration, upgrading and migration of Oracle software
• Apply CPU (security) on a regular basis

TECHNICAL SKILLS:

OPERATING SYSTEMS: Red Hat Enterprise Linux, Oracle Enterprise Linux, Solaris, Mac OSX, Windows

RDBMS: Oracle 9i - 12c, Microsoft SQL Server 2014 (knowledge of programming language and basic management)

SOFTWARE: Oracle, Grid Control, RMAN, Dataguard (knowledge and creation of standby database), NetCA, Netmgr, DBCA, DBUA, RunInstaller, Toad, Veritas Netbackup, SQL*Plus, SQL*Loader, Data Pump, TKPROF

PROGRAMING: SQL, Unix Shell scripting, JAVA, C, C++, C#, VB .NET, ASP .NET, CSS, XHTML

Languages: Fluent in English and Spanish.

PROFESSIONAL EXPERIENCE:

Confidential, Glen Rock, NJ

Senior Database Administrator

Responsibilities:

• Implemented Oracle 9i-12c Standard/Enterprise Linux
• Implemented consistent backups using RMAN, Veritas Netbackup, and crontab
• Performed on-call duties of solving database issues or relaying to the right person or team
• Utilized system resources by enabling various Oracle parameters
• Analyzed space growth on production server, and proposed a plan for space management
• Built new production server, and migrated/upgraded the production Oracle 9i to 10g, 10g to 11g/12c, 32-bit server to a 64-bit platform utilizing Oracle ASM for better performance and space management
• Migrated database files from file system to ASM on test and production servers
• Created a standby database for production and test servers with RMAN and a log shipping script as an alternative to Oracle Data Guard, thus saving on license fee
• Installed and configured Oracle Application Server 10g, Oracle Adaptive Access Manager, and Oracle Adaptive Risk Manager
• Installed and patched Oracle Grid Control Release 5 Linux
• Participated in Disaster Recovery testing
• Worked with external auditors and verified valid users, privileges, and action codes on audit trails
• Attended meeting with Flexcube development team to get an understanding on the required layout of the database (structure, design, privilege, etc)
• Assisted developers with data import errors necessary for development progress
• Applied security patches to databases
• Troubleshoot and provided missing library files to Flexcube team for Oracle Adaptive Access Manager integration problem
• Installed Flexcube software
• Applied patches to Flexcube software provided by the Flexcube development team
• Wrote database backup utility for Flexcube development team
• Setup Flexcube UAT environment

Environment: Oracle RDBMS (9i-12c) on Oracle Enterprise Linux 4 - 6, Windows Server 2003 - 2012 Standard x64 Edition, Oracle Application Server 10g, IIS 5, IIS 7.5

Database Administrator

Responsibilities:

• Installed Oracle 10g Enterprise Edition software
• Configured Oracle 10g for cluster environment using Veritas Cluster Server
• Worked closely with IT project managers, programmers, and testers to ensure the database integrity and security
• Provide guidance to other team members
• Wrote complex queries and procedures using SQL*Plus and Toad
• Created users, allocated to appropriate tablespace quotas with necessary privileges and roles for all databases
• Configured TNSNAMES.ORA for SQL*NET connectivity
• Monitored and resized tablespace, relocated data files for better disk I/O
• Resolved connection problems
• Resolved enabling OLAP issue by running proper scripts
• Export/Import data
• Cloned schemas for testing environments
• Created database links and synonyms

Environment: Oracle (10g/9i) on Solaris 10 64-bit, Linux, Oracle Enterprise Manager 10g/9i

Database Administrator/Web Developer

Responsibilities:

• All aspects of Oracle support (installs, upgrades, performance tuning, patches and troubleshooting)
• Created and designed web pages for clients using Oracle, MySQL, Access, Flash, XHTML, CSS, and ASP.Net
• Maintained client request and assisted with technical issues relating to production support, customized scripts, changed site layouts and fine tuning databases
• Estimated Storage requirement, creation of tablespace, and other database primary objects
• Use different approaches to tune database and application codes
• Creation of users and roles and maintaining system security
• Provide guidance to other team members

Environment: Oracle 9i, TomCat, and Apache on Windows 2003, custom built server

Database Administrator/Web Developer

Responsibilities:

• Fully responsible for managing databases
• Performed weekly backups and restoration
• Updated files and records, designed tables, and table optimization
• Moved site to new host and updated database files
• Created and designed page content for clients using MySQL, JSP, CSS, and XHTML
• Wrote and maintained JSP scripts

Environment: MySQL 4.1, Apache on Mac OSX, Power Mac G4.