We provide IT Staff Augmentation Services!

Lead Dba/data Architect Resume

NC

SUMMARY:

  • More than twentytwo years of professional IT experience out of which more than FOUR years as LEAD Database Administrator , THIRTEEN years as a Senior Database Administrator , FIVE years as Data Architect / Data Modeller and ONE year as ORACLE GOLDENGATE ADMINISTRATOR on Multi - OS such as Red Hat LINUX, Oracle Sun Solaris, HP-UX, IBM AIX, COMPAQ UNIX and Windows Server on a 24x7 basis for Production, Development and Test Environments .
  • Involved in SDLC process, going thru Waterfall model using Agile software development.
  • Promoting database application environments going thru a Change Management process.
  • Carrying out candidates’ performance review appraisal and involved in hiring best resources for the team.
  • Configuration and Administration of Oracle 11gR2 and 10gR2 Real Application Cluster (RAC ) environments for multi-nodes based database by configuring Oracle registry, Oracle Clusterware and RAC. Working on Cluster Verification Utility (CVU). Administering Oracle SCAN listener and server to & from cluster monitoring. Starting and stopping cluster monitoring of the instance and listener thereby checking the status of Oracle cluster resources.
  • Implemented Physical standby database ( Data Guard ) for production database with Dataguard broker. Setup and successfully performed active fail over in the event of production failure. Monitoring Redo Transport services, Log apply services and Role transitions. Handing issues with Network tuning for Redo Data Transmission.
  • Installation and Configuration of Oracle Apps 10i/11i in different operating systems for VLDB in OLTP & Data Warehouse environments. Implementation of Oracle 11gR1/R2 New Features such as Segment Advisor, SQL Tuning Advisor, SQL Access Advisor, MTTR Advisor , Flash Recovery Area , Automatic Database Diagnostic Monitor ( ADDM) and export/import Data Pump utilities of various type of Data Loads and enhanced securities for HA database. Data loading using SQL*Loader direct and parallel option s. .
  • Experience working on Oracle 12cR2/11gR1 OEM Grid Control for the effective DB administration. Administration of Oracle files using Automatic Storage Management ( ASM ) in a Storage Area Network ( SAN ).
  • RMAN configuration using Recovery Catalog/no-catalog for databases running on ARCHIVE / NOARCHIVE and managing more than 100 plus instances. Restore and DB Cloning from RMAN new features.
  • Monitoring and optimising the Database Performances through Database Tuning such as AWR and ADDM , Tuning of SGA and Memory, System Tuning, Application Tuning and SQL query plan using Explain Plan, Tkprof and prefstat.
  • Effective ways of writing stored procedures, functions, triggers and packages using PL/SQL. Writing UNIX Ksh shell scripts for scheduling of jobs in Crontab for Database monitor and PERL Scripting . Worked on Autosys for scheduling and monitoring jobs. Used packages such as DBMS JOB, UTL FILE, DBMS STATS, DBMS SQL, DBMS REORG and DBMS SCHEDULER.
  • Performed Oracle DB patching , cloning, troubleshooting issues/errors; collaborate with Oracle support for bugs and creating TAR in METALINK . Designed SOPs , responsible for 21 CFR Part 11, SOX regulatory compliance audits.
  • Experience on Logical & Physical Designing of Databases using tools such as ErWin for effective Data Modelling for DWH and OLAP systems satisfying Database Normalization . Experience in building Data warehouse environments with Star Schema and SnowFlake Architecture.
  • Worked as a Cloud Database Administrator and involved in PEOPLESOFT based Oracle environment migration to Amazon Web Services (AWS). Involved with issues for PeopleSoft application to run effectively.
  • Installations and Configurations of MSSQL Server v2K5/2K8. Installations and Configurations of Sybase Adaptive Server Enterprise (ASE) v12.5/11.x on UNIX and Windows. Performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks and troubleshooting.
  • Configuration and Administration of GOLDENGATE v10.4 and GG Director for UNI/BI-DIRECTIONAL replication. Configuration of GG Veridata v3.x for comparison between Source and Target after replicating the processes for online Transaction Logs form Source DB to Target DB.. Configuration of Oracle Replication Server for Advanced Multi-Master & Basic replication type in Oracle 9i/8i.
  • Worked on EMC Symetrix DMX, EMC CLARiON NAS devices, Hitachi, IBM, DMX SAN storage devices.

PROFESSIONAL EXPERIENCE:

Confidential, NC

LEAD DBA/Data Architect

Responsibilities:

  • Leading a team of DBAs for multi-terabyte database sizes. Designed and implemented change management procedures and processes for the engagement resulting in a more structured and manageable project. Prepared statement of work (SOW) for custom projects to help with billing efforts to generate additional revenue for the organization
  • Installation and configuration of Oracle 11gR2 and 12c databases for Production, Development and QA on Sun Solaris v10 and IBM AIX meeting the SOX Compliance . Production Support on 24X365 basis for HA and MAA DBs.
  • Installation, Configuration and support of Oracle Real Application Cluster 11g ( RAC ) for multiple nodes. Monitored and administered and backing up RAC instances. Used the Oracle Flashback Query options such as Flashback database for recovering the whole database to a point in time, Flashback table for restoring the state of a table to a certain point in time and Flashback Drop.
  • Implemented Automated Oracle Tuning feature. Configured ADDM for bottleneck problems, memory related issues, DB Configuration problems, Space related issues, application/SQL tuning issues etc. Used AWR snapshot reports for ADDM to analyze data for performance bottlenecks. Implemented Oracle Automatic SQL Tuning procedure for enabling SQL Tuning. Tuning of SGA, memory allocation and I/O Tuning such as reducing Disk I/O Contention.
  • Designed and Implemented database Cold an d Hot backup strategy using RMAN . Database backup implementation using EMC BCV and Veritas NetBackup. Export/Import of database using Data Pump Utility was configured.
  • Created and configured the Oracle Standby databases. Configured Data Guard for Physical, Logical and Active Data Guard providing HA of DBs. Monitored DB growth and activities and Exception notification procedures thru Emails.
  • Database automation for Crontab script using UNIX ksh and Dynamic SQL scripts for administration purposes and integrate data load scripts using SQL Loader. Administration of Oracle DB instances using OEM 10gR2 Grid Control.
  • Designed Dimensional data models ( Snowflakes, Star Schemas ), which consisted of both fact and dimension tables. Maintained code tables, materialized views and fact tables being loaded on a daily basis from various sources. Logical and Physical Database design using ERWin. Working with ETL tools such as Data Stage and Informatica for Data masking to protect customer info and implemented Row-Internal Synchronization, Table-Internal synchronization and table-to-table Synchronization and Encrypting the data by Nulling Out Or Deletion.
  • Applying Oracle Patches when/as required. Contacting Oracle Support using METALINK . Responsible for writing SOP for the DB server implementation procedure and mentoring Junior DBAs includes Offshore in Europe and Asia.
  • Working on Remedy ticketing tool to handle online queries of developers / users and resolving them remotely and providing them solutions. Database size is >20TB and administered >80 DBs.

Environment: Oracle version 11g/12c on RedHat LINUX. TOAD v8/9 & ErWin v6.x for data model design, MS Visio, SQL Developer, JAVA and EMC BCV etc.

Confidential, PA

LEAD CLOUD DBA/Data Architect

Responsibilities:

  • Lead a team of DBA’s on a large complex database design and delivery projects. Managed database administrators and operations teams on different database environments across multiple sites and offshore team.
  • Participated in quarterly meetings with Senior Management to discuss technical infrastructure. Managed change control meetings ensuring that changes to production environments are validated and thoroughly tested. Supported overall IT control practices, remediation, action plan execution, QA, Production and systems certification as part of SDLC process. Directed and provided guidance in solutions for deployments, integration, testing, remediation and re-engineering efforts in Production. Conducted performance reviews, goal settings for DBA team members, attracting and retaining the best talent.
  • Lead database compliance effort in accordance with 21 CFR 11, SOX, HIPAA regulations and participate with internal and external audits resulting in fulfilment of FDA regulations and requirements.
  • Oracle 11gR2 Real Application Cluster (RAC) installation, configuration and support for Multi-node on Red Hat Linux and Solaris OS for Production, Development and QA environment. Implemented Oracle 11gR2 new features for advanced compression and column level expression, Concurrent statistics gathering, and parallel query management, Oracle Flash Cache, Automated SQL Tuning, Automatic Memory Management, and Adaptive Cursor Sharing, Patching of Oracle RAC Databases.
  • Installation and configuration of Oracle 11gR1 Oracle Enterprise Manager Grid Control to administer RAC and non-RAC databases, Administration and support of EPIC Systems, AMISYS database environments in 24X7. Upgraded to 12cR2 OEM for Prod Servers.
  • Implemented a strong DR policy for all the critical applications servers which have been appreciated by the management. Data Guard High Availability Databases as a Disaster Recovery (DR) Plan.
  • Implemented RMAN new features including compression algorithm to minimize database backup and restore size and time effectively. New procedure for faster database duplicate/cloning process by implementing Oracle 11gR2 new feature. Datapump for schema and objects backup in Development and QA environment.
  • Mentoring DBAs and developers. Effective SQL and PL/SQL coding and scripting including ksh, csh for effective DBA management scripts, Implemented SOP, DBA best practices for effective database management. Working with Network and Storage Administrator for effective configuration for Oracle High Availability environment. Duties included a combination of infrastructure and technical support, build implementation, capacity and monitoring planning and setup from database admin capacity.
  • Data Architect responsibilities includes logical and physical data modelling , data analysis and definitions, database design and engineering, database architecture/set-up, security, standards development and implementation. Designing and implementing DW logical data model.
  • Deployment of Oracle database using Amazon RDS . Backing up database in cloud using Amazon S3 thru OEM.
  • Installation of Oracle 12c fusion middleware including Weblogic server, Oracle application server, Oracle coherence, Oracle JDevelopr, Oracle SQLDeveloper on Amazon Web Services (AWS) on Cloud. Applied Oracle EBS patches.

Confidential, ME

LEAD DBA/Data Architect

Responsibilities:

  • Implemented Oracle 11gR2 New Features in Automatic Storage Management (ASM) for storage and administration of Oracle files under SAN. Administered ASM Disk Groups and backed up ASM managed files. Other features such as Case Sensitive Passwords, Data Recovery Advisor, Database Replay, Query Result Cache, Secure Files, SQL Access Advisor, SQL Performance Analyzer, SQL Plan Management, Statistics Collection Enhancements, Table Compression Enhancements, Tablespace Encryption and Temporary Tablespace Enhancements etc.
  • Setup, Configuration and administration of Oracle 11gR2 and Oracle Apps 10i databases for Prod, Test and Development environment. Implemented Secure Shell (SSH) tunnelling as a way of Oracle Network traffic. Implementation of Fine Grain Access Control (FGAC) for Oracle Data Encryption and Oracle Data Masking.
  • Configured and Administered multi-nodes Oracle RAC databases for different environments. Implementing SOX standards to meet the customer requirements. Using cloning and replication procedures, backup and recovery procedures, export/import scripts, datapump scripts, and RMAN scripts. Setup RMAN scripts for backup/recovery for all environments. Maintained and support DataGuard for production instances. Configured Oracle Enterprise Grid Control for centralized monitoring, executing scripts, patches, status reports, backup reports, log reports, statistics reports. Planning and installing Oracle patches (quarterly) across the Business.
  • Meeting project managers to discuss projects, implementations, impacts on the Business systems, updates, plan maintenance windows, plan installations. Understanding Business Needs , implementing new products that will help save money and improving on time and effort throughout the Business.
  • Installation and Administration of MS SQL Server v2K/2K5. Database design, creation of user Databases, Installation of MS SQL Clients. Use SSIS to transfer millions of rows of data to and from heterogeneous data sources.
  • Using DTS for import/export and transform data in support of tasks such as data consolidation, archiving, and analysis, FTP task, the Execute Package task, the Dynamic Properties task, and the Message Queue task.
  • Involved in fine Tuning and Performance and Query optimization of the Database as required by the application. Performance monitoring and tuning of SQL servers.
  • Conversion from MS SQL Server to Oracle using Oracle SQL Developer, SSIS and DTS.
  • Designing and Implementing the Filters that can be applied in different modules based on the individual requirements of the modules, which helps the users in restricting or browsing through the Data, they actually require.

Oracle Developer DBA / Consultant

Confidential, VIENNA, VA

Responsibilities:

  • Installed, configured and administered Oracle 11gR2/R1 and 10gR2 High Availability databases for Production, Development and QA environments on Sun Solaris v10, IBM AIX, Linux. Lead the team of Production Support for 600 end users, Lead the Migration efforts in DB upgrade from 10.2.0.4 to 11.1.0.6 using Migration Utility and implemented New Features .
  • Installed/configured Oracle Golden Gate v10.4 replication in a Real Application Clustered Environment on Solaris v10. Responsibilities include Running an Initial Load, Mapping and manipulating data, Customizing GG processing, monitoring processes, managing the Oracle DDL replication environment and performing administrative processes,
  • Backup and recovery strategies of Oracle GoldenGate . Tuning of Oracle GoldenGate server for optimal performances. Installation and configuration of the GG Veridata v.3.x for comparing objects between Source and Target DB. Publishing the report on the web. Configuration of GoldenGate Director Server .
  • Configured Data Guard Broker using DGMGRL and Data Guard Manager GUI via EM Grid console to monitor and manage physical/logical standby databases. Configured physical standby database for Maximum Availability protection with fast-start failover using data guard broker on Solaris v.10. Configured Flashback Recovery Area for all the 11g production databases. Monitoring Redo Transport services, Log apply services and Role transitions.
  • Configured 11gR1/10gR2 Enterprise Manager Grid Control for effective Database maintenance and monitoring. Configured Templates, User Defined Metrics, Rules etc. for Alert generation and receiving EMAILS to DB monitor. Also effective configuration, maintenance, and administration of Oracle Text in an Mainframe environment.
  • Configured 10g2RAC for two nodes with ASM/SAN storage on Red Hat Enterprise Linux Failover testing and implementation of TAF Migration, Load balancing, Up-gradation and RAC database patching using rolling upgrades.
  • Responsible for performance tuning of corporate databases. Used Database Features like Mean time to recovery ( MTTR ), Flashback Query, LogMiner. Identifying the poorly performing queries using Explain Plan, TKPROF, AWR reports and assisting the DB developers in optimizing and tuning the SQL and PL/SQL code using SQL trace & SQL Tuning Advisor. Administration of Oracle database supporting Oracle 11i EBS apps.
  • Designed, Configured and Implemented centralized database backup solution using 11gR1/R2 RMAN compression utility ZLIB algorithm, Catalog database repository for 100+ databases . Database export and import data pump utility for loading data into DWH and OLAP environments.
  • Installation and Configuration of typical Fail Safe configuration and deployed in managing Unplanned group failover and Planned failover. Efficiently managing Independent workloads and Load balancing.
  • DBA Support on Oracle Apps 10i Databases. Applying patches, DB Tuning, backup and restore etc. Unix Ksh scripting for DBA and also reviewing/using PERL scripting for Administration automation.
  • Perform database Capacity Planning and growth projection by monitoring DB space and ensuring disk space availability for various end-user applications accessing the database. DB size is >25TB and users are >600.

Environment : Oracle version 11gR1, 10gR2 Server on Sun OS 10, IBM AIX and Linux, TOAD v8/9 & ErWin for data model design, MS Visio, SQL Developer, JAVA, Tivoli etc.

Confidential, Pasadena, CA

Sr ORACLE DBA/Data Architect

Responsibilities:

  • Leading a team of DBAs for multi-terabyte database sizes. Designed and implemented change management procedures and processes for the engagement resulting in a more structured and manageable project. Prepared statement of work (SOW) for custom projects to help with billing efforts to generate additional revenue for the organization
  • Installation and configuration of Oracle 11gR1 and 10gR2 databases for Production, Development and QA on Sun Solaris v10 and IBM AIX meeting the SOX Compliance . Production Support on 24X365 basis for HA and MAA DBs.
  • Installation, Configuration and support of Oracle Real Application Cluster 11g/10g ( RAC ) for multiple nodes. Monitored and administered and backing up RAC instances. Used the Oracle 10gR2 Flashback Query options such as Flashback database for recovering the whole database to a point in time, Flashback table for restoring the state of a table to a certain point in time and Flashback Drop.
  • Implemented Automated Oracle Tuning feature. Configured ADDM for bottleneck problems, memory related issues, DB Configuration problems, Space related issues, application/SQL tuning issues etc. Used AWR snapshot reports for ADDM to analyze data for performance bottlenecks. Implemented Oracle Automatic SQL Tuning procedure for enabling SQL Tuning. Tuning of SGA, memory allocation and I/O Tuning such as reducing Disk I/O Contention.
  • Designed and Implemented database Cold an d Hot backup strategy using RMAN . Database backup implementation using EMC BCV and Veritas NetBackup. Export/Import of database using Data Pump Utility was configured.
  • Created and configured the Oracle Standby databases. Configured Data Guard for Physical, Logical and Active Data Guard providing HA of DBs. Monitored DB growth and activities and Exception notification procedures thru Emails.
  • Database automation for Crontab script using UNIX ksh and Dynamic SQL scripts for administration purposes and integrate data load scripts using SQL Loader. Administration of Oracle DB instances using OEM 10gR2 Grid Control.
  • Designed Dimensional data models ( Snowflakes, Star Schemas ), which consisted of both fact and dimension tables. Maintained code tables, materialized views and fact tables being loaded on a daily basis from various sources. Logical and Physical Database design using ERWin. Working with ETL tools such as Data Stage and Informatica for Data masking to protect customer info and implemented Row-Internal Synchronization, Table-Internal synchronization and table-to-table Synchronization and Encrypting the data by Nulling Out Or Deletion.
  • Administering Oracle 10i EBS DBs . Backup and restore process for the DBA best practices and tuning the server.
  • Applying Oracle Patches when/as required. Contacting Oracle Support using METALINK . Responsible for writing SOP for the DB server implementation procedure and mentoring Junior DBAs includes Offshore in Europe and Asia.
  • Working on Remedy ticketing tool to handle online queries of developers / users and resolving them remotely and providing them solutions. Database size is >20TB and administered >80 DBs.

Environment: Oracle version 11g, 10g, 9i (v9.2) Server on Sun OS 10 and IBM AIX v.6.1, LINUX. TOAD v8/9 & ErWin v6.x for data model design, MS Visio, SQL Developer, JAVA and EMC BCV etc.

Confidential, Philadelphia, PA

Principal ORACLE DBA/Data Architect

Responsibilities:

  • Installation, configuration and administration of Oracle 10gR2/9i databases for Production (24X7), Development and QA on environments such as Sun Solaris v10, IBM AIX v5.3 and Linux.
  • Configuration of ADDM for analyzing data in the Automatic Workload Repository ( AWR ) to identify potential performance bottlenecks. Configured Automatic Storage Management ( ASM ) for effective storage and administration of Oracle files, Configured ADDM for bottleneck problems, memory related issues, DB Configuration problems, Space related issues, application/SQL tuning issues etc. Used AWR snapshot reports for ADDM to analyze data for performance bottlenecks. Enables fine grained Auditing .
  • Administration of Oracle 10gR2 Real Application Cluster ( RAC ) based nodes. Configuration of 10G OEM Grid Control to administer Production/Development Servers. Configuration of OEM GIRD 10gR2 for DB monitoring.
  • ONLINE HOT database backup of Production database followed by OFFLINE COLD backup of TEST and QA databases mostly using RMAN . DB Cloning and restore from RMAN backup.
  • UNIX K-sh Shell Scripting mostly in order to achieve scheduled backups and data loading and Crontab jobs. Implemented the scheduler in the production environment. Configured Veritas Netbackup v6.5 for Data Protection and Disaster Recovery plan. Used Oracle Flashback Option for DB Recover. Supporting Oracle 10i Apps Server for Development and Test environments including Mainframe environment.
  • Tuning of SQL structured queries, Database Tuning for improving database performance using STATSPACK, Hints and Oracle Automated Tuning Procedure. Writing complex codes using Dynamic SQL. Designing and implementing DW logical data model (ODS, Star/ Snowflakes Models). Worked on Informatica v8.6 .
  • Used Materialized Views (snapshots) for replication of data. Worked on optimizing new and existing SQL queries by creating indexes and materialized views . Managed Standby DB for disaster recovery, locally managed tablespaces, Function Based Indexes, Global Temporary Table. Configuration and installation and support of OBIEE .
  • Validating Models created in ErWin and structuring DDLs according to the business/client requirements. Used Advance Oracle features such as MERGE , Analytical function and dynamic SQL for the migration scripts .
  • Applying Oracle Patches and raised the issues/concerns creating TAR in METALINK .
  • The Geo Database was provided by ESRI . The Geo Databases in ArcGIS was stored in " ArcSDE Geo Database ". It was used for City of Philadelphia’s urban planning on SPATIAL Database.. Database size is 8 TB.

Environment: Oracle 10gR2, 9i on Sun OS 8/10 and Linux, IBM AIX v5.3 under SAN environment. OpenVMS, TOAD v8/7 & ErWin v6.x for data model and design & MS Visio, ArcGIS 9.2, ArcSDE, ArcView 3.x, Oracle Apps 11i, SAP etc.

Confidential, Providence, RI

Sr. ORACLE DBA (OLTP/Data Warehouse)

Responsibilities:

  • Installation and configuration of ORACLE 9.2.x for AIX 5.2 and Sun Solaris 8 according to OFA.
  • Database is running on ARCHIVELOG mode. Database backup mode is ONLINE HOT BACKUP. Export/Import of the databases at users/table levels. Oracle9i/8i back up and restore/recover using Recovery Manager ( RMAN ) utility to locate, back up, restore, and recover data files, control files, and archived logs. Planning Backup/Restoration Strategy, Executing Shell Scripts using Corn jobs, Planning and scheduling Backups. Configure and Administration of OLAP DB
  • Data load using SQL*Loader across Oracle databases. Export and Import utility across the oracle DB instances. Production Support on 24X7 bases. PL/SQL Debugging for SQL Tuning. Used Data Stage and Informatica .
  • UNIX Ksh scripting to accomplish several objectives according to the application requirement. Implemented the scheduler in the Production environment. Dynamic PL/SQL Scripting and DD reconciliation.
  • Responsibilities includes logical and physical data modelling , data analysis and definitions, database design and engineering, database architecture/set-up, security, standards development and implementation, data modelling tools evaluation, logical modelling consultation and advanced SQL and SQL constructs consultation and use, SQL and PL/SQL coding and scripting, database programming specifications, functional specs and user requirements. Designing and implementing DW logical data model (ODS, Star/ Snowflakes Models)
  • Performance tuning using STATSPACK and UTLSTAT reports, third party tools, Explain Plan and monitoring Alert logs. Carry out Capacity planning; generate capacity reports to monitor space utilization, collecting and diagnosing performance event traces like 10046, 10053 etc. Expertise in handling ORACLE INTERNAL ORA-600 and ORA-7445 issues. Reviewed the issues & in corporate assessment for UTF-8 character set for effective DB Administration.
  • Oracle Advanced Security features such as fine grained access control ( FGAC ), application context and global application context. Role Based access control in accessing secured customer data. Secured Enhanced Auditing and Database Risk management, Configuration of Oracle Data Masking out for Data Sensivity.
  • Worked on Oracle Streams and Data Guard in a Test and Development environment. Configured Oracle 9i Data Guard for High Availability and Disaster Recovery. Administered for Data Protection for better performance and Streams AQ scalability. Worked on Oracle Streams for Message Queuing, the Data Replication and Event Management and Notification. Applying Oracle patches as and when released by Oracle Corp. .
  • Oracle SQL Tuning, Parallel queries, database tuning, OS tuning required for Oracle database in Production and Development environment. Tools such as STATSPACK, Analyze etc. Database table partitioning. Working in a SAN environment. Database size is 10TB.

Environment : Oracle v9.2/8i Server on IBM AIX v.5.2, Digital OpenVMS and Sun Solaris 8 on a Storage Area Network, iSeries Based System. TOAD v8/7 & Erwin v6.x, Business Objects & MS Visio, JAVA, PeopleSoft and Cold Fusion.

Confidential, Frankfort, KY

Sr. ORACLE DBA (OLTP and Data warehouse)/ System Analyst

Responsibilities:

  • Installation and configuration of Oracle 9i and 8i databases on Multi-OS environment such as IBM v.5.2 and Windows 2K3/XP/2000 meeting the OFA standards. Administering and troubling shooting the database problem.
  • ONLINE HOT database backup of Production databases and OFFLINE COLD backup of TEST and QA databases. Shell Scripting using Ksh mostly in order to achieve scheduled backups and data loading. Export and Import of databases in different OS. Configured Oracle 9iAS Web Portal .
  • Tuning of SQL structured queries for improving database performance. Tools such as Analyze, SQL Trace, Hints, STATSPACK etc. Writing complex codes using Dynamic SQL. DB modelling for OLAP environment and configured following the guidelines.
  • Configuration of Oracle Transparent Gateway for data load from MS SQL Server 2K/2K5 into Oracle 9i database. Configuration of Oracle Enterprise Manager (OEM) for administering Multi-OS based Oracle databases. Provide assistance w/troubleshooting Oracle Database Gateway for Distributed Relational Database Architecture.
  • Administered SQL Server db 2K/2K5. Configured OWB for Data warehouse DB and Data load from different sources.
  • Validating Models created in ErWin and structuring DDLs according to the business/client requirements.
  • Applying patches released by Oracle and raised the issues/concerns creating TAR in METALINK.
  • Installation and configuration of Oracle 9iAS Infrastructure portal database . Trouble shooting of any database problems and applying Oracle patches as and when required. Working on Oracle Business Intelligence (OBIEE)
  • Working on Oracle Internet Directory based on LDAP based directory server. Administered LDAP directories by giving access to LDAP users for accessing the databases. Using LDAP to pursue High Availability, better securities, integration of multiple directories etc. Oracle Advanced Security and Audit trail of Databases.
  • Migration of Oracle 8i to Oracle 9iR2 on LINUX and IBM AIX.Database Size is 2TB.

Environment: Oracle 9i (v9.2)/8i Server on IBM AIX v.5.2. Oracle 9iAS on IBM AIX v.5.2 in SAN. TOAD v8/7 & ErWin v4.x for data model and design, iSeries Based Systems, Oracle DWH Builder, PeopleSoft & MS Visio.

Confidential, Kalamazoo, MI

Oracle Developer DBA/Data Architect

Responsibilities:

  • Responsible for supporting application developers on best possible implementation of database schema/objects and data integrity. Design and development of PL/SQL scripts for data extraction, data transformation and data migration. Created Users/Roles, granted/revoked Permissions/Roles, defined quota on Tablespaces for users, and effective management of Locally Managed Tablespaces, Dictionary-Managed Tablespaces, and Temporary Tablespaces.
  • Installation and configuration of ORACLE 9i Release 2 on Sun Solaris v5.8 and HP-UX 11.x for Production, Development and Test Environment according to OFA standard. Working on a database that meets the “HIPAA regulations”. Production support of the databases on 24X365.
  • Oracle application tuning viz. EXPLAIN PLAN, ANALYZE, SQL Trace, HINTS etc. and optimisation for better performance in Production environment. Provide assistance w/troubleshooting Oracle Database Gateway for Distributed Relational Database Architecture.
  • Data loading using SQL*Loader across Oracle databases. Script writing in Ksh to accomplish several objectives according to the application requirement. Physical and Logical database modelling using Erwin v4.x Data Modeler.
  • Database backup using RMAN for HOT online backup and scripts written for COLD offline backup. Database availability is 24X7 bases. Database size is 6TB.
  • Federal and Adhoc Report generation using Oracle Reports and guiding the developers to in corporate the technology for Crystal Reports v9/8. Experience using Dynamic SQL. Supporting the application written in PRO*C.

Environment: Oracle version 9i (v9.2) Server on Sun Solaris v5.8 in SAN. Tools such as TOAD v7.3 & ErWin v4.x for data model and design & MS Visio.

Confidential, NY

Oracle Data warehouse DBA/ MS SQL Server DBA

Responsibilities:

  • Installations and configurations of ORACLE v9.2/8.1.7 on Solaris v2.8..
  • Created a staging area and wrote PL/SQL scripts to automate the loads. SQL*Loader for loading data from standard operating system files into Oracle database tables.
  • Installations of Oracle Designer 6i and creation of repository. Data load and working on ETL tools such as Informatica.
  • Performance tuning using UTLSTAT reports, third party tools, Explain Plan and monitoring Alert logs. Carry out Capacity planning; generate capacity reports to monitor space utilization. Configurations of Oracle Replication Server between two Production servers according to Optimal Flexible Architecture (OFA) on Production environment.
  • Tuning of Queries, Parallel queries, tuning of database before and after the completion of project and Database. Development and optimisation of packages, procedures, functions, triggers in PL/SQL.
  • Oracle9i/8i RMAN backup for Production and Development Servers and restore/recover as and when required.
  • Tune the Data Warehouse Server for optimal performances. Data Migration to Solaris v2.8 based Oracle 8.1.7.3.0. Database size was 7TB.

Environment: Oracle 9i v9.2/8i v8.1.7.3.0 Server on Sun Solaris v5.8/Windows 2k/NT server, Oracle Designer/Discoverer 6i for data modeling and designing. Data Stage.

Confidential, NYC, NY

Oracle DBA/SYBASE DBA / System Analyst

Responsibilities:

  • Installation and configuration of ORACLE 9i v9.0.1.1/ v8.1.7 on Sun Solaris v5.8 and LINUX for Test Environment according to OFA standard. Oracle Client Installation 9i/v8.1.7.0.0 and Oracle Developer 6i on Solaris and Windows.
  • Export & Import of Databases from one server/schema to another server/schema. Export/Import of Partitions with compressing the export/import databases.
  • Installations/Configurations of Oracle Parallel Server (OPS) according to OFA structure to administer multiple instances that are connected to every single Online Transaction Processing (OLTP) databases.
  • Database Backup mode is RMAN for database operating mode is ARCHIVELOG / NOARCHIVELOG mode for 24X7 activities. The environment was configured using Veritas Net backup procedure.
  • Server Performance of Database. Tuning of SGA viz. Shared Pool by Tuning of Library Cache, Dictionary Cache, and Buffer Cache, Tuning of OS by Reducing Paging/Swapping, Tuning of SGA and Tuning of memory allocation. Tuning of I/O, which includes Separating of Data files and Redo log files on different locations, Striping of table data, and Separating of tables and indexes on different locations. Reducing Disk I/O Contention etc. Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS etc. Oracle query tuning and optimization. Production Support on 24X365 bases.
  • Choosing the appropriate RAID levels (chose RAID 0+5 striping with parity checking). The concept of separating random data and indexes with traditional disks is no longer applicable using RAID striping.
  • Installing and administering Designer/2000 repository. Copying elements from one Repository to another.
  • Configuration/Installations of Oracle Enterprise Manager Console v2.04, Performance Pack, Diagnostic Pack and Tuning Pack to monitor database activity and schedule routine jobs, and increase database performance to automate the DBA activities on Production databases.
  • Data Modeling, Database Design and identifying entities, normalization/de-normalization, Table Design and Functional Design using Erwin v4.x/3.x. ETL tools such as Informatica and DataStage.
  • The system is designed to support Replication and Multi-Mater Replication applied. Implementing version control on an application system and freezing previous versions.
  • Responsible for System Design, Templates, Object Libraries and PL/SQL Libraries, develop program using Oracle forms & reports, Oracle Workflow Builder, Oracle Mail, File Upload, PJC, PL/SQL Packages, Triggers, Schema Management, Replication & Testing, Database size was 6TB.
  • Installation and Administration of Sybase Adaptive Server v12.5.
  • Database Backup Procedures, Restoration Procedures. Testing and implementing these procedures. Mirroring of devices was done to recover important database due to suspect on primary DB or when primary DB was not loaded..
  • Proficient in Sybase SQL Server performance tuning, client/server connectivity, query optimization, back-up/recovery, disaster recovery, running Database Consistency Checks and trouble shooting.
  • Manipulating system table data to solve time sensitive problems and optimize server performance. Controlling Access: Granting and revoking permissions to users, groups and roles on various objects. Adding logins to the server, making them users in particular or many DB. Locking the logins and restricting users. Enabling and disabling roles. Making use of SA, SSO and OPER roles to secure the database. Working on Data Stage.
  • Configuring Parameters: Configured various parameters in Sybase Adaptive Server for more throughputs.

Environment: Oracle Server 8i v8.1.7.1.5 on Solaris 6 and HP-UX 11.x in SAN, Windows 2000/NT v4.0 (SP6), Oracle Apps v11i. Client machines are Windows NT workstation v4.x. IBM DB2.

Hire Now