Objective:
An IT professional focused on database administration with Oracle 9i – 11g; experience in designing, coding, testing and supporting next-generation database solutions in Oracle Enterprise environments. Proficient in an assortment of technologies, including Oracle 9i/10g/11g, JDBC, Visio, Apache Web Server, Java, C++, XML, Linux and Windows.

Summary:

• Database capacity planning related to database growth and system utilization, trend analysis, and predicting future database resource requirements
• 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
• Experience in Oracle Data Guard
• 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, UNIX, Solaris, Mac OSX, Windows
RDBMS: Oracle 11g/10g/9i
SOFTWARE: Oracle, Flexcube, NetCA, Netmgr, DBCA, DBUA, Enterprise Manager, RunInstaller, Toad, Veritas Netbackup, RMAN, Grid Control, SQL*Plus, SQL*Loader, Data Pump, Export/Import, Oracle Management Server, TKPROF, Java, Unix Shell scripting, Erwin, Oracle Application Server, Oracle Adaptive Access Manager, Oracle Adaptive Risk Manager
PROGRAMING: SQL, JAVA, JSP, JAVASCRIPT, C, C++, VB .NET, ASP .NET, CSS, XHTML
HARDWARE: SUN Ultra IV+ Dual Core CPU, Data Domain DD510, Dell PowerVault MD1000, Dell PowerEdge 2950, Dell PowerEdge R9000, NAS, NSC 55, Power Mac G4, MacPro, and custom built servers.
Languages: Fluent in English and Spanish.

Education:

• Master of Science, Computer Science
• Bachelor of Science, Computer Science
• Associate of Art, Fine Arts

Professional Experience
Confidential,NJ Database Administrator 2007 – Present
Manage Oracle database administration assignments for a privately owned back-end processing services to financial institutions. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning, and conduct regular system backups. Ensure technical and functional designs meet business requirements.
Responsibilities:

• Implemented Oracle 10g/11g 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 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 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 (11g,10g,9i) on Oracle Enterprise Linux 4 64-bit, Oracle Enterprise Linux 5 32-bit, Windows Server 2003 Standard x64 Edition, Oracle Application Server 10g, Oracle Adaptive Access Manager, Oracle Adaptive Risk Manager, IIS 5, IIS 7.5, Data Domain DD510, Dell PowerVault MD1000, Dell PowerEdge 2950, Dell PowerEdge R9000

Confidential, Database Administrator 2006 – 2007
Contracted by IBM to join a team of database administrators for their client, AT&T. Developed functions, scripts and reports that were instrumental to the success of high-priority development projects.
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 SunOS5.10-64 bit, Linux, Oracle Enterprise Manager 9i/10g, SUN Ultra IV

Confidential, Database Administrator/Web Developer 2005 – 2006
Joined an accounting software company as a contract to hire database administrator and web developer. Developed web site for clients, and maintained main corporate web site.
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

Confidential, Database Administrator/Web Developer 2003 – 2004
Managed and maintained all aspects of a music publishing web site utilizing database administration, programming, and web development.
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.