We provide IT Staff Augmentation Services!

Data Architect/dba Consultant Resume

Chicago, IL

Objective: Seeking a challenging position in the area of database administration and software development.

Profile:

  • More than 15 years experience as a software engineer with a proven background of technical problem solving. This includes development, data modeling and Data Base Administration of Oracle/MySQL databases (OLTP/Data Warehouse).
  • DBA experience of databases sized greater than 1T and also having more than 1000 tables (includes partitioned/sub-partitioned tables) in a multi-node clustered (RAC) database.
  • Strong experience in developing and maintaining relational databases including backup/recovery procedures.
  • Good understanding of the Oracle RDBMS architecture including underlying objects, schemas/products, database objects, file system structure, tables, views, packages, procedures, sequences, indexes, partitioning and constraints.
  • Strong knowledge of OLTP, data warehousing and Internet technologies from both technical and business perspectives.
  • Deep understanding of technology with focus on delivering business solutions.
  • Extensive experience in working with teams on critical and most difficult projects.
  • Expertise in developing complex PL-SQL programs.
  • Motivated self-starter, cooperative and team oriented with multi-tasking abilities - eager to increase/improve skill set.

Education: Bachelor of Engineering (Computer Science)

Certifications and training: Oracle Database 10g Administrator Certified Professional (OCP) Sun Java 2 Certified Programmer (SJCP 2) Training - Oracle Database 10g: Administration Workshop II Release 2

Technical Skills:

Languages : Java 2, Oracle SQL-Plus, SQL, PL/SQL, Shell Scripting, C, HTML 4.0, Visual Basic, JavaScript Database Technologies: Oracle 8.0/8i, 9i, Oracle 10g (RAC), Oracle 11g RAC (Highly Available GRID), MySQL 5.1, MS Access 2003 Operating Systems : Windows (2000, XP, Vista), Linux 2.6. (Red Hat 5.4, Centos 5.2, OEL), Solaris Unix, SCO Unix, MS/DOS Tools : Erwin 7.0, ER/Studio, DB Artesian, EM. SQL*Loader, Toad, SQL --Navigator, PL-SQL developer, TKPROF, AWR, ADDM, Quest, Clear Case, Visual SourceSafe 5.0, PVCS, MySQL Administrator, MySQL WorkBench 5.2, MySQL Query Browser

Professional Experience:

Confidential, Chicago IL Nov '10 till Date Data Architect/DBA Consultant (Oracle 10gR2) Roles and Responsibilities:

  • Performed logical and physical database design at the object level using Erwin. This included design of tables which were partitioned and sub-partitioned for Oracle 10gR2 database.
  • Generated DDL scripts from Erwin and created objects in the database across multiple environments. This included complicated objects like snapshots and remote views across multiple databases using db-links.
  • Assisted developers with application design and performance tuning of complex queries. This included using the dictionary tables, AWR reports and other tools.
  • Provided support for development and production systems (weekly on call rotation). This also included offshore support.
  • Followed the company's processes which included coordinating with various departments to deploy changes in production database.
  • Maintained the enterprise data model repository using Erwin Model Mart Software.

Confidential, Chicago, IL May '01 till Oct '10 Systems DBA (Oracle 11g and MySQL) July '05 till Oct '10 Roles and Responsibilities:

  • Led Oracle upgrade project from 10g (non-ASM) to 11gR2 ASM (HA Grid) -- Converted an 8 node 10g RAC to 5 node RAC. This included installing 11g GRID, ASM instance, multipath, ASM disk creation, SCAN (Single Client Access Name) and creating clustered 11g Oracle databases.
  • Created Backup/Restore procedures and strategies. This included using RMAN/Flashback Technology. Backup mechanisms included using Data Pump exports, RMAN hot backups, and customized automated scripts. Also involved in managing the on-site backup and recovery process and support the off-site backup and recovery teams at the Data Center.
  • Created a process for Disaster Recovery simulation. This included getting the last production backup before the disaster and restoring it on a new host machine.
  • Periodic refresh of QA, INT and DEV test database environments using SNAPSHOT/COPYRESTORE method. Here a SAN snapshot is taken and a copy is made. The LUN is presented to the test host machines and then the LUNS are imported. The databases are then brought up as test databases by renaming the database.
  • Heavy involvement in performance tuning. This included tuning SQL queries, adding indexes. Was in charge of monitoring and finding the worst performing processes and queries based on CPU, Active time, I/O from a QUEST tool (performance analysis) and then tuning it as per needs.
  • Created and maintained Materialized view databases to create non-master sites kept in sync using replication. These views were created as read-only on multiple host machines. They were kept in sync with the master by frequently refreshing the data from the master site tables by setting up refresh groups that replicated to the materialized view sites. The idea was to distribute the user load across multiple database servers which were then accessed by the Front End client applications.
  • Involved in consolidating databases to cut down costs. This included running multiple databases on fewer host machines. Also included optimizing system operations, resource utilization and performing system capacity analysis and planning. Santosh Vaidyanath 3/4
  • Daily activities include configuration, operation and tuning of databases. Also included security management, instance performance monitoring, tablespace utilization, schema object management, database capacity planning, "bottlenecks" and "offensive" SQL activity monitoring and resolution.
  • Practical knowledge of tracing and debugging. This included generating trace file reports using TKPROF, AWR, ADDM and interpreting them to optimize the performance of the databases.
  • Experience with planning, coordination, implementation, logging and tracking.
  • Created monitors and alerts for user sessions, concurrent processes, table extents and locks for production and test/development systems. Also created index rebuild and update statistics scripts.
  • Provided 7x24 DBA production support where I worked with the DBA team for production on call support rotation
  • Supported oracle users and developers with database application releases, also involved in assisting developers with application design and architecture.
  • Performed physical database design at the object level using Erwin, create DDL scripts, define database objects, table partitions and external tables for the databases -- both OLTP and Data warehouse.
  • Planned for and executed required database upgrades and migration (patches etc.)
  • Good hands on experience using the following Tools -- TOAD, SQL-Navigator, Enterprise Manager, PL-SQL Developer, DBArtisan.
  • Installed MySQL 5.1 database on multiple host machines. This included setting up replication (master-master and master-slave configuration for High Availability). Also involved in daily operation and management of the database, user/database creation, finding bad queries and tuning them.
  • Experience with the MySQL Tools -- MySQL Administrator, MySQL WorkBench 5.2, MySQL Query Browser.

Data-Modeler/DBA May '01 till June '05 Roles and Responsibilities:

  • Created logical and physical Data Models using Erwin on a large scale for various business requirements/projects. Also, generated the objects for Oracle/Access databases. This was done for OLTP and data-warehouse applications.
  • Maintain the Enterprise data model repository using Erwin ModelMart Software
  • Involved in Oracle upgrades from 8i to 9i and from 9i to 10g which included the necessary environment and code changes.
  • Designed and developed complex PL/SQL programs which included extracting, transforming and loading of data across multiple databases using distributed transactions and PL-SQL tables. Also created shell scripts to automate and schedule the tasks.
  • Created custom API's (Application Programming Interface) for database interface and requests made by web applications and tools.
  • Loaded data files from multiple sources and formats into Oracle tables using External tables and SQL*Loader features.
  • Involved in consolidation of databases. This included combining the objects and eliminating duplications from instances and schemas.
  • Was involved in installation and administration of MYSQL database including creation of users and objects.
  • Participated in performance tuning of SQL queries and database optimization. This included identifying bad queries using Explain Plan, SQLTrace and TKPROF and resolving them by adding hints and indexes. Also implemented table partitioning for maximum efficiency to boost performance.
  • Managed Rollouts for all the database side project releases by working in a team with business, and technology group.
  • Provided system support which included data/image propagation process from multiple databases.

Environment: Oracle 10g (RAC), Linux 2.6, SQL*Loader, Erwin

Confidential, Oakbrook, IL Oct 2000 to April 2001 Client: Confidential, Chicago, IL Database Consultant/Developer Roles and Responsibilities:

  • Data Modeling and Normalization of the back-end database using Erwin.
  • Developed extensive PL-SQL procedures, functions and triggers for maintaining data integrity
  • Performed data replication from remote databases using Snapshot mechanism.
  • Implemented the credit card payment processing options via the Internet, using Paylinx Payment Server.
  • Performed application tuning in Oracle by identifying slow queries and tuning.

Environment: Oracle 8.1.5, Coldfusion, Erwin 3.5

Confidential, Nov 1998 till Sept 2000 Client: Confidential, Cincinnati, OH Application DBA Roles and Responsibilities:

  • Involved in reverse-engineering of the existing MS-Access database from a Win95 system using Erwin and forward-engineering the database to Oracle using Erwin tool.
  • Implemented all the changes made to the database instance and schemas through the data model following all the necessary Erwin Standards (like physical properties, volumetrics, sizing etc.)
  • Developed PL-SQL stored procedures called by the front-end client server application module.

Environment: Oracle 8.0.5.0.0, PL/SQL 8.0.5.0.0, Erwin 3.5, SQL Loader 8.0.5.0.0, Visual Basic 6.0

Confidential, Bombay, India. July 1995 till Oct 1998 Client: Confidential, Barrington, IL Application Developer Roles and Responsibilities:

  • Developed the Front-End client using Visual Basic and writing SQL queries for the same for accessing data from the back-end. Also, prepared test plans for unit testing of the module developed.
  • Involved in testing, implementation, maintaining, enhancement and bug fixing of the developed software.
  • Documented the system and code as per standards.

Environment: Oracle 7.3, Visual Basic 4.0 using Oracle Objects for OLE

Objective: Seeking a challenging position in the area of database administration and software development.

Profile:

  • More than 15 years experience as a software engineer with a proven background of technical problem solving. This includes development, data modeling and Data Base Administration of Oracle/MySQL databases (OLTP/Data Warehouse).
  • DBA experience of databases sized greater than 1T and also having more than 1000 tables (includes partitioned/sub-partitioned tables) in a multi-node clustered (RAC) database.
  • Strong experience in developing and maintaining relational databases including backup/recovery procedures.
  • Good understanding of the Oracle RDBMS architecture including underlying objects, schemas/products, database objects, file system structure, tables, views, packages, procedures, sequences, indexes, partitioning and constraints.
  • Strong knowledge of OLTP, data warehousing and Internet technologies from both technical and business perspectives.
  • Deep understanding of technology with focus on delivering business solutions.
  • Extensive experience in working with teams on critical and most difficult projects.
  • Expertise in developing complex PL-SQL programs.
  • Motivated self-starter, cooperative and team oriented with multi-tasking abilities - eager to increase/improve skill set.

Education: Bachelor of Engineering (Computer Science)

Certifications and training: Oracle Database 10g Administrator Certified Professional (OCP) Sun Java 2 Certified Programmer (SJCP 2) Training - Oracle Database 10g: Administration Workshop II Release 2

Technical Skills:

Languages : Java 2, Oracle SQL-Plus, SQL, PL/SQL, Shell Scripting, C, HTML 4.0, Visual Basic, JavaScript Database Technologies: Oracle 8.0/8i, 9i, Oracle 10g (RAC), Oracle 11g RAC (Highly Available GRID), MySQL 5.1, MS Access 2003 Operating Systems : Windows (2000, XP, Vista), Linux 2.6. (Red Hat 5.4, Centos 5.2, OEL), Solaris Unix, SCO Unix, MS/DOS Tools : Erwin 7.0, ER/Studio, DB Artesian, EM. SQL*Loader, Toad, SQL --Navigator, PL-SQL developer, TKPROF, AWR, ADDM, Quest, Clear Case, Visual SourceSafe 5.0, PVCS, MySQL Administrator, MySQL WorkBench 5.2, MySQL Query Browser

Professional Experience:

Confidential, Chicago IL Nov '10 till Date Data Architect/DBA Consultant (Oracle 10gR2) Roles and Responsibilities:

  • Performed logical and physical database design at the object level using Erwin. This included design of tables which were partitioned and sub-partitioned for Oracle 10gR2 database.
  • Generated DDL scripts from Erwin and created objects in the database across multiple environments. This included complicated objects like snapshots and remote views across multiple databases using db-links.
  • Assisted developers with application design and performance tuning of complex queries. This included using the dictionary tables, AWR reports and other tools.
  • Provided support for development and production systems (weekly on call rotation). This also included offshore support.
  • Followed the company's processes which included coordinating with various departments to deploy changes in production database.
  • Maintained the enterprise data model repository using Erwin Model Mart Software.

Confidential, Chicago, IL May '01 till Oct '10 Systems DBA (Oracle 11g and MySQL) July '05 till Oct '10 Roles and Responsibilities:

  • Led Oracle upgrade project from 10g (non-ASM) to 11gR2 ASM (HA Grid) -- Converted an 8 node 10g RAC to 5 node RAC. This included installing 11g GRID, ASM instance, multipath, ASM disk creation, SCAN (Single Client Access Name) and creating clustered 11g Oracle databases.
  • Created Backup/Restore procedures and strategies. This included using RMAN/Flashback Technology. Backup mechanisms included using Data Pump exports, RMAN hot backups, and customized automated scripts. Also involved in managing the on-site backup and recovery process and support the off-site backup and recovery teams at the Data Center.
  • Created a process for Disaster Recovery simulation. This included getting the last production backup before the disaster and restoring it on a new host machine.
  • Periodic refresh of QA, INT and DEV test database environments using SNAPSHOT/COPYRESTORE method. Here a SAN snapshot is taken and a copy is made. The LUN is presented to the test host machines and then the LUNS are imported. The databases are then brought up as test databases by renaming the database.
  • Heavy involvement in performance tuning. This included tuning SQL queries, adding indexes. Was in charge of monitoring and finding the worst performing processes and queries based on CPU, Active time, I/O from a QUEST tool (performance analysis) and then tuning it as per needs.
  • Created and maintained Materialized view databases to create non-master sites kept in sync using replication. These views were created as read-only on multiple host machines. They were kept in sync with the master by frequently refreshing the data from the master site tables by setting up refresh groups that replicated to the materialized view sites. The idea was to distribute the user load across multiple database servers which were then accessed by the Front End client applications.
  • Involved in consolidating databases to cut down costs. This included running multiple databases on fewer host machines. Also included optimizing system operations, resource utilization and performing system capacity analysis and planning. Santosh Vaidyanath 3/4
  • Daily activities include configuration, operation and tuning of databases. Also included security management, instance performance monitoring, tablespace utilization, schema object management, database capacity planning, "bottlenecks" and "offensive" SQL activity monitoring and resolution.
  • Practical knowledge of tracing and debugging. This included generating trace file reports using TKPROF, AWR, ADDM and interpreting them to optimize the performance of the databases.
  • Experience with planning, coordination, implementation, logging and tracking.
  • Created monitors and alerts for user sessions, concurrent processes, table extents and locks for production and test/development systems. Also created index rebuild and update statistics scripts.
  • Provided 7x24 DBA production support where I worked with the DBA team for production on call support rotation
  • Supported oracle users and developers with database application releases, also involved in assisting developers with application design and architecture.
  • Performed physical database design at the object level using Erwin, create DDL scripts, define database objects, table partitions and external tables for the databases -- both OLTP and Data warehouse.
  • Planned for and executed required database upgrades and migration (patches etc.)
  • Good hands on experience using the following Tools -- TOAD, SQL-Navigator, Enterprise Manager, PL-SQL Developer, DBArtisan.
  • Installed MySQL 5.1 database on multiple host machines. This included setting up replication (master-master and master-slave configuration for High Availability). Also involved in daily operation and management of the database, user/database creation, finding bad queries and tuning them.
  • Experience with the MySQL Tools -- MySQL Administrator, MySQL WorkBench 5.2, MySQL Query Browser.

Data-Modeler/DBA May '01 till June '05 Roles and Responsibilities:

  • Created logical and physical Data Models using Erwin on a large scale for various business requirements/projects. Also, generated the objects for Oracle/Access databases. This was done for OLTP and data-warehouse applications.
  • Maintain the Enterprise data model repository using Erwin ModelMart Software
  • Involved in Oracle upgrades from 8i to 9i and from 9i to 10g which included the necessary environment and code changes.
  • Designed and developed complex PL/SQL programs which included extracting, transforming and loading of data across multiple databases using distributed transactions and PL-SQL tables. Also created shell scripts to automate and schedule the tasks.
  • Created custom API's (Application Programming Interface) for database interface and requests made by web applications and tools.
  • Loaded data files from multiple sources and formats into Oracle tables using External tables and SQL*Loader features.
  • Involved in consolidation of databases. This included combining the objects and eliminating duplications from instances and schemas.
  • Was involved in installation and administration of MYSQL database including creation of users and objects.
  • Participated in performance tuning of SQL queries and database optimization. This included identifying bad queries using Explain Plan, SQLTrace and TKPROF and resolving them by adding hints and indexes. Also implemented table partitioning for maximum efficiency to boost performance.
  • Managed Rollouts for all the database side project releases by working in a team with business, and technology group.
  • Provided system support which included data/image propagation process from multiple databases.

Environment: Oracle 10g (RAC), Linux 2.6, SQL*Loader, Erwin

Confidential, Oakbrook, IL Oct 2000 to April 2001 Client: Confidential, Chicago, IL Database Consultant/Developer Roles and Responsibilities:

  • Data Modeling and Normalization of the back-end database using Erwin.
  • Developed extensive PL-SQL procedures, functions and triggers for maintaining data integrity
  • Performed data replication from remote databases using Snapshot mechanism.
  • Implemented the credit card payment processing options via the Internet, using Paylinx Payment Server.
  • Performed application tuning in Oracle by identifying slow queries and tuning.

Environment: Oracle 8.1.5, Coldfusion, Erwin 3.5

Confidential, Nov 1998 till Sept 2000 Client: Confidential, Cincinnati, OH Application DBA Roles and Responsibilities:

  • Involved in reverse-engineering of the existing MS-Access database from a Win95 system using Erwin and forward-engineering the database to Oracle using Erwin tool.
  • Implemented all the changes made to the database instance and schemas through the data model following all the necessary Erwin Standards (like physical properties, volumetrics, sizing etc.)
  • Developed PL-SQL stored procedures called by the front-end client server application module.

Environment: Oracle 8.0.5.0.0, PL/SQL 8.0.5.0.0, Erwin 3.5, SQL Loader 8.0.5.0.0, Visual Basic 6.0

Confidential, Bombay, India. July 1995 till Oct 1998 Client: Confidential, Barrington, IL Application Developer Roles and Responsibilities:

  • Developed the Front-End client using Visual Basic and writing SQL queries for the same for accessing data from the back-end. Also, prepared test plans for unit testing of the module developed.
  • Involved in testing, implementation, maintaining, enhancement and bug fixing of the developed software.
  • Documented the system and code as per standards.

Environment: Oracle 7.3, Visual Basic 4.0 using Oracle Objects for OLE

Hire Now