Rbac Dba Resume
Richardson, TX
SUMMARY
To be a valuable asset, in the areas of application, database, and system design / development, and database administration, to a forward looking, dynamic team, developing systems that satisfy end - user requirements and objectives, with minimum risks and maximum returns.
PROFESSIONAL EXPERIENCE
Confidential, Richardson, TX
RBAC DBA
Responsibilities:
- Enroll Users and systems in a Security System (IBM Tivoli Id Manager), via in-house applications.
- Remediate Problems by interacting with The Operational DBA's and the Application DBA's, as well as the Subject Matter Experts.
- Developing strategies to train the DBA's in the installation of the security systems.
- Mitigating installation problems occurring from incomplete and / or erroneous systems preparation.
- Reporting of significant problem(s) on a weekly basis (via an Access database system).
Confidential, Westlake, TX
Sr. Oracle DBA
Responsibilities:
- Production Support DBA for enterprise level Oracle systems up to 6TB in size.
- RMAN Backups and Restore.
- DataGuard for disaster recovery systems.
- Proactive monitoring using OEM and scripts.
- Participate in role based security design for use access.
- Performance tuning of the systems and application code.
- 24 X 7 X 365 support for 27 Oracle Databases running on AIX
Confidential, Irving, TX
Sr. Oracle DBA
Responsibilities:
- Production Support DBA for enterprise level Oracle systems.
- RMAN Backups and Restore.
- Proactive/reactive monitoring using OEM/Grid.
- Performance tuning of the database systems.
- Participated in role based security design for user access.
- Installation and buildout of development, UAT and production systems.
Confidential, Allen, TX
Sr. Oracle DBA
Responsibilities:
- Production Support DBA for enterprise level Oracle systems, including design, remediation, and analysis of Oracle 10g/11 gR2 multi-server environment.
- RMAN Backups and Restore
- Participate in role based security design for user access.
- Shell Scripting including (korn, cshell)
- Performed disaster recovery and backup procedures.
- Performed system process and performance monitoring, including implementing stored procedures and scripts for system maintenance.
- Collaborated with appropriate groups to ensure that database systems meet business requirements.
Confidential, Euless, TX
Sr. Oracle DBA
Responsibilities:
- ETL of data from the member Medical Boards
- Data loading using Oracle SQL*Loader.
- Transformations utilizing SQL and PL/SQL Scripting.
- Data remediation / correction / loading of incoming data streams.
- SQL and PL/SQL development and tuning.
Confidential, Chase Dallas, TX VP,
Database Management Lead
Responsibilities:
- Maintenance, backup and monitoring of several sets of Oracle databases; production, QA, test and development instances (versions 8i through 10g, including RAC and managed standby, Dataguard and SRDF/a).
- Provide second level support for client problems and services.
- Primary DBA for several systems and backup DBA for several more (up to 15TB in size).
- Cloning of data between production, QA and development instances, running on UNIX (AIX and Solaris), including performance metrics (OEM and Grid) and tuning (database and SQL - PL/SQL).
- Hands on experience with Oracle Grid Control, configured to centralize management all of RAC instances.
- Deployment of the Sybase plugin to centralize management of both databases.
- Implementation of Oracle DataGuard and SRDF/a for standby databases.
- Optimizing performance tuning in database, SQL and server levels. Solid experience with Oracle Statspack and SQLTrace / TKProf.
- Upgrade / patching of database versions (production, test, QA and development.
- Backup of production, QA and test databases (250MB - 10TB) with RMAN and NetBackup, utilizing level 0 and level 1 backup strategies, as necessary for limited space requirements.
Confidential, Garland, TX
Sr. DBA
Responsibilities:
- Enterprise SAN Architecture (system and database), design and prototyping of an extremely large, multi-node, RAC, hybrid System (information classified) and managed standby clusters, including encryption capabilities.
- Implementation and maintenance of several (design) support systems and databases.
- Participate in role based security design for user access.
Confidential, Chase Dallas, TX
Sr. DBA
Responsibilities:
- Maintenance and monitoring of several (22) databases; production, QA, test and development instances (versions 7.3.4 through 9i, including RAC and managed standby) in the Solaris environment.
- Participate in role based security design for user access.
- Second level support for client problems and services.
- Responsible for all change control on these databases.
- Confidential ransfer of DB's via NetApps / NAS (corp - corp)
Confidential, Plano, TX
Logical (designer) DBA
Responsibilities:
- Design, implement, and support high performance, mission critical Oracle databases and application systems.
- Re-engineering of existing systems and migration of DB2 systems to the Oracle / UNIX environment.
- Participate in role based security design for user access.
- Production / development DBA (production DB support and on-call, as well as development and test). Support of development (JAVA / J2EE) Staff.
- Business analysis, architecture, design and implementation / support of several add-on systems to expand and support the current production systems (full SDLC), using Oracle Designer and ERWin. Data Warehouse, ETL support.
Confidential, Gloucester, MA
Oracle DBA/Business Analyst
Responsibilities:
- Review of current documentation.
- Participate in role based security design for user access.
- Business Analysis and BPE/BPR of existing systems.
- Layout of production databases to enhance performance and maintainability.
- Database design and consulting.3
Confidential, San Antonio, TX
DBA
Responsibilities:
- Upgrades of Oracle databases and tools.
- Layout of production databases to enhance performance, reliability and maintainability.
- Performance tuning, periodic database healthchecks.
Confidential, Irving, TX
ield Support - Senior Systems Engineering Specialist
Responsibilities:
- Designed, implemented, and was the DBA, for systems to monitor and track customer hardware / software configurations (Oracle Designer / Developer / Data Warehouse Builder)
- Customer support requirements definition.
- Proactively supplied customers with information to avoid problems with Oracle products.
- Participate heavily with role based security design for user access.
- Managed several premium support accounts
- Lifecycle Support - Senior Solutions Support Analyst
- Direct support of Oracle LifeCycle Customers, via telephone and on-site.
- Research and supply customers with fixes for critical problems.
- Proactively research customer needs and requirements, and provide recommendations.
- Support Areas included installation / patching / upgrade / migration / DBA (versions 6 / 7 / 8 / 8i / 9i); OPS / RAC; Developer (reports and forms, versions 3.0 / 4 / 5 / 6 / 6i / 9i); Designer (versions 3 / 6 / 6i / 9i / 10g); Performance Tuning (database and application / SQL); on VMS, UNIX and NT systems.
Confidential, Southern,California
Independent Contractor
Responsibilities:
- Database Administration, analysis and design of customer application systems and database requirements, including strategic and detailed documentation.
- Designed and developed several VLDB systems for customer field support and remanufacturing systems, including the databases and the applications themselves (Oracle Forms and Reports).
- Developed several large databases for various customers, including user interfaces and stored procedures (API’s).
- Oracle Designer and Developer were used as the CASE and development tools.
- Senior DBA and Business Analyst for these projects.
- Implemented Real Time database applications.
- Database Administration (general production DBA duties)
- Implemented training courses for end-users.
- Business Analysis / BPR / BPE
- Software / System QA
- Project Management
- CASE Tools (Oracle*CASE/Designer, ERWin, SilveRun, GoldRun, KnowledgeWare, IEF).
- Data Warehousing.
- Client Projects Included:
- Manufacturing, repair, and refurbishment / remanufacturing of complex equipment, including data warehousing of detailed information, and ETL from non-Oracle data sources (full SDLC)
- Design and creation of a professional license application, renewal, and tracking (State government)., including Project Management
- Automated catalogue / document generation (Services pricing / labor, estimating, etc).
- Automated traffic and toll collection systems (Toll TAG).
- Financial systems (Brokerage).
- Technical document tracking / synopsis generation.
Confidential, San Diego, CA
Senior Development Engineer
Responsibilities:
- Developed Database and Artificial Intelligence Systems to support R&D and manufacturing operations,and automation (in the US and Canada). DBA for all systems.
- Business Analysis and Application development with CASE tools (Oracle, KnowledgeWare, IEF).
- Acted as a liaison with the end-user community.
- Oracle DBA (V4, V5, and V6) / Developer (Forms 2.3 & 3.0 / Reports 1 .x)
- Factory floor / data collection automation.
- Manufacturing process simulation (utilizing SimScript, SIMAN, and SimFactory).
Confidential, Lowell, MA
Principal Logistics Engineer
Responsibilities:
- Responsible for all software / hardware automation and logistical systems.
- Conversion of complex software across operating systems and languages.
- Complete rewrite of the Fortran Complex Subroutine Library.