Dba Architect Resume
5.00/5 (Submit Your Rating)
VirginiA
EMPLOYMENT HISTORY:
Confidential, Virginia
DBA Architect
Responsibilities:
- Conducts workshops to identify customer requirement
- Design/document/implement new systems based on customer requirements
- Create design and build documents for offshore team implementation, including flow charts, ERD diagrams, database designs, table structure, SQL executions paths, security model, and application interface techniques to the database.
- Design and document physical implementation of database systems including Backup/Recovery, Disaster recovery, performance design and operational procedures.
- Create and maintain operational procedures and code to perform database tasks in a controlled and consistent manner.
- Lead disaster recovery and backup and recovery exercises of the Oracle databases/Exalog/Exadata environments.
- MongoDB 3.2/3.4 support including replica sets, data sharding,, partitioning, CRUD operations
- Map SQL to MongoDB
- Configure Mongo Geospatial and create Geospatial queries
- Disaster recovery including Data Guard, Active Data Guard, RMAN, ZFS replication, EMC replication, ASM disk mirroring, distributed Oracle RAC clusters, NFS mirroring, data sharding, DNS, OID, LDAP
- Physical and Logical data model creation of schemas utilizing ERWIN ModelMart, TOAD, and SQL Developer. Convert logical models to physical models. Create logical star schema data warehouse design. Create and modify relational OLTP models to support high throughput and data integrity.
- Model schemas based on manufacturing and process data sources
- Create linear models in R(RStudio), data factoring
- Configure Oracle database vault, audit vault solution, fine grain auditing(FGA)
- Extensive database auditing to FBI CJIS CAPP requirements
- Implement/integrate CyberArk into various databases including Oracle,DB2, MySQL, and Sybase
- Extensive CyberArk installation/configuration/troubleshooting experience.
- Install/configure/support Oracle Audit Vault/Database Vault, and fine grained auditing.
- Configure Database Vault reporting for senior management
- Configure Oracle OEM Database Vault console
- Usage of Database Vault administrator(DVA) and database vault configuration assistant(DVCA)
- Upgrade Audit Vault from 11.2.0.4 to 12.2.0.1
- Configure security for Oracle consolidated databases and separation of duties, monitor privileged users/dbas
- Deploy audit vault java agents
- Wrote Oracle audit vault upgrade and deployment procedures for Federal Reserve
- Use of DBMS MACADM and DVSYS PL/SQL procedures
- Deploy Audit Vault agents
- Configure Database Vault Oracle label security per business requirements
- Configure security per Sarbanes - Oxley Section 302, Sarbanes-Oxley Section 404, Sarbanes-Oxley Section 409
- Concept and practical experience with layered security (security in-depth).
- ‘Harden’ Oracle database by changing default passwords, and utilize password file.
- Migrate Oracle 11g standalone to Oracle 12c RAC database.
- Migrate multiple standalone databases to Oracle 12c RAC container databases.
- Configure Oracle ASO(Advanced security options)
- Integrate Oracle ASO with Oracle Audit Vault and Database firewall.
- Install/configure/support Oracle Security Suite.
- Apply Oracle 12c best practices including container databases, in memory column store, zone maps, FIPS 140 encryption, etc.
- Configure operating system/database for SOX compliance and FIPS 140-2 compliance.
- Oracle database development including writing trigger, procedures, functions, views, and packages. Emphasis on efficient coding techniques for large databases.
- MS SQL T-SQL programming including triggers, tables, indexes, partitioning.
- Configure and support Oracle streams.
- Create application test plans to test functionality, performance, and reliability
- Performance tune new and existing databases including disk configuration, kernel parameters, and database initialization parameters.
- Create custom PL/SQL applications
- Create PL/SQL APIs for database access, but input and output of data to web based applications.
- Install/configure/support Oracle Fusion Middleware
- Migrate Oracle 11g databases to Oracle 12c RAC and supercluster
- Create projects plans off tasks and milestones for database based system implementations.
- Configure/Support Oracle Supercluster M7
- Work with Oracle advanced support for supercluster on hardware issue resolution.
- Configure/Optimize Oracle supercluster components including flash storage, ZFS storage, and Supercluster parameters
- Apply supercluster quarterly patches
- Resolve performance/scalability issues related to supercluster configuration.
- Upgrade Oracle databases from 11g to Oracle 12c(pluggable)
- Conduct analysis of database health including AWR reports, OS level logging, orachk, ADDM
- Configure/tune system and database memory sizing to eliminate waits
- Review database performance including database growth, table and indexes, long running sqls, partitioning of large database objects, partitioned indexes, materialized views.
- Review and tune Unix kernel parameters for optimal database performance
- Architect new database installation and review existing installations for optimal performance and availability
- Configure security policies to prevent data access other than through client application.
- Restrict administration access to clients connected to local client network.
- Architect/Install/configure/support Oracle/DB2/MySql/Sybase disaster recovery.
- Configure Oracle ZFS storage, storage level disaster recovery, replication.
- Security infrastructure management tools, security architecture design and implementation.
- Architect Database Solutions
- Extensive experience with CyberArk's security products such as Enterprise Password Vault, Privileged Identity Management, Application Identity Management including design and implementation of Disaster Recovery hot-site and development of the BCP plans using LDRPS.
- Design and implementation of Microsoft Public Key Infrastructure (ADCS) using X.509 standard, encryption technologies, SSL, Code-Signing and User certificates.
- Implementation of NDES/SCEP (for Non-AD devices) using Symantec Mobile Management.
- Analyze migration related performance issues, plan changes, bugs, init parameter changes.
- Use DDDAUDIT, SYSAUDIT reports to resolve database internal consistency issues.
- Utilize Grid control/CloudControl and Oracle Enterprise Manager, emcli interface.
- Implement LOB storage solutions for large LOBS to facilitate improved performance.
- Implement global/local partitioned indexes.
- Rewrite load/etl/batch processes to support large data volumes using best practices coding techniques.
- Performance RAC container database issues, poorly performing SQL, data dictionary lookups.
- Upgrade Oracle RAC ODA(Oracle Database Appliance)
- Create OEM dashboards and alerts.
- Architect dual 20 node RAC clusters for 39 million user cable system.
- Lead operational/development teams to overcome technical issues and meet project deadlines.
- Configure backup and recovery of Oracle Exadata/Exalogic 11g/12c databases and Oracle non-exadata databases utilizing RMAN and cold backups.
- Install Oracle Enterprise Linux servers, Sun Solaris, AIX, configure kernel parameters, configure NTP, configure network bonding, configure networking parameters, etc.
- Create yum repository for Oracle enterprise linux environment.
- Troubleshoot Oracle RAC/Exadata/Exalogic/ASM/Storage issues.
- Apply Oracle 12c database features to improve performance of Oracle applications and Peoplesoft.
- Configure application monitoring using OEM and EMOC.
- Knowledgeable on database configuration and optimization from physical layer(EMC, Oracle ZFS) through SAN, ASM instance, and database buffer cache.
- Create Exalogic Guest VMs manually, and using templates.
- Configure Infiniband switches, Cell disks and grid disks on the Exadata compute nodes.
- Provide production support of issues from application errors, performance, system lockups, process scheduler issues, etc.
- Code and support code changes. Providing general application support and specific support of customizations.
- Installed software include server builds from the ground up on Redhat Linux. OS Install, kernel tuning, database 11GR2 3 Node RAC install, OVM installation and configuration, Peopletools(2-tier and 3-tier), Peoplesoft HRMS, etc.
- Oracle database development including writing trigger, procedures, functions, views, and packages. Emphasis on efficient coding techniques for large databases.
- Install/configure/support Oracle Goldengate data replication. Resolve replication conflicts.
- Upgrade Oracle Goldengate from 11g to 12c
- Configure Goldengate replication from Oracle to Oracle(Bi-Directional), Oracle to Teradata, AS/400 to Oracle, including integrated replication and utilizing central log server
- Migrate Peoplesoft environment from Milwaukee data center to Jacksonville datacenter. Scripted environment migration to be performed over a weekend. Migrated approximately 5 TB of data.
- Install/configure/support high availability, high volume 24/7 databases with 1000 users.
- Troubleshoot server availability issues, apply PSU patches, configure RAC network interfaces and performance parameters.
- Performance tune using explain plans, stats pack, AWR Reports, etc. Tune as appropriate.
- Installed software include server builds from the ground up on Redhat Linux. OS Install, kernel tuning, database 11GR2 3 Node RAC install, OVM installation and configuration, Peopletools, Peoplesoft HRMS, etc.
- Installation/configuration of Oracle 12c, Cloud Control(formerly grid control).
- Indepth RAC and Oracle database knowledge.
- Perform database maintenance index rebuilds, stats gathering, AWR reports, etc.
- Install/configure/support Oracle dataguard deployment in remote data center for disaster recovery purposes.
- Utilize imp/exp, datapump, RMAN, and Oracle Dataguard for disaster recovery. and backup/recovery.
- Configure and support Tivoli TSM integration to the Oracle Exadata, Exalogics, and Exalytics platform.
- Troubleshoot Redhat kernel panics, NIC configuration issues, network topology issues, and SAN performance issues.
- Deploy high availability solution utilizing Oracle RAC and configure application for transparent application failover.
- Configured database to support additional acquisitions and increasing user base.
- Performance tune poorly performing SQL.
- Error resolution and performance tuning. Resolve database and application related errors.
- Installation/configuration Oracle Data Integrator, ETL mappings creation.
- Write and troubleshoot Unix and shell scripting issues.
- Install/configure/support Oracle Identity management solution, provision and load OIM data.
- Encrypt data in transit and at rest using Oracle ASO.
- Implement SSO(Single Sign on)
- Install/configure/support Oracle database/audit vault database and application auditing solution.
- Secure systems to FIPS 140-2 processing standards.
- Create and support SQR reports. Performance tune long running reports both in the database and the report code.
- Write and debug shell scripts for Solaris,, Linux, AIX, HP-UX, and Oracle Enterprise Linux.
- Install configure support MySQL, PHP and Apache stack.
- Oracle Database Tuning and Performance - usage of statspack, AWR, ADDM, ASH and UNIX native commands
Confidential
Lead DBA/Developer
Responsibilities:
- Extensive experience with CyberArk's security products such as Enterprise Password Vault, Privileged Identity Management, Application Identity Management including design and implementation of Disaster Recovery hot-site and development of the BCP plans using LDRPS.
- Design and implementation of Microsoft Public Key Infrastructure (ADCS) using X.509 standard, encryption technologies, SSL, Code-Signing and User certificates.
- Implementation of NDES/SCEP (for Non-AD devices) using Symantec Mobile Management.
- Implement/integrate CyberArk into various databases including Oracle,DB2, MySQL, and Sybase
- Extensive CyberArk installation/configuration/troubleshooting experience.
- Concept and practical experience with layered security (security in-depth).
- ‘Harden’ Oracle database by changing default passwords, and utilize password file.
- Internet Architecture, application and web server configuration.
- Perform database maintenance index rebuilds, stats gathering, AWR reports, etc.
- Utilize Grid control and Oracle Enterprise Manager.
- Configure customer applications to run in Fusion Middleware.
- Troubleshoot application issues. Prepare application for production utilizing Loadrunner for load and technical testing.
- Upgrade Oracle RAC clusters, apply CPU/PSU patches and interim patches using OPatch
- Upgrade/Administer/Support Oracle ASM for Oracle RAC cluster. Configure RMAN backups and add/remove disks as required. Rebalanace ASM.
- Physical and Logical data model creation utilizing ERWIN ModelMart, TOAD, and SQL Developer. Convert logical models to physical models. Create logical star schema data warehouse design. Create and modify relational OLTP models to support high throughput and data integrity.
- Oracle database development including writing trigger, procedures, functions, views, and packages. Emphasis on efficient coding techniques for large databases.
- MS SQL T-SQL programming including triggers, tables, indexes, partitioning.
- Configure and support Oracle streams.
- Install/configure/support Peoplesoft 8 and 9 on Redhat Linux. Configure Peopletools. Configure security and create users.
- Develop ETL and dataload scripts utilizing data integrator and warehouse builder. Validate data integrity.
- Migrate Oracle databases to MySQL to support the Port security program.
- Convert PL/SQL to TSQL.
- Build new user interfaces in Oracle Forms and build reports in Oracle Reports.
- Upgrade existing forms and reports from 10g to 11g.
- Extensive C, C++, and PL/SQL, Forms coding experience.
- Provide application support to complex PL/SQL web applications running against Oracle databases.
- Resolve performance issues relating from long running queries on very large database, 50 TB plus with ~200 billion rows.
- Perform root cause analysis of performance issues.
- Maintain system reliability and stability.
- Unix shell scripting
- Configure and support Oracle streams and Golden gate replication, including streams heartbeat table and conflict resolution.
- Backup and recovery/disaster recovery utilizing rman and Oracle Dataguard.
- Install/configure/support Oracle Fusion middleware, including Enterprise User Security and Weblogic application server.
- Backup and recovery of database and weblogic server.
- Analyze current database architecture and configuration. Recommend new architecture to bring client systems up to current level of technology. Implement architectural improvements during upgrade and implementation.
- Install/configure/support Oracle 11G (11.1.0.7) production LINUX (Redhat) RAC cluster and Dataguard failover server.
- Configure dataguard environment for reporting.
- Configure remote listeners, and multiple listeners on multiple ports.
- Install/configure/support multiple terabyte MySQL 5 on Redhat Linux.
- Support ETL/SQL of multiple dimension datawarehouse running on DB2 iSeries. Maintain metadata repository.
- Configure connectivity from Oracle/ODBC to iSeries via DB2 Connect.
- Migrate file based data storage to RDBMS based data storage. Design schema, extract and load data from various sources including MySQL, DB2, Oracle, MS SQL Server, provide GUI interface for data mapping.
- Implement Oracle Identity Management 11G Enterprise User Security. Including Oracle Internet Directory. Oracle Identity Federation, Oracle Virtual Directory, to allow single sign-on from Oracle clients to authenticate against active directory or OID.
- PL/SQL custom programming to process biometric data. Including extracting and storing the data in the database, retrieval and indexing.
- Implement Oracle FIPS 140-2 compliant data encryption of data at rest. Including wallet management and backup and recovery of encrypted data.
- Implement Oracle FIPS 140-2 compliant data encryption of data in transit utilizing AES256 encryption and Oracle ASO.
- Extensive database auditing to FBI CJIS CAPP requirements.
- Install/configure/support Oracle 10GR2 Environment on Windows 2003 and Redhat Linux. Including new 10g features of ASM, data pump, standby database using log shipping, and Grid Control. Perform backup and recovery, performance tuning, and issue resolution.
- Install/configure/support Oracle 10GR2 OEM Grid Control. Integrate grid control into Tivoli management solution. Integrate RMAN backups into HP backup technology.
- Upgrade 32bit Oracle Windows RAC cluster to 64bit Oracle Windows RAC cluster with less than 30 minutes downtime.
- Analyze and correct Oracle RAC cluster interconnect latency and performance issues.
- Create custom developed PL/SQL data loads utilizing SQLLDR and PL/SQL using cursors, stored procedures, etc. Troubleshoot and performance tune PL/SQL code base.
- Implement DR solution utilizing HP disk mirroring and Oracle RAC cluster. Ensure minimal data loss and recoverability.
- Support Star Schema and Relational database designs. Assist application developers with data normalization and schema design.
- Error resolution and performance tuning. Resolve database and application related errors.
- Create code migration processes.
- Create new databases and provide database access as needed.
- Provide 24 hr support/troubleshooting to new application installations.
- Create and assist the organization with implementing best practices documents.
- Architect and troubleshoot distributed database applications utilizing PL/SQL, TSQL and C.
- DBA activity including capacity planning, disaster recovery, performance planning, performance tuning and backup and recovery.
Confidential
DBA Consultant
Responsibilities:
- Analyze current database architecture and configuration. Recommend new architecture to bring client systems up to current level of technology. Implement architectural improvements during upgrade and implementation.
- Install/configure/support Peopletools, Financials, HRMS and process scheduler.
- Upgrade Peopletools versions.
- Create process scheduler and Peoplesoft application startup/shutdown scripts to recycle the environment weekly.
- Configure Peoplesoft load balancing.
- Implemented Peoplesoft password strategy.
- Create Peoplesoft load cache and shared cache.
- Install/support Oracle ASO(Advanced Security Option) and Transparent data encryption.
- Strong Peopletools skills, including application designer, App Engine code, datamover, Peoplesoft Internet Architecture, application and web server configuration.
- Upgrade Peoplesoft and perform data conversion from earlier version.
- Perform system health check of database systems maintained by off-shore personnel. Recommend improvements and assist with off-shore personnel implementing improvements.
- Analyze system performance and tune database running SAP. Analyze and improve ABAP code. Tune SQL execution plans. Optimize network communication.
- Upgrade 60 TB database from Oracle 9i standalone database to Oracle 10gR2 clustered database. RAC enable Oracle E-Business Suite. Convert database to ASM. Resolve performance issues.
- Install/configure/support Oracle E-Business Suite. Install patches, tune concurrent managers. Analyze performance issues, code PL/SQL extensions. Troubleshoot application issues via Oracle SRs.
- Configure and support Oracle streams, including heartbeat table, replication conflicts and replication tuning.
- Configure multiple listeners on multiple ports and configure remote listeners.
- Resolve database issues experienced by both developers and end-users.
- Oracle Discoverer 10g, Oracle Reports reporting against Oracle 10G database utilizing OLAP cube technology.
- Analyze and implement additional reporting requirements utilizing Business Objects. Recommend architectural reporting changes for optimal performance in extremely large dataset.
- Create custom developed PL/SQL data loads utilizing SQLLDR and PL/SQL using cursors, stored procedures, etc. Troubleshoot and performance tune PL/SQL code base.
- Assist client with implementing new Microsoft server and reporting technology.
- Analyze project requirements and recommend technology solutions to meet the requirements.
- Resolve database issues experienced by both developers and end-users.
- Strong SQL server troubleshooting and functional experience. Including troubleshooting performance issues and database faults caused by hardware problems and software bugs
- Install/support multi-terabyte MS SQL Server Clusters/replication.
- Configuration of database maintenance plans, reorgs, and monitoring.
- Create new databases and provide database access as needed.
- Provide 24 hr support/troubleshooting to new application installations.
- Assist application developer teams with application design and database issues. Convert logical models to physical design.
- Analyze and recommend informatica ETL technology solutions for large 3 TB transactions data warehouse.
- Support Star Schema and Relational database designs. Assist application developers with data normalization and schema design.
- Analyze and recommend reporting solution for 3 TB data warehouse.
- Assist ETL developers write ETL transformations using Informatica.
- DBA activity including capacity planning, disaster recovery, performance planning, performance tuning and backup and recovery.
- Install/configure/support Oracle backup and recovery(rman) and disaster recovery(dataguard) solutions.
Confidential
Lead Database Analyst
Responsibilities:
- Install/configure/support Oracle 10G Cluster. Including new 10g features of ASM, datapump, standby database using log shipping, and Grid Control. Perform backup and recovery, performance tuning, and issue resolution.
- Strong skills in implementing database upgrades and planning new implementations.
- Utilize new Oracle data warehousing features of list partitioning, data compression, bitmap join indexes, materialized views, etc.
- Upgraded data warehouse from Oracle 9I on IBM RS6000 to Oracle 10g Redhat EE LINUX cluster of very large 3 TB+ database.
- LINUX OS issue resolution, kernel tuning as related to database performance.
- Data extraction, loading, and transformation of data from relational source systems to data mart utilizing customer written PL/SQL, SQLLDR and Informatica ETL tool. Use of materialized views for data replication and performance tuning.
- Wrote and support ETL process between Oracle and DB2 on AS/400 utilizing oracle heterogeneous services connectivity to load DB2 transactional data to Oracle data warehouse.
- Oracle database development including writing trigger, procedures, functions, views, and packages. Emphasis on efficient coding techniques for large databases.
- Major emphasis on issue resolution and performance tuning of large database via utilizing Oracle performance tuning database changes such as partitioning, join-tuning, appropriate indexing and memory sizing.
- Oracle clustering on Sun Solaris utilizing Veritas clustering file system.
- Support Database environment running Oracle J2EE and client server connections.
Confidential
Leader Decision Support Systems Team
Responsibilities:
- Data extraction, loading, and transformation of data from relational source systems to data mart utilizing customer written PL/SQL and Data stage ETL tool.
- Responsible for system performance tuning and design of large 2 TB plus databases.
- Build and support client applications in Oracle Forms, PowerBuilder, and Dreamweaver
- Support invoice scanning applications utilizing the MS SQL Server database and Readsoft application.
- Upgraded Data warehouse environment from Oracle 8.1.7.4 to Oracle 9.2.0.4.
- Implemented new features of Oracle 9i including data compression, index compression, and clustering.
- Strong UNIX/Windows Server and Database talent.
- Responsibilities include application coding and design, performance tuning, backup and recovery, and database and UNIX system troubleshooting.
- Provide support of Windows NT based DB2 databases utilized for MQ message transfer.
- Experienced with Oracle Enterprise Manger, Toad, and Developer 2000.
- Upgraded 1500 user Business Objects reporting environment from 5.1.7 to 6.1, performed new Universe Development, Business Objects Administration, Report writing, and assisted report developers with advanced technical issues. Configured/supported and developed reports using Web Intelligence and Business Objects ZABO client.
- Designed/built Contribution Analysis Mart that allowed commercial sales representatives to be paid by profitability of sales rather than gross sales. Winner of Best Architected Datawarehouse from the Data Warehouse Institute.
Confidential
Lead Database Analyst
Responsibilities:
- Led database technical effort of new implementation of IMI order Management System. 30 Million + project to consolidate two order management systems to one. Project included extensive database performance tuning and design tuning.
- Upgraded IMI 500+ user production order management system from Oracle 8i to Oracle 9i.
- Led team of three junior DBAs. Verified correct backup and recovery, system maintenance procedures followed.
- Performed health checks on SW systems and reviewed success of implemented changes.
- Responsible for performance tuning/backup and recovery of 1.5 TB plus data warehouse environment.
- Implemented Oracle 8i databases to support Ecommerce initiative of IPNET application and Gentran application.
- Responsibilities included datamart design and ETL development in PL/SQL and Datastage.
- Support Document management systems running on MS SQL Server.
Confidential
Database/Baan Administrator
Responsibilities:
- Lead DBA of 1500+ user BaanERP Oracle 8.0.5 database.
- Responsible for backup and recovery, performance tuning, problem troubleshooting.
- Clustered HP V2500 environment.
- Rewrote XIP xray machine development application in Oracle Developer 2000. Received company award for this work.
- Architected and implemented four cluster service guard cluster to support high availability.