We provide IT Staff Augmentation Services!

Sr. Database Administrator Resume

SUMMARY:

  • Confidential is a Sr. Systems Architect / DBA with over 20 years of progressive experience in providing database solutions for fortune 10 clients.
  • He is a self - motivated, efficient and highly technical with 16+ years hands-on experience in 'process' and 'data' modeling areas, data definition (meta-data), database performance tuning, administration -- all within large databases with high transaction volumes and other data management skills. He is a well-organized, result-oriented professional with proven record to implement new features within GoldenGate Replication with multi-terabyte size databases.
  • As an Oracle Certified Professional (OCP-11g/10g/9i/8i/7x/6x), Confidential is a SME of Oracle RDBMS 6x-12c. Passion for Oracle Technology has resulted in an in-depth knowledge of database internals and data structures - this also has enabled Confidential to be a mentor and present papers at local Confidential groups as well as at Confidential .
  • With measurable deliveries, Confidential has 24x7 production environment experience in multiple Data Warehouse, Oracle Cloud, Data Marts, Data Governance, ETL, BI, Data Migration and Application Integration, Process Integration, Collaborative Solutions, Content Management and Web Solutions.
  • He is skilled, efficient, competent, and conscientious -able to prioritize tasks, mentors junior team members and delegates responsibilities to meet project deadlines. Confidential possesses imaginative abstract reasoning and couples it with an excellent ability for logical and analytical thinking to rapidly arrive at effective solutions in a problem-solving environment. Interacts effectively with senior management and possess excellent facilitation, presentation and communication skills.

FUNCTIONAL AREAS OF EXPERTISE:

  • Oracle GoldenGate Replication 12c
  • Oracle Virtual Private Database (VPD)
  • Systems Analysis & Design
  • Solution Architect
  • Oracle Security Policies / Oracle Audit Vault
  • Relational Database Design
  • Data Warehouse Design
  • Data Architecture / RAC / Oracle Dataguard
  • Performance Tuning / AWR
  • Database Administration / OEM
  • ETL (Extract / Transform & Load) Applications
  • Data Scientist

TECHNOLOGY EXPERTISE:

Databases / DB Tools: Oracle 12c/11gR2/10g/9i/8i/7.x/6.x, RAC, ASM, Advanced Data Compression (ADC), Oracle Flashback/Flash RecoveryOracle Streams, Oracle Dataguard, Stats Pack, MySQL 4.x, TOAD, ODBC, SQL Server 2005/2008, Confidential DB2, Sybase System 12.5/11/10 and MS Access

ETL Tools: Oracle GoldenGate 11g/12c, Oracle Data Pump, Data Modeling DBArtisan 8x, ER/Studio 7.1, Oracle Designer/2000, ERWIN 4/7, Informatica 7.2/8, SQL Server DTS, UNIX Shell Scripts.

Application Development Tools: Oracle Enterprise Manager- OEM 12c/11g, JDBC, Weblogic, PowerBuilder 7.x/6.x, Visual Basic 6, E-R Studio, Crystal Reports 8, CGI and PERL, Virtual SourceSafe 6, PVCS, VSS

Application Package: OBIEE Oracle BI server, Oracle BI Answers, BI interactive Dashboards and Oracle BI Publisher, Oracle10g/9i Application Server, ERP/MRP II

Desktop Tools: Adobe Acrobat, MS Office, MS Project, Visio, MS Project 98, ABT Project Workbench V4.0

Methodologies / Techniques: All phases of SDLC. Booch, Function Point Analysis, Jacobson - OO Methodology, Rational Unified Process, SSAD, UML, Rational (Rose, ClearCase, ClearQuest)

Operating Systems: HP/UX, UNIX, Confidential -z/OS, Windows NT Server, Confidential -AIX

Programming Languages/Utilities: Shell Scripting, Sql*Plus, Pl/Sql, Oracle Command Line Interface, VB Script, XML/XSL, HTML, Java, JUnit, Transact-SQL, DB2 SQL, TAL, PRO*C, Debugger, FTP, HTTP

Benchmark/Testing/Config. Mgmt.: Measureware, Unix-Glance, JRun, winCVS, JIRA, SubVersion.Other Technical Architect, documentation and quality assurance.

SKILL SUMMARY:

  • Experience as a DBA 18 yrs
  • Experience as a Database Architect 15 yrs
  • Experience as Lead of a Database Team 9 yrs
  • Experience as an Oracle DBA 15 yrs
  • Experience as an SQL Server DBA 5 yrs
  • Experience as a DBA supporting development teams 14 yrs
  • Experience as an Oracle Goldegate DBA - 11g/12c 2 yr
  • Experience as an Oracle DBA - 12c 3 yr
  • Experience as an Oracle DBA - 11g (R2 = 4 yrs) 7 yrs
  • Experience using Oracle Security Policies / Oracle Database Vault 2 yrs
  • Experience and expertise in data modeling and database design 12 yrs
  • Experience creating, maintaining, updating database documentation 12 yrs
  • Experience in full life cycle development of applications. 15 yrs
  • Experience with Oracle backup and recovery 3 yrs
  • Experience with disaster recovery, monitoring & troubleshooting 3 yrs
  • Experience writing and debugging complex PL/SQL procedures and packages 10 yrs
  • Experience designing backup solutions using RMAN. 2 yrs
  • Experience with Records Management System data migrations 6 yrs
  • Experience with data warehouse business intelligence projects 6 yrs
  • Experience as a project manager leading a DBA team 4 yrs
  • Experience with building and maintaining data warehouses 8 yrs
  • Experience working with Oracle in a Microsoft Environment 4 yrs
  • Experience with local/state government projects 8 yrs
  • Experience with Informatica ETL as Data Warehousing solutions 8 yrs
  • Oracle Certified Professional 9g by Oracle Corporation 8 yrs
  • Oracle Certified Professional 10g or 11g by Oracle Corporation 5 yrs

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Database Administrator

Responsibilities:

  • Research into problems with existing application design and develop long term solutions. Work with sponsors/business to ensure future requirements are understood, architected and achievable.
  • Responsible for Planning, Analysis, Design, and Implementation of Infrastructure components for an Enterprise Operational Data Store (ODS) and Data Warehouse (EDW).
  • Analyze detail systems factors: input/output requirements, information flow, hardware and software requirements, alternative approaches, etc
  • Analyze problems. propose alternative solutions and criteria that allow deciding on which approach to take, and proceed with the most optimal choice
  • Oracle database performance tuning and optimization
  • Monitoring and maintenance of many Oracle databases and instances (version 8 through 12c).
  • Worked with end users and Oracle Support in resolving application and database issues.
  • Performed Oracle system performance monitoring and advised on necessary adjustments.
  • Troubleshoot Problems.
  • Real Application Cluster (RAC)
  • Advanced Storage Management (ASM)
  • Materialized views and replicating data
  • Managing the Storage parameters for the tablespace, rollback segments
  • Applied expertise in generating & understanding AWR & ASH reports and 10046 & 10053 tracing.
  • Applied expertise in 12c / 11gR2 and 10g optimizer features

Environment: Oracle GoldenGate12c/11gR2, RAC, ASM, OEM, Shell scripts, Unix Shell ksh/csh, SQL, SQL*Plus, PL/SQL, and DB Triggers

Confidential

Data Architect / DBA

Responsibilities:

  • Oracle GoldenGate12c Replication
  • Organized replication strategy in an Oracle/SqlServer environment that included 3 ORACLE 10g/11g RAC environments and 48 Distributed SqlServer databases. Replicating real-time from three primary ORACLE DB’s to array of SqlServer with primary and secondary switchover.
  • Install/configure/support Oracle GoldenGate data replication. Resolve replication conflicts. Troubleshoot GoldenGate performance issues.
  • Configure GoldenGate files to execute batch commands(OBEY) and expert in ggsci.
  • Perform database analysis of dependencies required to implement Oracle GoldenGate (supplemental logging and data types)
  • Resolve replication conflicts, tune heap size, memory
  • Install/configure/support Oracle GoldenGate on UNIX, performance tune slow replication.
  • Performance tune slow database performance and replication performance.
  • Configure Oracle GoldenGate on MS SQL server and Oracle databases.
  • Install/configure/support Oracle GoldenGate Monitor Server, configure monitoring, tune performance issues.
  • Usage of logdump utility to investigate Replication failures.
  • Configure Oracle Transparent Gateway to allow connections between Oracle databases and MS Sql server.
  • Installation and Configuration Oracle GoldenGate Veridata and compare the data online.
  • Responsible for deployment of the Veridata and its Agents and perform data comparison while data sources are online.
  • Ensure integration within ALL Biomedical applications.
  • Tuned reports created in Answers and embedded them in Dashboards according to the requirements.
  • Migration of application-code for Version Upgrade from Oracle 10g to 11gR2
  • Migration of Informatica replication solution to Oracle GoldenGate 11gR2 and 12c

Environment: Oracle GoldenGate12c/11gR2, Oracle Cloud, RAC, ASM, OEM, Sun Solaris, Shell scripts, Data Modeling (Data Warehouse, ERD). Unix Shell ksh/csh and CRON to monitor multiple databases, SQL, SQL*Plus, PL/SQL, and DB Triggers

Confidential

Data Architect / DBA

Responsibilities:

  • Design, develop, test, install and support programs/systems. Support projects proposals on the basis of cost/benefit justification interfacing with stakeholders across functional and geographical lines.
  • Meet with customers to understand needs and requirements and make recommendations on best practice systems solutions for small to medium size/complexity/risk projects.
  • Prepare specifications, code, tests, deliverables, acceptance criteria, time frames, etc... and prepare and study the technical feasibility and estimates of the proposed systems solutions.
  • Oracle Streams implementation - cross continental replication in m*n configuration of capture-transform-apply.
  • Provide technical assistance to other employees
  • Develop and maintain technical documentation and prepare and give presentations on the solution to customers
  • Provide timing/scheduling estimates to project lead and propose corrective actions to timelines when necessary.
  • Migrated Streams implementation for Version Upgrade from Oracle 9i/10g to 11g
  • Oracle database performance and tuning
  • Usage of SQL Performance Analyzer
  • Explain plan analysis
  • SQL Plan Management (SPM)
  • RAT (Real Application Testing)

Environment: Oracle 11gR2, OEM-12c, Oracle Advanced Data Compression(ADC), Active DataGuard (DG), Physical/Logical Standby, Oracle Streams, WAN Emulator, HP Unix, Shell scripts, Perl Scripts, Java. Data Modeling (Data Warehouse, ERD)

Confidential

Data Architect / Sr. Database Administrator

Responsibilities:

  • Responsible for database administration, installation, configuration, upgrades, migration, performance tuning, backup and recovery, cloning, space management, patching, and security, auditing and logical and physical design of database.
  • Created database instances / schemas / objects for the different modules, applied security policies, adopted Oracle Audit Vault and Transparent Data Encryption methodologies for securing PII (Personally Identifiable Information).
  • Planning & Database Administration using various tools
  • Utilize automatic database diagnostic monitor (ADDM) and use automatic workload repository (AWR) to gather statistics by collecting, processing, and maintaining performance statistics for database problem detection and self-tuning processes.
  • Upgraded partitions and master data from Oracle 9i to 10g and 10g to 11g as well as directly from 9i->11g.
  • Data Modeling using Embarcadero ER/Studio & Toad.
  • Involved in migration, deployment activities for the EHRI/SDM data warehouse.
  • Administrative support for Oracle 10g/11g.
  • Maintenance of production, testing (acceptance), and development databases
  • Documenting database standards and procedures.
  • Troubleshooting user problems
  • Space usage monitoring and capacity planning
  • Defining Database links
  • Application tuning using Explain Plan, TKPROF, SQL*Trace, TOAD, OEM etc.
  • Pre and post-production database tuning - Defining and isolating problems and bottleneck areas. Providing solutions to increase performance substantially.
  • Providing for Junior DBAs on advanced database administration.
  • Serving as technical advisor to the management.
  • Involved in Unit Testing / User Acceptance Testing.

Environment: Oracle 11gR2, Unix and Windows NT, Informatica 6.2/7.2/8, Business Objects XI R2, LDAP, winCVS, Mantis error tracker, Shell scripts, Java, Oracle Virtual Private Database (VPD), Oracle Security Policies, Oracle Audit Vault.

Confidential

Data Architect / Sr. Database Administrator

Responsibilities:

  • Logical and physical design of database.
  • Data Modeling using Embarcadero ER/Studio.
  • Maintenance of production, testing (acceptance), and development databases
  • Documenting database standards and procedures.
  • Managing replication of objects using snapshots and materialized views.
  • Writing shell scripts for various Oracle tasks
  • Troubleshooting user problems
  • Space usage monitoring and capacity planning
  • Upgrade/Migration from Oracle 8i to 9i/10g as well as directly from 8i->10g.
  • Defining Database links
  • Backup and Recovery of databases.
  • Planning & Database Administration using Embarcadero DBArtisan.
  • Application tuning using Explain Plan, TKPROF, SQL*Trace, TOAD, OEM etc.
  • Pre and post production tuning - Defining and isolating problems and bottleneck areas.
  • Providing solutions to increase performance substantially.
  • Providing for Junior DBAs on advanced database administration.
  • Serving as technical advisor to the management.

Environment: Oracle 10gR2/9.2.0.6, Sybase 12.5, SQL Server 2008, Embarcadero DBArtisan, ER/Studio, TOAD, Clear Quest, OEM, PL/SQL, UNIX shell scripts, Windows NT, Sun Solaris.

Confidential

Data Architect / Sr. Database Administrator

Responsibilities:

  • As the Data Architect and Senior Database Administrator took responsibility for leading the design and implementation of new databases, monitoring and maintaining existing databases, resolving complex database issues, problem determinations, optimizing performance, and implementing protocols for disaster recovery and security. This also included providing task direction and mentoring to other team members.
  • Ability to perform all aspects of Oracle database administration, upgrade migration and maintenance for Oracle 9i and Oracle 10g.
  • Further responsibilities included ensuring database performance & availability by monitoring space, CPU usage, fragmentation of data and by tuning queries, etc.
  • Participation in design reviews, provide input to Enterprise DB architecture and design issues;
  • Ensure database integrity & security by developing, documenting, communicating, managing and enforcing protocols involving changes to database structure, data, procedures, and user access.
  • Collaborated with project teams to evaluate new database needs. Review the proposed logical and physical database models, consult with Development as appropriate, and participate in creation of the final database structure as necessary.
  • Maintained DB servers at current patch levels, following configuration management practices;
  • Application Code Upgrade for migration from Oracle 9i to 10g.
  • Worked with developers to build, deploy & troubleshoot DB’s in Integration & QA environment;
  • Assisted other DBAs with complex problems and analyze and resolve issues using database tools.

Environment: Oracle 10g/9i, Oracle 9i RAC, ERwin, Oracle Enterprise Manager, OOAD, UML, RUP, Rational (Rose, ClearCase, ClearQuest), TOAD, SQL Server 2005, Linux/UNIX

Confidential

Data Architect / Sr. Database Administrator

Responsibilities:

  • Data modeling, schema implementation, auditing and security, performance monitoring and tuning, backup and recovery, data loads, query and stored procedure development, providing database-related assistance to developers, and documentation.
  • Responsible for overall Database Design (approx 1000 tables) and Modeling using Oracle Designer /2000 and ERWIN.
  • Lead Data Analyst and client developers’ liaison for data-mapping issues.
  • Utilized Oracle Streams to capture, propagate, and apply the transfer of BMV Licensing data, transactions, and events within managed databases.
  • Analysis and implementation of database security using Oracle Security Policies and latest Oracle10g Column Level VPD technology.
  • Upgrade/Migration from Oracle 8i to 10g.
  • Design and implementation of an optimal database performance using a variety of traditional proactive database monitoring and tuning processes as well as the newly available Automatic Database Diagnostics Monitor (ADDM) in 10g.
  • Worked with designers/developers of Oracle applications to help in designing objects and data flow.
  • Tuned SQL queries using traditional Explain Plans & TKPROF as well as the 10g SQL Tuning Advisor.
  • Provided mentoring for developers in writing SQL (and upgrading to ANSI specs).

Environment: Oracle 10g/9i, Oracle Streams, Designer 2000, ERwin, Oracle Enterprise Manager, OOAD, UML, RUP, Rational (Rose, ClearCase, ClearQuest), TOAD, PL/SQL Developer, Oracle Application Server, SQL Server 2005, DTS, HP/UX 9000

Confidential

Data Architect / DBA

Responsibilities:

  • As an Enterprise Data Architect, provided leadership to database design and implementation.
  • Lead the requirements gathering process, the business logic-to-business structure architecture and was capable in expressing requirements in technical and business terms.
  • Extensively used tools such as Designer/2000 and ERWIN for logical, physical modeling and data distribution.
  • Responsible for Very Large Data Migration effort (80 million rows) as part of the Legacy Systems integration.
  • Provided Data Warehouse Lead Architect expertise in building Materialized views and Pl/Sql Packages and Procedures for ACF reporting of benefits to Federal Government.
  • As a DBA responsible for up to 8 instances table structure definition and creation (300+ tables), allocating tablespace, query optimization, performance tuning, backup and recovery, auditing, security, etc.
  • In addition to Production DBA responsibilities, also helped with staging releases into a software application environment and maintenance support.
  • Modeled Entity Relationships (ERD's) using Oracle Designer/2000 and ERWIN.
  • Analysis and implementation of optimal database performance and tuning processes. Oracle instance/sql tuning resulted in 200%+ performance improvements. Techniques used include sensible Indexing, Explain Plan Analysis, TKPROF and STATSPACK.
  • Upgrade/Migration from Oracle 7.x -> 10g.
  • Provided technical guidance and support to software developers.
  • Performed versioning using Visual SourceSafe.

Environment: Oracle 9i/8i, Designer/2000, ERWIN, Enterprise Java Beans(EJB), Java, Weblogic, Tomcat, PL/Sql, SQL Plus, UNIX scripts, Rational Rose, Visio, PVCS, Visual Source Safe, XML, XSL

Confidential

Data Architect / DBA

Responsibilities:

  • As Manager of Data Architecture, provided Current Process Workflow analysis, Business Function/System Matrix, Data Inventory and Data/System Matrix.
  • Designing documentation deliverables including: process models, process decomposition diagrams, network architecture diagrams, data models, data flow diagrams, entity-relationship diagrams.
  • Performed logical and physical database design using ERWIN and E-R Studio.
  • Implemented database utilities/scripts to make day to day DBA tasks easy.
  • Tuned Oracle database parameters and performance monitoring.
  • Extensively used advanced queuing to process the on line jobs.
  • Upgrade/Migration from Oracle 7.x to 8i.
  • Automated the procedures and interface programs using Oracle Advanced Queuing, Oracle Enterprise Manager.
  • Assisted in Crystal Reports coding, as well as middle-tier / front-end coding using VB and Visual Interdev and versioning using Visual SourceSafe.

Environment: Database - Oracle 8i on Confidential -AIX; Oracle Advanced Queuing; Languages - Java, JSP, XML/XSL, HTML; Tools - ERwin, E-R Studio, MS Internet Information Server (IIS v4), Crystal Reports 8 Technologies - UML OO Design.

Hire Now