We provide IT Staff Augmentation Services!

Senior Dw Architect Resume

2.00/5 (Submit Your Rating)

Herndon, VA

SUMMARY:

  • Around 17+ years of IT work experience in Analysis, Design & Developing client - sever applications using oracle 11g/10g/9i/8.x/7.x, MySQL, SQL databases in production and development environments on Unix and NT platforms.
  • Expert level experience on database administration for Oracle7, 8i, 9i, 10g and 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
  • 8+ years of RAC with proficiency in setting up and administering 9i,10g,11g RAC.
  • Expert in Real Application Cluster (RAC) environment with Automatic Storage Management (ASM) on Oracle 10g and 11g.
  • Extensive experience designing and implementing backup and recovery strategy for disaster management using the conventional Hot/Cold Backups and using the Oracle backup utility RMAN, VERITAS Net Backup .
  • Experience in a variety of hardware platforms including; MS-Windows 2000, 2003, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX
  • Extensive knowledge on database upgrade from Oracle 8i to 9i, Oracle 9i to 10g, also upgrading from even 8i to 10g and eventually from Oracle 10g to 11g.
  • Vast experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities like ESTAT/BSTAT, Statspack, Tkpfof, Explain plan, Analyze, AWR, ASH and ADDM.
  • Proficient in Data Modeling ( Logical & Physical Design of Databases)
  • Expert in writing Stored Procedures, Stored Functions, Database Triggers, Packages using PL/SQL
  • Experienced in Oracle 6.0/7.x/8.0/8i/9i/10g/11g systems, SQL*Loader, Export, Import and SQL*Plus
  • Experienced in Oracle Apps 11i for Order Management systems.
  • Enforcing data integrity using integrity constraints & database triggers related with data model.
  • Extensive experience working with Designer/2000, Developer/2000, Discoverer, Oracle Reports 1.0/2.5/3/6/6i, Oracle Forms 3.0/4.5/5/6/6i/9i, SQR, Crystal Reports
  • Experience in Performance Tuning, Capacity Planning, Space Management, Database Upgrades/Migration and Planning Backup & Recovery Strategies
  • Extensive knowledge on database backup/recovery strategy (RMAN, Export/Import & Datapump), Capacity Planning, Replication (Streams) standby databases, Oracle configuration management, Dataguard, Database Cloning, Refresh, and patch management
  • Automation of regular processing activities using shell scripts and cron jobs by using Crontab and Auto sys Job scheduler.
  • Monitoring VLDB (Very Large Databases) using Grid Control and also installed grid control and agents for monitoring.
  • Documentation of the work assigned in the environment and stored for the future use.
  • Extensive knowledge in Korn shell and Perl scripting.
  • Experienced in creating black box systems using FIX protocol and other trading APIs.
  • Expert in ORACLE Database Administration operated by multiple users and multiple databases
  • Excellent in developing applications using Pro*C, Perl, C, Java & UNIX Shell Programming
  • Experience in application performance and tuning (PL/SQL)
  • Enforcing security by creating roles, granting system and object privileges on the tables, stored procedures.
  • Experienced in understanding of oracle data dictionary and normalization techniques
  • Expert level skills on Java, Java Applets, Java swing, Multithreading, JDBC, Java RMI
  • Familiar with Web Servers like JavaWebServer, 9iAS, Web Logic, Web sphere, Tomcat, Jrun
  • Extensive experience in J2EE features like Java Servlets, Java Server Pages, EJB
  • Excellent in problem solving, logical and analytical abilities

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i/8i/7X, Oracle 10g (RAC, Data Guard & Streams), SQL Server 2000/2005 and SYBASE ASE 15, Sybase IQ

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 5.8, 5.9, 5.10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/ 2000/2003/2008/ XP.

LANGUAGES: SQL, PL/SQL, T-SQL, C, C++, VB, UNIX Shell Scripting, Ksh, bash and Perl Scripting.

SOFTWARES, APPLICATIONS & TOOLS: DBCA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, VCS, Shareplex, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, Erwin, TOAD Data Modeler, Rational Rose, VERITAS Net Backup, DBArtisan, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.,SYBASE Central and MS Management Studio and SQL profiler,SQLCLR, iSql Toad,ERWIN,ER/STUDIODesigner/2000, Discoverer, Developer/2000 ( Forms 3.0/5.0/6i/10g, Reports 1.0/3.0/6i/10g), Rational Rose, Tigris.org Argo/UML, Together Soft Together

WEB TOOLS: HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metal ink, MS Visio,Weblogic,Tomcat,IIS

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

Senior DW Architect

Responsibilities:

  • Expert Level Skills in Performance Tuning.
  • Worked on Partitioning Strategy for various Fact Tables.
  • Worked on appropriate indexing Strategy for various tables in DW.
  • Heavily involved in tuning SQL scripts and also batch jobs.
  • Extensively worked on tuning SQL reports in OBIEE.
  • Extensively involved in tuning OBIEE server and designed scalable solutions for OBIEE.
  • Tuned several parameter nqserver parameters in OBIEE.
  • Tuned Network/CPU/IO related parameters for Database Server.
  • Heavily involved in tuning of Network and IO related parameters in OBIEE.
  • Worked on tuning Nested Loop and Hash Joins in SQL queries.
  • Tuned Several ETL Jobs in Oracle ODI.
  • Did Performance tuning of several reports in OBIEE.
  • Did Performance tuning of the Oracle Database and the underlying Storage IO Subsystem.
  • Designed and Implemented correct partitioning Strategy for the EDW.
  • Designed and Implemented correct Indexing Strategy for Databases.
  • Designed and implemented archival Strategy for the EDW.
  • Implemented compression for OBIEE for better performance.
  • Implemented caching strategy for OBIEE for better performance.
  • Worked on Reconfiguring firewall between OBIEE and DB Server for better performance.
  • Optimzied connection pool settings for better performance in OBIEE.
  • Worked on Several AWR Reports for tuning the Database.

Confidential, Reston, VA

Senior DW Architect

Responsibilities:

  • Worked on Installation/Configuration of Sybase and oracle Databases.
  • Worked on troubleshooting and performance issues on Sybase and Oracle databases.
  • Worked on Upgrades and Patching on Various Oracle and Sybase databases.
  • Worked on Automation of code deployment using Shell Scripts.
  • Worked on Logical Design and Data Modeling for Oracle and Sybase databases.
  • Worked on Replication server for setup and monitoring of Warm Standby and adhoc replication.
  • Worked on Performance Tuning of SQL using AWR Reports.
  • Replication Setup in MySql and troubleshooting and fixing replication issues.
  • Database Cloning and testing backup and recovery scripts.

Environment: Oracle 11g(11.2.0.4),12cR1, Sybase ASE 15.0, ASE 15.7,ASE 12.5, RepServer 15,BMC Remedy,Linux, Solaris.

Confidential, Reston, VA

Senior DW Architect

Responsibilities:

  • Heavily worked on installing configuring and troubleshooting 10 g RAC on ASM(3TB db size).
  • Involved in design methodologies for data center migration for databases.
  • Implemented database migration across data centers.
  • Worked in designing, Planning and Implementing Clustering in a RAC configuration
  • Database Administration - execution of change controls, routine maintenance, SQL scripting, Unix Shell scripting, performance monitoring, tuning, and Database diagnostics.
  • Oracle database application designs- like Transportable tablespace, Partition exchanges and management.
  • Provided domain leadership on Emergency Response calls (ERT), driving Root Cause Analysis (RCA), Preventative action follow-though, and participation in weekly operations reviews.
  • Develop and implement Database security policies and procedures, in line with corporate objectives.
  • Worked on proactive capacity planning and tending reviews of all oracle databases.
  • Heavily involved in Project Estimation process - including attending project kick-offs and design reviews as necessary to appropriately size new environments, recommend infrastructure solutions and deliver associated cost and resource effort estimates.
  • Worked on detailed technical documentation (e.g. standards, process, Run Books).
  • Mentored team members on new technology and provided guidelines and procedures.
  • Helped development teams in review of database model and data migration strategies.
  • Expert level proficiency in Backup and Recovery mechanisms.
  • Worked on mysql installation/setup/Troubleshooting.
  • Worked on performance tuning of mysql databases.
  • Worked on setting up replication and monitor replication latency/slave status etc.
  • Fixed mysql replication latency issues.
  • Worked on Mysql master-slave and multi master replication architecutures.
  • Worked with Perl/DBI/mod perl for database monitoring scripts.
  • Worked on Percona Monitoring plugins/scripts for Mysql monitoring.
  • Worked on multiple configurations with multiple Oracle level installs
  • Proficiency in use of modeling tools like Erwin, Visio, etc
  • Experience directly working with SQL, PL/SQL, PERL/Unix Shell, tuning and debugging.
  • Experience working with migrating oracle/Sybase ASE/MySQL databases across hosts.
  • Experience in the installation, configuration of Oracle Grid Control(OEM) in Server and installing the Agents in all the production, test and development databases.
  • Worked with OEM grid repository and configured monitoring of all agents,databases and hosts.
  • Experience in optimizing ASM Diskgroups.
  • Expert knowledge in troubleshooting, performance tuning of the databases.
  • Creation and maintenance of physical standby database by using oracle high availability method and Oracle Data Guard.
  • Worked on installing weblogic /oracle application server
  • Worked on Node Manager, work manager setup on application server.
  • Worked on SSO and Identity Management solutions
  • Worked on implementing RAC database on Veritas (VFS)
  • Worked on installation/troubleshooting Sybase ASE and IQ databases.
  • Installation and configuration of Simplex and Multiplex IQ Databases
  • Worked on HDS Block Level Repliation to replicate databases.
  • Installation/configuration of Warm Standby using Sybase Replication Server.
  • Worked on Warm standby and MSA replication setup and troubleshooting on Sybase ASE.
  • Worked on Installation/troubleshooting on Sybase ASE and IQ Database servers.
  • Worked on mysql replication setup and troubleshooting replication issues.
  • Worked on Installation/setup/troubleshooting of Sybase Replication Server.
  • Worked on MS SQL Server logshipping and SQL Server administration.

Environment: Oracle 11g(11.2.0.1),10.2.0.4 RAC, 9i(9.2.0.8) RAC, Sybase ASE Cluster,Sybase IQ, My SQL 5, MS SQL 2005, Solaris 8,10(64-bit), Win 2k, Toad,Grid Control 11g, Veritas, Oracle App server, ITIL V3.

Confidential, Herndon, VA

Senior Oracle DBA

Responsibilities:

  • Worked on 10g Data pump feature for exports and imports of huge tables/schemas.
  • Worked on 10g Grid control for performance monitoring
  • Worked on Awr, Ash, ADDM, reports for performance tuning.
  • Worked on korn shell scripts to do regular database monitoring.
  • Worked with 10g SQL Advisor for tuning sql queries on different databases.
  • Worked with Abinitio in datawarehouse environment in integrating the application.
  • Worked on Resource Manager to assign resource priorities at runtime.
  • Worked extensively with OEM,Toad and pl/sql developer, DB Artisan to perform various db activities.
  • Worked on Export, import scripts using unix named pipes.
  • Worked with sql loader, external tables to load data into tables.
  • Performance tuning of reports which are running on business object Boxi Servers.
  • Performed data modeling tasks using E/R Studio/Toad.
  • Worked on Database Partitioning as per business requirements.
  • Worked with SCBSL/SDM data model and dba scripts for database refreshes.
  • Tuned several initialization parameters for optimal performance of several databases.
  • Actively monitored databases for performance enhancements using Oracle Grid Control Advisors.
  • Created several stored procedures, packages and triggers as per business requirements.
  • Worked on capacity planning of memory/disk usage for the application.
  • Worked on creating Packages for DB Maintenance activities by application user.
  • Involved in design/development of partitioned based rerun (truncation) packages.
  • Involved in the automation of database refresh process.
  • Worked on Several Oracle Wait events for performance tuning.
  • Involved in sql tuning of various queries using explain plan and tkprof.
  • Worked with DSM Team to setup monitoring for oracle databases using Oracle Grid Control
  • Provided monitoring requirements for grid control
  • Involved in capacity planning and space projection of different databases.

Environment: Oracle 10g, 9i(9.2.0.6), Solaris 5.8(64-bit), Win 2k, Clearcase, ClearquestUnix, Abinitio, Remedy.

Confidential, Hartford, CT

Senior Oracle DBA

Responsibilities:

  • Installing & configuring Oracle 9i database on solaris v1280 for dev, int, test paths.
  • Used Recovery manager to perform backup/recovery activities.
  • Wrote several shell/cron scripts to monitor several instances
  • Installed and used statspack for performance monitoring of all the dev, int, test and Production paths.
  • Supported .net, Biztalk, Sql server application on windows 2000,2003 servers.
  • Worked with IIS and configured the front end for all the dev, int, test and production paths.
  • Worked extensively with OEM, Toad and pl/sql developer to perform various db activities.
  • Controlling granular access to users using roles and profiles.
  • Export, import of several databases to refresh the dev, int and test paths.
  • Creating primary database objects (tables, views, indexes)
  • Worked with explain plan and tkprof to fine tune db queries.
  • Developing disaster recovery strategies for all databases.
  • Worked on Peoplesoft integration with the application.
  • Installed Oracle, Tuxedo, Crystals Reports, Weblogic for Peoplesoft.
  • Installed and configured Web Logic Server.
  • Involved in Refreshing Development,Test,UAT from Production database.
  • Created Startup and Shutdown scripts for the Web Logic Web Server and Tuxedo Application Server.
  • Database administration of production, test and development application databases.
  • Testing the Backup and recovery procedures on regular basis.
  • Setup monitoring using Oracle Grid Control and configured agents on all db and application hosts
  • Worked extensively on Oracle Enterprise manager for database administration activities.
  • Worked with dataguard for standby databases.
  • Supported Oracle Workflow application.
  • Worked in EDW (Enterprise Claims data warehouse environment).
  • Worked on RAC with 2 nodes on production servers.
  • Tablespace growth and space planning well in advance to avoid problems.
  • Awarded for Providing excellent customer support to customers.
  • Visual source safe administration for 2 databases.

Environment: Oracle 9i(9.2.0.6), Solaris 2.9(64-bit), PL/SQL 8.0,Peoplesoft, Win 2003, Visual source safe,Unix, Perl.

Confidential, Hartford, CT

Oracle Application Developer

Responsibilities:

  • Installing & configuring Oracle 9i database on solaris for bcms online application for two instances.
  • Involved in monitoring and tuning Oracle for bcms online
  • Wrote several shell scripts and perl scripts for database maintenance.
  • Worked on Oracle Portal in developing web application for BCMS.
  • Creating primary database objects (tables, views, indexes) once application developers have designed the application.
  • Modifying the database structure, as necessary, from information given by application developers.
  • Worked with Oracle enterprise manager and db artisan for database administration.
  • Enrolling users and maintaining system security.
  • Created several Perl scripts to run sqr programs to generate PDF reports on web.
  • Written several shell scripts to run reports through SQR.
  • Controlling and monitoring user access to the database.
  • Monitoring and optimizing the performance of the database.
  • Planning for backup and recovery of database information.
  • Maintaining archived data on appropriate storage devices.
  • Backing and restoring the database.
  • Worked on Oracle Order Management used in the application.
  • Allocating system storage and planning future storage requirements for the database.
  • Provided excellent support as an application dba to the applications.
  • Worked on several scripts to automate error logging for cronjob scripts on the database.
  • Installed Oracle 9i AS portal for PL/SQL Web tool kit application on which bcms online website is built.
  • Provided excellent customer support for all the developers.

Environment: Oracle 9i(9.1),8i,Oracle Portal, HP-UX 11i, PL/SQL 8.0, Win 2000, Perl, SQR.

Confidential, Bedford, Texas

Oracle DBA

Responsibilities:

  • Installing and upgrading the ORACLE Server and application tools for 3 instances.
  • Modifying the database structure, according to requirements of the application
  • Performance tuning, SQL tuning.
  • Developing the backup and recovery strategy
  • Implementing basic replication using snapshots.
  • Worked on several scripts to automate reports on the database.
  • Performance tuning done at application level using TKPROF and explain plan
  • Built many reports to handle the donor and lab/distribution system.
  • Designed the database for Hospital Order Entry system.
  • Worked on several shell scripts for cronjob.
  • Provided support for server side and web programs for Iwebb and hospital order entry modules.
  • Documented all the developed scripts.
  • Worked on UML Class diagrams to develop the client requirements.
  • Worked with Oracle 9i AS portal to develop PL/SQL Web tool kit application.
  • Provided excellent customer support for all the modules for developers.

Environment: Oracle 8i(8.1.6.0), PL/SQL 8.0, Developer/2000, Forms 6i, 4.5 Reports 6i, 2.5, HP-Unix, PVCS, Win 2000.

Confidential, Los Angeles,CA

Oracle DBA

Responsibilities:

  • Oracle installation, database creation and configuration and maintenance of 3 instances.
  • Capacity planning, space monitoring, creation of schema objects, table space defragmentation
  • Performance tuning, SQL tuning.
  • Developing the backup and recovery strategy
  • Implementing basic replication using snapshots.
  • Worked on IP network to maintain multiple instances on multiple servers.
  • Security management through creating user accounts, user privileges, roles and auditing.
  • Responsible for database management in the marketing, vendor development and material-planning department.
  • Conceptualization, requirement analysis and design of the system.
  • Database security management.
  • Creation of schema objects, capacity planning and space management.
  • Developing standards, procedures for DBAs and developers.
  • Designed the Schema for the Confidential database
  • Created the database triggers, Integrity constraints for the data validations.
  • Data feeds (see-beyond generated) pre-processing for the tables.
  • Data cleansing of data feed files.
  • Data loading using Unix shell scripts, SQL*Loader.
  • Loading the data feeds to the tables (Pay per View Movie Database, Program Guide)
  • Shell Scripts (Korn Shell for data loads for cronjob)
  • Cronjob Setup for loading the data every midnight.
  • Used Oracle AQ for message Handling.
  • Paging Functionality Implemented for cronjobs using attention servers.
  • Performance Tuning done with indices, hints and with Explain Plan.
  • Created Triggers and Procedures (E-Mail Functionality) for monitoring the database.
  • Created comma delimited reports to Monitor the web transactions at Confidential .com.
  • Deployed many web based applications on Oracle 9i AS portal, including forms 6i and reports 6i.
  • Developed forms and reports for the Web and Acpt databases.
  • Developed numerous reports using SQR for customer billing info.
  • Performance tuning on the reports, which query huge programming tables.
  • Cronjob setup which generates these reports on daily, weekly and monthly basis.
  • Implemented test plan and documented the process.

Environment: Oracle 9i(AS) Portal, PL/SQL 8.0, SQR 3.0, Developer/2000, Forms 6i, Reports 6i, Tru 64 Compaq Unix, PVCS, WinNT 4.0, Erwin 3.5.2.

We'd love your feedback!