Lead Oracle Dba Resume
OBJECTIVE: Seeking a position in the areas of SQL 2000, 2005, 2008 and/or Oracle Database
Administration.
Bachelor of Business Administration Major – Management Information Systems / Minor - European Studies
Master of Business Administration
CERTIFICATIONS:
Microsoft: Microsoft Certified Professional Windows 2000 Server 70-210, Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition 70-228,
Oracle: PL/SQL Programming 1z0-147
Hewlett Packard :HP Data Protector/Omniback Certified,
Xerox: Xerox Certified Training Specialist.
LANGUAGES:, SQL, PL/SQL,Visual Basic, and Java Scripting ASP, XML, HTML, C, and C++.
SOFTWARE: Windows 2000/2003/2008 Server, MS SQL Server 2000/2005/2008, Oracle 10g Cluster, DataGuard, RMAN, Electronic Patient Records (Axium and Mipacs), Windows 2000/3 Clusters, Tivoli Storage Manager.
EXPERIENCE:
FEB 2007 Lead Oracle DBA (Permanent)
TO
PRESENT Confidential
Environment: Windows 2000/2003/2008, SQL 2000/2005/2008, Oracle 10g, Oracle Grid Control, SQL Developer, RMAN, Oracle Real Application Cluster Failsafe, Microsoft Access 2003/07, IIS, Windows 2000/2003 Clusters, Electronic Patient Records, Axium, Mipacs, VMWare, Active Directory, Tivoli Storage Manager.
Responsible as project and technical lead for major Enterprise level database projects effecting the entire organization and departments.
Administering, installing, configuring, troubleshooting Oracle 10g databases on new as well as existing clusters/environments ensuring availability and performance of over 100 SQL and 15 Oracle databases.
Solely responsible for administration, management, problem resolution and troubleshooting for over one hundred databases.
Architect and project lead for Oracle 10g databases system servers by building, installing, setup, configuration, upgrade of databases servers and bringing it online into Production.
Windows 2003 clusters and infrastructure on SQL 2005 as well migration of all SQL 2000 databases to SQL 2005 for the entire organization.
Application and System administrator for Clinical Dental Branch Electronic Patient Record system running on Oracle 10g database and DICOM image server clusters.
Leading the database capacity planning and assisting in ensuring that the necessary associated hardware resources are allocated to the databases.
Performing performance tuning of the database systems, jobs, indexes, queries, configurations and using Oracle Grid Control.
Implementation of database and data architecture monitoring technologies and procedures and proactively monitor the database systems and resources to ensure secure, stable, high-performing services with minimum downtime.
Participating in the formulation and monitoring of policies, procedures and standards relating to database management, and working with the teams in the design and implementation of database security policies and integrity controls.
Server database environment, including evaluation and assessment of technologies, versions, concepts and strategies.
Implementing database backup and recovery technologies and procedures, as well as monitoring, testing and issue resolution.
Installation and configuration of SQL Server 2005/2008 databases on Windows 2003 Enterprise servers (32bit/64bit) in high availability environment, including reviewing, testing and implementing the database portion of third party software.
Recommending server configurations, disk capacity, RAID groups and LUNs setup.
Performing and setting up backup and recovery, resolving RMAN issues and performing all changes and maintenance of the databases, including rollouts and upgrades.
MARCH 2005 SQL DBA (Contract)
TO
FEB 2007 Confidential
Environment: Windows 2000/2003 Servers, .NET, VSS, PowerBuilder 9.0, RightAngle S4.0/8.0/8.3/8.4, SQL 2000/5, IIS, Active Directory, Citrix, IIS, SAP, PowerBuilder 9.0, Batch Scheduling.
Provided database administration and application support for Right Angle real time trading application on SQL 2000 and 2005 servers.
Provided build implementation, migration, configuration, release and operations support.
Implemented application upgrades, migrations, build executions, cycle testing and writing test plans.
Refreshed SQL test and QA environments with new SQL databases, running DTS packages, handling SQL security, backup and recovery, jobs and connectivity issues
Supported the overall IT control practices, remediation, action plan execution, QA, Production and systems certification.
Re-engineered and remediated efforts for SOX application environments.
SOX controls, maintenance of compliance initiatives and support of platforms and applications.
Directed and provided guidance in solutions for deployments, integration, testing, remediation and re-engineering efforts in Production.
Interfaced with prospective platform owners on IT control and risk management practices in support of test and QA processes.
Conducted sound analysis of the IT control environment, extracting and analyzing data from multiple sources and external counterparties to identify their needs/requirements and translating them into
Prospective business solutions and IT control practices via systems design, development, and testing.
FEB 2004 Application Support Analyst
TO
MARCH 2005 Confidential
Environment: Weblogic Portal 8.1.4, J2EE, Web Services, Windows 2000 Advanced Server, Solaris 5.8, Site Scope, Embarcadero DB Artisan, Wily Introscope, Sybase, Lotus Notes R5.
Duties included a combination of infrastructure and technical support, build implementation, capacity and monitoring planning and setup, configuration and release management, operate management for Global Credit Risk Management Portal and Loan MSM Calculator.
Wrote capacity and monitored plan for Loan MSM Calculator infrastructure.
Site Scope setup and administration for the entire infrastructure.
Implemented Weblogic, Windows and UNIX builds, executing SQL scripts for builds and releases.
Resolved events and incidents escalated from Client Service Delivery Analysts and Client Service Delivery Managers.
Documented infrastructure support procedures for senior level operations support.
Content management for Weblogic Portal, research of data content and business questions.
Worked with development teams to gather infrastructure requirements and assuring it’s preparedness for deployments.
Presented Metrics and Trend analysis in weekly status meetings.
Developed strong business partnership with Client Service Analysts, Application Developers and other technology infrastructure teams worldwide.
Recommended and implemented process flow and other improvements with management approval.
JULY 2003 Application Support Analyst (Contract)
TO
FEB 2004 Confidential
Environment: Windows 2000 Advanced Server, Windows 2000 Terminal and Cluster Servers, IBM AIX, SQL Server 2000, Oracle9i, EAI Webmethods 4x, SOAP, Web Services, CONTROL_M Batch Scheduling, NT Batch and VB Scripts and Java Scripts, SysAdmiral, ActiveXperts, Experian/Scorex Transact Credit System, JD EDWARDS, Info lease, Transact Extracts and Reporting tools.
Solely responsible for providing Application, Build, and infrastructure administration / support for an mission critical application called TRANSACT. An Experian/Scorex Credit management System integrated with DELL.COM and Credit Bureaus, responsible for bringing in $6 Billion / 80 percent of company’s total revenue.
Supported, administered and built EAI Webmethods infrastructure for entire DFS Architecture.
Provided production yields and progress reports to IT managers and business segment managers.
Lead implementation of code changes, software changes, batches as well installing and setting up the entire web based interface at new product’s launch.
Administered, supported, and installated of CONTROL_M and Sysadmiral batch schedules for different IT systems in the environment.
Installed, troubleshooting and executing Batch, Visual Basic, Java and Perl scripts using Active Xperts, CONTROL_M and Sysadmiral.
Implemented controls and solutions to improve production-processing ties.
Wrote production documentation and verifying that documentation is consistently updated and validated
by application owners prior to being presented to production staff for processing.
Worked closely with management to implement controls and solutions to improve production-processing times.
Monitored systems to ensure computer resources are available to all users according to production schedules.
Monitored and approved Remedy system change requests and work orders, which have a direct impact on the production processing or production, control areas and respond to those requests.
Organized and attended daily production meetings to discuss past problems and to coordinate upcoming production changes and then following up with the appropriate application owners.
Analyzed and tested/validated disaster recovery and contingency plans for Disaster Recovery and Backup and Restore procedures.
FEB 2001 Systems Analyst (Contract)
TO
JUN 2003 Confidential
Environment: Compaq DL360 Servers, Cisco Load Director, Windows 2000 Advanced Server, IIS, ASP, SAP, Oracle, SQL Server 2000, WebTrends, Visual Source Safe.
Managed 30 W2K Advanced servers running Epiphany 5.5/6/0 application servers.
Worked and participated in a two million dollar SAP “Product ID” project to bring custom serial number functionality into the Compaq’s web based systems.
Managed EDI projects and handling test and execution activities for Compaq Epiphany based projects.
Lead the upgrade on the entire e-commerce CRM suite to new Epiphany IP version 5.5.3.
Using “Site Scope” to continuously monitor performance and testing of a company\'s business critical
distributed systems—including Enterprise server resources, page downloads, times, errors per second, rejected requests from the application server and the availability of network services.
Set up test environment, unit, functionality, system, and regression testing using test matrixes in the client/server environment.
Managed and organized testing efforts, including production of test cases and scripts.
Managed priorities, working with limited assistance and supervision to complete assigned tasks on time.
Drove testing efforts with superior communication and leadership skills to include all systems, acceptance and integration test cycles.
Wrote and compiled thorough and detailed documentation and test scripts, in an efficient manner to meet aggressive deadlines.
Independent management and monitoring of the data network environment utilizing various network management tools and languages such as Sitescope, SQL, VSS, SAP, ASP, and XML DOM.
Managed project scheduling tasks, leading operations meetings, scheduling releases, and build plans.
Created and executed User Acceptance Test scripts for Product ID implementation and builds.
Facilitated and lead Pre/Post ITG and PRO build, by acting as a project coordinator and liaison between the user community and the Systems group.
Developed testing strategy based on available business and technical use cases and participated in quality assurance reviews.
FEB 1999 Unix Production Analyst
TO
FEB 2001 Confidentia
Environment: HP UNIX N and V Class Servers, EMC Data Manager, HP Openview OMNIBACK II, Windows 2000 Advanced Server, Lawson Business Management Software.
Software and patch installation, configuration, adding and deleting user accounts on HP UNIX 9000 V and N class and Solaris servers.
Analyzed scripts in Development for testing and in Production for their integrity with the log-files and disk usage.
Monitored system, basic UNIX scripting, ensured Batch Processing and disk management.
Performing IPL’S, restoring and restarting Databases (Oracle and Sybase) and other corporate wide applications as needed.
Distributed Storage Management, backing up and recovery services activities of UNIX file systems, payroll data on DLT tapes properly using Robotic Mass Storage media such as HP OPENVIEW OMNIBACK II and EMC.
Ran company’s entire payroll self-handedly using Lawson Business Management Systems software.