We provide IT Staff Augmentation Services!

Sr Database Architect / Dba Resume

Collegeville, PA

SUMMARY:

  • Database administrator in developer and architecting complex Oracle systems architecture, high availability, monitoring, performance tuning and optimization.
  • Expertise in writing customized ETL Routines using Informatica and stored procedures and functions in Oracle and SQL Server using PL/SQL and TSQL.
  • Sound knowledge of Oracle RAC, RMAN, OEM, DataGaurd, Performance Tuning and troubleshooting.
  • 3+ years of experience with Java, Javascript, JSP, XML, XSLT, HTML and other web development tools.
  • Excellent communication, analytical, interpersonal and managerial skills.

TECHNICAL SKILLS:

Enterprise Database Systems: Oracle, Clusterware, ASM, CRS, OLAP, MOLAP, ROLAP, Partitioning

Database Tools / Utilities: RAC, Data Guard, Grid, Oracle 11i Utilities (adpatch, adClone)

Backup and Recovery Software: Oracle Recovery Manager (RMAN)

Operating Systems: Windows XP/2003 Server, Solaris, SCO Unixware1.2, HP - UX.

Languages: SQL, HTML, XML, XSLT, Java 2, Javascript, Tk/Tcl, Perl, Unix Korn ShellBusiness Intelligence/ETL: Informatica (PowerCenter 9/8.6/8.2/7.1/ 6.2 ), Business Objects.

Reports: Crystal Reports, SAP Business Objects, Microsoft SQL Server Reporting Services

Web Related: Vignette Story Server 5.0, ASP, JSP, EJB, Servlets, Apache 1.3.20, Weblogic 5.1.

PROFESSIONAL EXPERIENCE:

Sr Database Architect / DBA

Confidential

Responsibilities:

  • Designed and implemented high availability solution with Oracle 11g DB and 4 node clusters with Oracle RAM and ASM on Linux platform.
  • Implemented multiple replication sites for Oracle migration using Goldengate to migrate VLDB from 11g to 12c Database with a throughput at 50GB/hr.
  • Implemented backup and recovery solutions while ensuring minimum downtime for single instance and clustered instances including testing and documenting hot/cold full, incremental and partial backups and restores as well as backup and recovery scenarios for standby databases (11g Data Guard) and oracle 11g RAC and ASM database clustered environments.
  • Defined new storage policies and archive retention periods to bench marking the application performance.
  • Installed Oracle 11g RAC and Clusterware and verified all RAC and ASM services with failover tests.
  • Performed upgrade and migration planning for more than 40 Oracle single instance databases to Oracle 11g RAC 5 node environment and migration planning to ASM and RAC environments using Oracle Guard Physical standby database to avoid downtime and minimize impact of online applications.
  • Designed volume management strategy for Oracle 11g RAC and ASM.

DBA/ ETL Specialist

Confidential, Collegeville, PA

Responsibilities:

  • 24x7 Production database administration, support and monitoring to ensure proactive problem identification and resolution of database issues.
  • Implemented and maintained Oracle 10g/11g DataGuard/Standby databases for failover purposes.
  • Proactively monitored the production Oracle Database and analyzed alert logs for database errors and system resource availability and responded to system memory and data issues.
  • Implemented automated hot backup scripts for daily incremental backups and weekly full backups.
  • Create database partitions including Range, List, Hash partitions and creating and refreshing materialized views.
  • Involved in performance tuning of database including memory allocation tuning, I/O tuning.
  • Monitored DB Sessions including data load statistics and custom queries against the database.
  • Extensively involved in creating stored procedures, functions and packages using PL/SQL.
  • Created materialized views and indexes for enhancing performance of applications in Oracle.
  • Analyzed and fine-tuned SQL scripts using Explain plan, TKPROF and STATSPACK.
  • Interacted with developers and change management team to ensure smooth transition of database and Informatica objects from development to testing and production during implementation.
  • Documented and enforced ETL best practices and procedures using Informatica’s Velocity Methodology.
  • Involved in planning and upgrading Informatica environments from version 7.2 to version 8.6 and finally to 9.0.

ETL Developer / Administrator

Confidential, New York, NY

Responsibilities:

  • Extensively involved in creating mappings, reusable mapplets, reusable transformations and workflows to source data from heterogeneous sources and load to different targets.
  • Used different transformations including expression, aggregate, filter, router, joiner, stored procedure, Update strategy and rank transformations as part of the implementing the ETL processing within the mappings.
  • Designed and developed workflows with different tasks including worklet, session, assignment tasks, decision tasks, Event Wait and Raise, Email tasks including pre- and post session scripts based on business requirements.
  • Implemented variables and parameters at mapping and workflow levels for enhancing reusability of code.
  • Planned and upgraded Informatica Powercenter and metadata reporter to v8.6 and applied hotfixes/patches.
  • Responsible for Informatica code reviews and code migrations from dev to QA and QA to Prod environments.
  • Involved in Data warehouse design and DR (Disaster Recovery) strategy and implemented and maintained the Informatica Enterprise Grid and HA option to provide seamless failover and recovery
  • Responsible for day to day administration of Informatica Powercenter and Metadata Manager environments.
  • Extensively involved in Informatica administering metadata objects in Informatica environments including user security, mappings and workflows along with monitoring, backup and recovery.
  • Responsible for keeping management abreast of technical issues and their impact to the business and proactively recommend process and development methodology improvements and vendor management.
  • Documented and enforced ETL best practices and procedures using Informatica’s Velocity Methodology.
  • Developed Unix Korn scripts for automating tasks and executing Informatica scripts that has to be performed at the Operating System level involving PMCMD.

Database Consultant

Confidential, Bedminster, NJ

Responsibilities:

  • Involved in logical/physical database design, capacity planning, performance tuning and data modeling using ERWIN for OLAP and ODS databases/datamarts including schema and security management.
  • Responsible for administration of Informatica and Databases and monitoring of Workflows in PowerCenter.
  • Developed Informatica mappings and workflows using PowerCenter Designer and Workflow Manager to build ETL processes from heterogeneous sources to data warehouse as per business requirements.
  • Performance tuned Informatica mappings and workflows by identifying bottlenecks and adjusting pipeline partitions as required.
  • Involved in upgrading and testing Informatica environments from PowerCenter 6.2 to PowerCenter 7.1 with version control enabled and adhering to Informatica Velocity Methodology.
  • Responsible for database performance monitoring and tuning using Explain Plans, trace files, measuring system and database activity, querying oracle dynamic performance views, creating indexes and hash partitioned tables.
  • Performed business requirements analysis and evaluated data elements and transformation rules to produce data models and specifications for the definition, structure and organization of required data objects.
  • Used ANALYZE, DBMS STATS, TKPROF, CBO/RBO, hints and performed Index optimization, tuning SGA, Rollback segments, Redo Log Buffer and partitioning of large datasets.
  • Developed Unix shell scripts for hot/cold database backups and Perl scripts for database operations.

ETL/Database DBA/Developer

Confidential, New York, NY

Responsibilities:

  • Designed and implemented ETL solutions for loading data from different source systems.
  • Worked with business users to analyze business requirements and create the business requirements document and technical specification document.
  • Extensively involved in developing and testing informatica mappings, sessions and workflows to process upstream data and load to downstream applications.
  • Created transformation logic within the mappings using expression, aggregate, filter, router, joiner, stored procedure and lookup transformations.
  • Created PL/SQL procedures, functions, packages, triggers, tables, views and indexes.
  • Analyze ETL/Informatica application and data integration problems, provide solutions and recommend corrective actions including performance tuning.
  • Provided application support by scheduling and monitoring ETL processes and workflows.
  • Created Unix and Perl scripts to perform Operating system level functions.

ETL Developer/Database Administrator

Confidential, Princeton, NJ

Responsibilities:

  • Responsible for developing informatica objects and custom ETL routines for extracting, transforming and loading data from flat files, XML files, relational database sources, SAP Systems, to a centralized database and SAP BW systems for reporting.
  • Created PL/SQL procedures, functions, packages, triggers, tables, views and indexes.
  • Involved in logical and physical database design, estimating database space needs, database growth analysis, and future disk need analysis. Created star schema data models for data marts providing information for supply chain and demand forecasting teams.
  • Involved in capacity planning, installation, database configuration, database creation, space management, backup and recovery and performance tuning of Oracle 9i databases.
  • Responsible for performance tuning of various Oracle components including SGA, background processes, redologs, rollback segments, SQL Query optimization and PL/SQL tuning.
  • Developed performance monitoring and tuning scripts using V$views, bstat/estat, statspack and sqltrace/tkprof.

Hire Now