We provide IT Staff Augmentation Services!

Team Member (sr Dba) Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • More than 8 years of professional work experience in the IT Industry with domain expertise in Telecom and Banking Domain as a DBA.
  • This includes management of production, development and test databases and very good experience in configuration of different high availability Oracle technology like Oracle Cluster - ware, Golden Gate and Data Guard.
  • Well versed in SQL, PL/SQL, MongoDB, PostgreSQL and shell scripting. Worked extensively on development, enhancement, data migration and maintenance projects.
  • Ability to rapidly achieve and easily assimilate job requirements, and aggressively employ new methodologies.
  • Ability to install Oracle 9i, 10g, 11g,12c database and client s/w on Red Hat Linux and Oracle Linux.
  • Ability to configure physical stand by server.
  • Good Knowledge of patching operation and the ability to apply patching on single instance and data guard configuration of 11g and 12c databases.
  • Configuring and Administering Oracle Automatic Storage Management (ASM) using Oracle 11g and 12c grid infrastructure.
  • Configuration of Oracle 11g and 12c Grid infrastructure on Oracle Linux and RH Linux. Add / delete node in oracle 11g RAC infrastructure
  • Configuration of single and two way DDL and DML infrastructure. Configured Golden Gate for initial load and change synchronization. Configured Oracle Golden Gate processes for DML & DDL replication .
  • Good knowledge of creating Users, Roles, assigning privileges to Roles and assigning default tablespace and quotas on tablespace to users.
  • Knowledge of configuring Listener and tnsnames.ora files. Troubleshooting using lsnrctl, tnsping, ping, listener log and trace files.
  • Ability to take hot & cold backup. Ability to perform recovery from loss of one or all Control files, Redo files, Data files manually and using RMAN. Good exposure of Logical backup using Data Pump.
  • Configuration of 12c and 13c Oracle Enterprise Manager Cloud in Oracle Linux and RHEL. Add / delete target server from OEM and agent deployment on target system.
  • Knowledge of Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM), Active Session History (ASH) for monitoring database performance.
  • Ability to install MongoDB version 3.0* to 4.0* database and client s/w (MongoDB shell) on Red hat Linux and oracle Linux.
  • Ability to install and configure ops manager version 4.0 on Oracle Linux and Red hat Linux. Add / Delete target server from ops manager. Add and remove ops manager agent.
  • Knowledge of configuring replication set and shard on Red hat Linux and Oracle Linux.
  • Knowledge of installing PostgreSQL Enterprise DB on oracle Linux, Red Hat Linux, Ability to Migrate Oracle Database to PostgreSQL Enterprise DB. Backups and Recover Operation on PostgreSQL, Knowing User and role management on Enterprise DB and PostgreSQL and Tablespace Management in Enterprise DB.
  • Ability to install and configure Jenkins on Oracle Linux, Red Hat Linux. Adding/Deleting Slave Node from Jenkins, ability to create Jenkins jobs for registered nodes.

TECHNICAL SKILLS:

Operation System: UNIX, Linux, Sun Solaris, HP-UNIX, Linux, DOS and Windows.

Language: PLSQL, SQL, shell scripting

Database: ORACLE 12c, 11g, 10g, 9i, mongo DB. postgreSQL

Tool: Toad, Putty, Sql*, Sql* loader, Sql Developer, OEM, Import Export, ASM, Oracle GG. Mongo ops manager, Mongo compass, Robo 3T, psql, pgAdmin4.

Domain Knowledge: Telecom, Banking finance. project details

PROFESSIONAL EXPERIENCE:

Confidential

Team member (Sr DBA)

Environment: Language: sql, plsql, Linux shell scripting.

Database: oracle 11g,10g

Tools: Toad, Putty, OEM, Golden Gate

O/S: UNIX, Sun Solaris, HP-UNIX, Linux, Dos and Window.

Confidential

Team member (Sr DBA)

Environment: Language: sql, plsql, Linux shell scripting.

Database: oracle 11g,10g

Tools: Toad, Putty, OEM, Golden Gate

O/S: UNIX, Sun Solaris, HP-UNIX, Linux, Dos and Window.

Confidential

Team member(Sr DBA)

Environment: Language: sql, plsql, Linux shell scripting.

Database: oracle 11g,10g

Tools: Toad, Putty, OEM, Golden Gate.

O/S: UNIX, Sun Solaris, HP-UNIX, Linux, Dos and Window.

Responsibilities:

  • Develop database (DB) performance collection for faster analysis and root cause Identification.
  • 24x7 production support for several mission critical system which utilize multiple Oracle database.
  • Perform database activities required for the health of the application and release Process (i.e. backup restore (exclude enterprise backup and restore), recover, importExport, copy move and performance tuning activities).
  • Analyze database activity, perform application database performance and tuning activities in the pre-production and production database.
  • Perform analysis and reporting of result from processing and database monitoring.
  • Perform activities of data maintenance, table maintenance, database re-organizations, Cache tuning, data archival, data import/export between environments and other effort typically undertaken to improve the efficiency and reliability of application and database.
  • Maintain database alarming.
  • Configure the database structure as per the Application in UNIX to Linux migration.
  • Oracle Golden Gate process monitoring and maintenance.
  • Configured the Golden Gate one-way replication for few main tables to third party Application Database.
  • Keep all third-party DBMS- related software within Confidential & Confidential TSS Standard or properly Filed and approved.
  • Open and track vendor PMRs and SRs opened by DBA team and escalate as necessary for timely resolution of Confidential & Confidential -impacting issue.
  • Participate in the VPMO process providing input on any database related item (e.g. complete database questionnaires)
  • Work with PDBA to keep DBMS on currently levels per Confidential & Confidential TSS Standard and coordinate upgrade with impacted application and support organization.
  • Decision To upgrade DBMS should be taken by development team in it should be scoped via scoping team.
  • Maintain stability of production database, including acting as the database facilitator and insuring that external team (such as the physical Database Administration (PDBA)) is engaged when there are problem that impact the database but which the ADBA team does Not have direct control.
  • Proactively and periodically review capacity planning needs of the applications to ensure the stability of the database.
  • Deploy software changes needed to fix application defects or performance problem.
  • Using data pump and Export/Import for transferring data from on database to another.
  • Use Automatic Workload repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for monitoring database performance.
  • Database growth and space management, capacity planning, table partitioning, distributing the table, redo logs, archived redo logs and rollback segment on different disk to optimization data retrieval.

Confidential

Team member(Sr DBA)

Environment: Language: sql, plsql, Linux shell scripting.

Database: oracle 11g,10g

Tools: SQL Developer, Putty, OEM

O/S: UNIX, Linux, Dos and Window.

Responsibilities:

  • Installation and configure oracle10g/11g Database and client S/W, configure network files.
  • Create user profiles granting specific privileges and role to the user.
  • Maintain table space, data files, control files, and online redo log files.
  • Taking RMAN backups (scheduling for day wise backup).
  • Monitoring Undo table space, temporary table space and taking proper actions.
  • Monitoring Alert log file, Application log file.
  • Configuration of oracle ASM/RAC instance using 11g Grid infrastructure S/W.
  • Configuration of oracle Grid/RAC infrastructure on oracle Linux and RHEL.
  • Oracle Administration Authentication Method.
  • Create database links for data sync from one environment to other.
  • Resolving listener issue, Network issue.
  • Configure of oracle client Authentication using Oracle wallet.
  • Check the table, index, partition, sub partition status.
  • Monitoring application and related logs, solved performance related problem.
  • Suggesting tuning solution foe sql queries and database.
  • Efficient in generating PLSQL looping constructs using function, procedures, Triggers and packages.
  • Performance Monitoring the Servers for Better performance.
  • Index rebuilding and Monitoring Index status with the help of view.
  • Synchronize development database server with database prod server using import/export utility and database.
  • Backup and recovery strategies for database using import export/method cold backup.

Confidential

Team member (IT executive)

Environment: Language: sql, plsql, Linux shell scripting.

Database: oracle 11g,10g

Tools: SQL Developer, Putty,TOAD

O/S: UNIX, Linux, HP-UNIX, Dos and Window.

Responsibilities:

  • Perform database activities required for the health of the application and release process.
  • Monitoring the scheduler jobs of vas services.
  • Create and follow up all database and application related CR (change request).
  • Creating user profile grating specific privileges and roles to the user.
  • Managing table space, data files, undo table space.
  • Monitoring undo table space and temporary table space and take appropriate actions.
  • Resolving listener and networking issue.
  • Monitoring application log files solved the performance related problem.
  • Monitoring unbarring process log files and solve related issue.
  • Check table status (Index, partition, Sub partitions etc).
  • Perform purging policies of partition and tables.
  • Suggesting tuning solution for SQL queries and database.
  • Create PLSQL object like procedure, function Triggers as per the requirement.
  • Performance monitoring the Server’s for better performance.
  • Index rebuild and monitoring index status with the help view.
  • Create partition end of month on daily usage tables.
  • Monitoring Server storage (mount point) usage and take care of it using cleanup process.

Confidential

Database Administration

Environment: Language: sql, plsql, Linux shell scripting.

Database: oracle 9i,10g

Tools: SQL Developer, Putty, OEM

O/S: UNIX, Linux, HP-UNIX, Dos and Window.

Responsibilities:

  • Installation and configuration oracle 10g/9i client software, Configuration network file.
  • Installation oracle database server for development and sync database with production database using import/export and database link.
  • Taking backup off database using RMAN utility.
  • Logical backup using import/export utility.
  • Monitoring alert log file using alert mails.
  • Creating user profile grating specific privileges and roles to the user.
  • Managing table space, data files, undo table space.
  • Monitoring undo table space and temporary table space and take appropriate actions.
  • Check table status (Index, partition, Sub partitions etc).
  • Perform purging policies of partition using transfer partition data to archiving database table.
  • Suggesting tuning solution for SQL queries and database.
  • Create PLSQL object like procedure, function Triggers as per the requirement.
  • Performance monitoring the Server’s for better performance.
  • Index rebuild and monitoring index status with the help view.
  • Create partition end of month of daily usage tables.
  • Monitoring Server storage (mount point) usage and take care of it using cleanup process.

We'd love your feedback!