SUMMARY

• 10 years of IT experience as Database Administrator on multiple platforms and environments which includes Oracle 9i, 10g, 11g and 12c, MongoDB v3.2, v3.6 and v4.0, MariaDB v10.3 and AWS instances in managing Development, Test and production environment on Linux, Solaris, Aix and Windows Platforms.
• Involved in all phases of teh SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance wif timely delivery against aggressive deadlines.
• Administrated Oracle Databases on Engineered systems like EXADATA X2 - 2, X4-2, X5-2, X6-2 and X7-2 and ODA (Oracle Database Appliances) machines.
• Well-versed wifCELLCLI, OAKCLI command line utilities to manage Exadata & ODA Appliances
• Closely work wif Oracle Support for Exadata & ODA Appliance maintenance from server, storage, network and hardware issues
• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• Migrated 11g databases using goldengate wif minimal down time.
• Configured ACTIVE-ACTIVE Goldengate setup for teh databases in different data centres.
• Installed, configured and upgraded oracle GOLDENGATE 11.2.1.0.x, 12.1.2.1.0 unidirectional and Bi-directional replication.
• Configured oracle Goldengate classic and Integrated capture modes on Linux servers.
• Configure DML / DDL replication based on customer requirement
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Built ADG (Active Data Guard) databases for Exadata databases.
• Installed 11g, 12c 2 and 3 node RAC Grid Infrastructure and DATABASE on Linux.
• Experienced in installation and maintenance of ORACLE 11g and 12c RAC 2 node and adding a node to dis cluster database for high availability.
• Experience in Oracle 11g/12c RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation.).
• RAC Clusterware administration, Configuration, Patching, RAC Backup and Recovery.
• Experience in Dataguard configuration, implementing and monitoring standby databases.
• Hands on experience in Grid control, Streams, Goldengate Replication.
• Performance Tuning: Tuned various large critical OLAP and OLTP databases of Tera bytes size using various tools like STATSPACK, AWR, SQL Trace, Tkprof, Analyze, ADDM and Explain Plan Methods.
• Installed and configured Oracle Enterprise Manager (OEM) 13c and 12c, Grid Control 11g and Grid control 12c for database monitoring/performance/diagnostics/patching.
• Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).
• Experience in LOGICAL BACKUPS and Database migration tools wif DATA PUMP, Export/Import and Transportable tablespaces.
• Good experience in PATCHING and UPGRADATION.
• Expertise in upgrading Oracle Development and Production databases from 10g to 11g and 12c.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers and extensively used TOAD, SQL Developer and Studio 3T for querying databases etc.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) / Network Attached Storage (NAS).
• Experience in database cloning wif RMAN, Capacity Planning, Database Refresh and patch management.
• Experienced in maintaining databases on large Development, Test, Staging and Production environments.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Experience in managing life cycle of MongoDB including sizing, automation, monitoring and tuning.
• Installed MongoDB, Created setup replica sets, Sharding and clusters.
• Upgraded Mongo database server from MongoDB v3.0 to v3.2 and v3.2 to v3.4.
• Experience on MongoStat, Mongotop, serverStats, dbstats, collStats for diagnosing databases statistics.
• Backup/Restoration of Database through Mongodump/Mongorestore utility.
• Experience in Migrating databases from Oracle to MongoDB wif .CSV using Mongodump and Studio 3T tools.
• Deployed Mongo 4.0 Ops Manager High Availability application and configured Replica sets, Alerts, Backups.
• Installing and administering MariaDB server database.
• Configure and manage MariaDB master slave servers, Galera cluster.
• Backup and restore MariaDB databases.
• Experience in Amazon Web Services (AWS) provisioning and good knowledge of AWS services like EC2, S3.
• Created playbooks for migration of on-premises databases to AWS 3 TIER architecture ec2 instances
• Worked on Creating VPC, subnets, Security groups, EC2, Amazon RDS Oracle, installing multiple software on EC2
• Created POC environment for migrating on- premises databases, application to AWS
• Worked on EC2, installed oracle databases, created AMI and cloud formation templates for automation and creation of EC2 instances for multiple environments
• Used Datapump for migration to on premises and also used Amazon DMS to move data from on-premises databases to oracle and Aurora Database
• Excellent Communication skills, co-ordination and communication wif system administrators, business data analysts and development teams.

TECHNICAL SKILLS

RDBMS, NOSQL, CLOUD: Oracle 9i, 10g, 11g, 12c, MONGODB v3.2, v3.6, v4.0, MariaDB v10.3, AWS

High Availability, Tuning & Monitoring Products: Oracle 10g, 11g RAC, ASM, Data Guard, 10g, 11g, 12c Grid Control (OEM), Tkprof, Statspack, AWR, GOLDENGATE, ADDM, ASSM, Veridata, Mongo Shards, Mongo replica sets, Galera cluster

Operating Systems: Solaris 9/10, Linux RHEL 6/5, HP-UX 10.x/11.x, AIX 5.2/5.3, Microsoft Windows 2000/2003/2005, UNIX, Centos 7

Tools: & Utilities: Oracle SQL Developer, PL/SQL Developer, TOAD, RMAN, BMC Remedy, Export/Import, EXPDP/IMPDP, SQL Loader, SCP, FTP, SFTP, Mongo Import, Mongo Export, Mongo dump, Mongo restore, Mongoop log OPS manager, Studio 3T

Backup Tools: NetApp, TSM, EMC, RMAN, Data pump, AVAMAR,, Mongo dump

MS Office Tools: Excel, Word, PowerPoint, Outlook, Visio

Programming Languages: C, C++, Asp.Net, XML, HTML, DHTML, CSS, Java

PROFESSIONAL EXPERIENCE

Confidential, Mountain View, CA

Sr. Database Administrator

Responsibilities:

• Worked on Data center migration project, Responsible for capacity planning, designing, and implementing Oracle high availability as a part worked wif Infrastructure team, engineering team and production support.
• Performed Oracle RDBMS 12c/11g, OEM 13C and MariaDB 10.3 installation in Linux and Windows.
• Administrated Oracle Databases on Engineered systems like EXADATA X2-2, X6-2 and X7-2 and ODA (Oracle Database Appliances) machines.
• Worked on Exadata/ODA disk failure issues
• Upgraded ASM database compatibility from 11.2.0.4 to 12.1.0.2
• Used Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• Moved tablespaces from one disk group to another
• Applied PSU quarterly patches and bug fixes on EXADATA and ODA databases
• Installed and configured Goldengate 12.1.2.1.0 on RHEL
• Configured Extract and Replicate pumps for Goldengate replication 11g/12c and troubleshooted issues using report files and logdump.
• Applied patches to teh Goldengate home 12c and upgraded Goldengate, Used Logdump Utility to Investigate data on teh trail, defgen utility to create definition files.
• Configured both classic/integrated extract and replicate and also converted classic to integrated.
• Installed, Configured and Monitored STREAMS and GOLDENGATE unidirectional replication.
• Configured HEART BEAT table on source and target to find goldengate LAG.
• Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Troubleshooted teh problems regarding teh databases, applications and development tools.
• Implemented Active Dataguard, creating both Logical and Physical Standby databases in 11g & 12C environment for teh Production databases.
• Configured and managed DataGuard extensively for Production databases of sizes ranging from 50GB to 5TB.
• Performed migration of RAC databases using Dataguard from old hardware to new hardware using active wif minimum down time, Converted Physical standby to Snapshot Standby 11g, 12c
• Configured Physical Standby databases using data guard in maximum performance mode, Configured Active Dataguard 11g Troubleshooting Out of sync issues in Data Guard environment
• Configured Dataguard Broker and used for switchover and stopping and Starting Media recovery process and Performed Disaster Recovery testing
• Experience in Data guard, Oracle RAC, ODA, Golden gate, Scripting and DB patching.
• Installed and configured OEM 13CR3 to monitor Oracle Databases.
• Apply Oracle quarterly patches (PSU/CPU) usingOpatch Utility and from OEM Cloud Control
• Monitoring all databases using OEM 13c and Tuned database and poor SQL queries using OEM 13c (awr, ADDM, ASH, Tuning Advisor, etc.,) Explain plan and OS watcher tools, Remediate all database related SPLUNK alerts.
• Implemented OEM 13C repository database, OEM 13C agent installations.
• Cloning/duplicate of database wif RMAN and user-managed (hot/cold) backups.
• Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes.
• Also worked on Network data encryption to improve teh security and also implemented SSL wallet to secure teh connections.
• Database Services creation for distributing teh applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD, Redefinition of tables using DBMS REDEFINITION, partitioning teh tables in teh production, re-defining teh columns data types, and moving teh LOBS to different tablespace
• Partitioned tables Maintenance, adding new partitions, exchanging one-year old partitions tan archiving of teh exchanged partitions, dropping or truncating of old portions.
• Implemented 11g Interval Partitioning for monthly partitioning of large tables.
• Developed RMAN backup strategies for cloning teh test databases wif teh production environment and worked on RMAN active-active duplication.
• Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER and Crontab.
• Worked on different RAC related issue: hangcheck timer, split brain, hugepages setup etc. ; Troubleshoot performance issues for teh RAC instances (GC events)
• Resolved/Diagnosed Node Eviction issues.
• Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
• Installed, Administered, and Optimized MongoDB instances.
• Installed and run Mongodb wif multiple instances on servers.
• Implement MMS monitoring and backup (mongoDB Management Services) on local servers (on-premise).
• Manage and Monitor large production Mongodb sharded cluster environments having terabytes of teh data.
• Automate routine tasks via scripts and tools.
• Configured, implemented and supported high availability (Replication) MongoDB cluster.
• Configured, implemented and supported High Availability (Replication) wif Load balancing (sharding) cluster of Mongodb having TB’s of data.
• Backup and restore mongo databases.
• Optimizing MongoDB CRUD Operations.
• Disaster Recovery setup and best practices, including planning, testing, failover testing.
• Added replica and shard nodes in Mongodb Cluster as needed.
• Pro-actively identified, troubleshooted and resolved live MongoDB issues.
• Worked wif Development, Storage and Network teams in installation and administration of MongoDB in teh IT Enterprise Environment.
• Documenting MongoDB installation, operations, security, and environments.
• Installed and administered MariaDB server database.
• Configured and managed MariaDB master slave servers, Galera cluster.
• Backup and restore MariaDB databases.
• Participate in 24x7 on-call support when required for production databases

Environment: /Tools: Oracle 12c/11g, VMWARE, JIRA, RHEL 6.x/5.x, CentOS 7 ASM 12c/11g, 13c/12c OEM (Grid Control), RMAN, Data Guard, Goldengate, SQL Developer, Data Pump, OS watcher, Toad, PUTTY, MongoDB 3.6/4.0, Mongo Import, Mongo Export, Mongo dump, Mongo restore, Mongoop log OPS manager, Studio 3T, MariaDB 10.3.

Confidential, Atlanta, GA

Sr. Database Administrator

Responsibilities:

• Designing, Creation and maintaining of Oracle 11g databases for various applications and supporting teh same during deployments.
• Installed 11g & 12c multi Node RAC &Grid infrastructure installation on RHEL 5/6.x servers.
• Used Explain Plan, Oracle hints and creation of new indexes to improve teh performance of SQL statement and migrated databases from Physical server to VMWARE servers.
• Configured Oracle Data guard (ADG) for Oracle Disaster recovery on standalone databases using 11g ACTIVE DUPLICATION.
• Experience in administrating Exadata x5-2, x4-2 Half Rack environment.
• Provide and implement performance-tuning recommendations of all components in Exadata database machine.
• Configured replicate on target databases from Oracle server to SQL server using Goldengate replication. Configured oracle Active-Active (Bi-directional) golden gate replication and setup CDR.
• Migrated 11g databases to different servers using golden gate wif minimal down time.
• Upgraded oracle goldengate from 11.2.0.3 to 11.2.0.4 version and Installed 12c, Configured Integrated extract and integrated replicat performance and testing.
• Configured HEART BEAT tables on source and target to find goldengate LAG.
• Encrypted Golden gate passwords and TRAIL files at Source and Target side.
• Experience in Administering Oracle 11g and 12c Databases using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
• Converted OLTP non-partitioned tables to partitioned tables using online redefinition and datapump methods
• Involved in teh Migration projects by using Data pump and RMAN utilities.
• Applied CPU and PSU patches for all teh development, QA and pre-prod servers when required.
• Configured 11g Physical standby RAC databases using RMAN active duplication.
• Proficient in using Data pump utility for refreshing databases.
• Used SQL LOADER to upload teh information into teh database tables.
• Daily Health Check Up of teh Database and SQL Queries, 12c OEM, AWR, ADDM, ASH and TKProf.
• 12c OEM agent upgrade on RAC databases.
• Cloned database and schemas using Data pump for 11g and 12c versions.
• Cloned 11g and 12c databases using RMAN duplication (wif and wifout backup).
• Performance Tuning for teh SQL queries by scrutinizing long running SQL queries.
• Scheduled Oracle Jobs and Backups using CRONTAB and OEM 12c grid control.
• Experience in backups and recovery using RMAN shell Scripts.
• Migrated databases from Oracle to MongoDB through CSV file using Studio 3T and Mongo Import Utility.
• Worked wif SA team and Installed, Configured brand new MongoDB databases on Ubuntu and Linux Machines.
• Addition/Deletion of Nodes & RS chaining in Replica set for MongoDB Databases.
• Backup/Restoration of Database through Mongodump/Mongorestore utility.
• Installed MongoDB, created setup replica sets, data scaling and clusters.
• Installed MMS and setup monitoring agents.
• Optimizing, monitoring, performance tuning and understanding of MongoDB.
• Upgraded Mongo systems and involved wif creating shards, replica sets, monitoring, and projections for Mongo Systems.
• Good experience on MongoDB scaling across data centers and in-depth understanding of MongoDB, including replica sets.
• Worked wif other teams and configured VPC, NAT gateways and IAM for MongoDB on AWS cloud.
• Installed and configured brand new server on AWS cloud for MongoDB databases.
• Defined AWS Security Groups, which acted as virtual firewalls dat controlled teh traffic, allowed reaching one or more AWS EC2 instances.
• Installed teh application on AWS EC2 instances and configured teh storage on S3 buckets.
• Implemented and maintained teh monitoring and alerting of production and corporate servers such as EC2 and storage such as S3 buckets using AWS Cloud Watch.
• Created S3 buckets and managed policies for S3 buckets and Utilized S3 bucket and backup on AWS.
• Supported for high-availability solutions for mission critical SQL Server databases, including clustering, mirroring and replication.
• Responsible to provide 24 x 7 database administrative activities over different database servers

Confidential, Kansas City, MO

Goldengate Consultant

Responsibilities:

• Worked wif DBA team in migration project and supported oracle databases
• Installation, configuration, maintenance and tuning of Oracle 11g on Red hat 5.8, RHEL 6.x.
• Successfully migrated Oracle 10g to Oracle 11g and Used OEM 11g/12c to monitor oracle databases on daily basis
• Installation and configuration of Oracle 11gRAC using Cluster ware and ASM.
• Successfully Migrated Non-RAC single instance to Real Application Cluster (RAC) database instances.
• Configured Goldengate extract and replicate during teh database character set conversion.
• Implemented necessary monitoring scripts for Golden gate in Unix/Perl scripting.
• Configured Physical Standby database for 2-node RAC database using Data Guard.
• Configured windows and SQL cluster components and Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
• Database Sizing, Table space Management and Rollback Table Space Management, Transaction Management and Security Administration.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager
• Refreshing Schemas from Production to lower environment using Datapump
• Killed blocking sessions on oracle databases and monitoring Alert logs.
• Applying shipped archived logs to standby databases on using MRP process
• Experience in cloning RAC databases using RMAN tool.
• Gathering stats on databases using DBMS STATS and Automated teh nightly RMAN backups for teh Production and Test Databases in Crontab
• Experienced in Design, implementation and generating documentation of Oracle 11g Data Guard on both physical/logical standby databases in high availability mode.
• SQL tuning and Database performance tuning TEMPhas been done based on reports generated by SQL Trace, AWR, ASH, ADDM and monitor teh database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (wif Export/Import Data pump utilities).
• Created and Scheduled Oracle Backend Process Jobs in Crontab.
• Cloning & duplicating databases using scripts as well as RMAN.
• Expertise in recovering teh database. Performed complete recovery, data file recovery, incomplete recovery.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Autantication, and Audit vault, DB vault.
• Applying security patches both Server side and Client side and Performed testing.
• Used Secure SCP & FTP extensively for teh File transfers from machines to remote server.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Raised SR's wif oracle in case of problems.

Confidential

Oracle DBA

Responsibilities:

• Experience in Design, Creating and maintaining Oracle Databases 9i, 10g and 11g from teh scratch on UNIX, LINUX, AIX and WINDOWS environments.
• Installed 10g & 11g 2 Node RAC & clusterware installation on RHEL 5.x server.
• Installed 11g 6 node production RAC CLUSTERWARE and DATABASE on Linux server.
• Installed ORACLE 12cdatabase and Cloud control (12.1.0.3) on Linux 64-bit server.
• Upgraded oracle database from 11.2.0.2 to 11.2.0.3 and from 11.2.0.3 to 12.1.0.1.
• Implement Oracle TDE (Transparent Data Encryption) column encryption for advanced security.
• Implemented Oracle database WALLET for TDE.
• Regular Refreshing of schemas from oracle database on AIX server to LINUX server using Datapump.
• Experience in Administering Oracle 10g and 11g Databases using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
• Involved in teh Migration projects by using Data pump and RMAN utilities.
• Applying CPU and PSU patches for all teh development and UAT servers when required.
• Upgraded all teh development databases from 9i, 10g to 11gr2 using Manual and DBUA Methods.
• Configured Oracle Data guard (ADG) for Oracle Disaster recovery on standalone databases using 11g ACTIVE DUPLICATION.
• Writing SQL scripts using SPOOL command when required.
• Closely worked wif teh Data modeling team.
• Excellent experience in using Data pump utility for refreshing databases.
• Configured LOGMINER setup for teh standby to capture deleted records from teh primary database.
• Performed Online Redefinition for teh large development and production tables.
• Involved in teh migration of huge databases of sizes ranging from 100GB to 7TB.
• Daily Health Check Up of teh Database and SQL Queries using OEM, Statspack, AWR, ADDM, TKProf and User management and security management.
• Experience in moving teh data from one server to another server using SFTP, FTP and SCP.
• Building new databases and schemas from teh scratch on Linux and UNIX Boxes.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to teh latest Oracle 11gR2 and applied patches as required.
• Regular schema, table and database refreshing from production to development, UAT and SIT environments using RMAN and datapump utility.
• Cloned database and schemas using Data pump for 10g and 11g versions.
• Cloned 10g and 11g databases using RMAN duplication (wif and wifout backup).
• Involvement in space management, rectification of lock problems, user management.
• Responsible to provide24 x 7 database administrative activities over different database servers.
• ASM Disk storage and user Management.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links using SQL scripts.
• Scheduled Oracle Jobs and Backups using CRONTAB and OEM grid control.
• Experience in Online and Offline backups and recovery.
• Experience in backups and recovery using RMAN shell Scripts.
• Troubleshooting Streams and Golden gate errors when occurred.
• Performed Schema as well as Table level Replication using Oracle Streams.

Confidential

Oracle DBA

Responsibilities:

• Experience in Design, Creating and maintaining teh Oracle Databases 9i, 10g and 11g from teh scratch on UNIX, LINUX and WINDOWS environment.
• Configured GOLDENGATE unidirectional in classic capture mode on LINUX.
• Installed and monitored STREAMS one-way replication.
• Involved in teh 10g 2 Node RAC installations on RHEL 5.4 server.
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
• Involved in teh Migration projects extensively using Data pump and Rman utilities.
• Migrated 100GB database from Windows SQL server to Oracle server using SQL Developer tool.
• Excellent in writing SQL scripts using SPOOL command.
• Proficient in using Data pump.
• Involved in teh migration of huge databases of sizes ranging from 100GB to 7TB.
• Daily Health Check Up of teh Database and SQL Queries using Statspack, AWR, ADDM and TKProf.
• Created User accounts, Roles and granting required access permissions and privileges to teh database based on teh applications they are accessing.
• Experience in moving teh data from one server to another server using SFTP, FTP and SCP.
• Building new databases and schemas from teh scratch on Linux and UNIX Boxes.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to teh latest Oracle 11gR2 and applied patches as required.
• Schema Refreshing of databases using normal copy method and exp. /imp utility.
• Cloned database and schemas using Data pump for 10g and 11g versions.
• Involvement in space management, rectification of lock problems, user management.
• Responsible to provide24 x 7 database administrative activities over different database servers.
• Regular Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump utility for oracle 10g and 11g servers.
• Configured Oracle Data guard for Oracle Disaster recovery on standalone database.
• Troubleshooting ORA errors when occurred.
• ASM Disk storage and user Management.
• Performance Tuning for teh SQL queries by scrutinizing teh long running SQL queries.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links using SQL scripts.
• Scheduled Oracle Jobs and Backups using CRONTAB.
• Experience in Online and Offline backups and recovery.
• Experience in backups and recovery using RMAN shell Scripts.
• Performed Schema as well as Table level Replication using Oracle Streams.

Confidential

Oracle DBA

Responsibilities:

• Experience in Design, Creating and maintaining teh Oracle Databases 10g and 11g.
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
• Involved in 10g and 11g 2 Node RAC installation on RHEL 5.4 server.
• Implemented and Monitored Data Guard (physical standby) for standalone Oracle 10g.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for migrating Oracle 10gR2 to teh latest Oracle 11gR2 and applied patches as required.
• Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump, and hot backup scripts.
• Involvement in space management, rectification of lock problems, managed quotas.
• Table partitioning to improve me/O access.
• Responsible to provide24 x 7 database administrative activities over different database servers.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump.
• Alert log monitoring every day in teh production environment.
• Performance Tuning for teh SQL queries, which are running slow and taking more CPU cost.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Restoration and Recovery of databases at teh times of occurrence of critical failures.
• Experience in Online and Offline backups and recovery.
• Experience in backups and recovery using RMAN and Scripts.
• Performed Schema as well as Table level Replication using Oracle Streams.

Confidential

Jr.DBA

Responsibilities:

• Installed and configured oracle 8i/9i databases.
• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Responsible for installing, upgrading and configuring teh Oracle server.
• Creating databases, objects, roles and Granting privileges.
• Partitioned large tables to increase teh Performance.
• Configured scripts to monitor activity wif database.
• Responsible for optimizing teh queries and application tuning.
• Implement Hot, Cold and Logical backup plans.
• Involved in Performance Tuning of SQL Queries
• Creating tables, indexes, views and synonyms depending upon teh need
• Involved in Designing backup and recovery procedures for OLTP systems
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory and operating system