| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateCandidate's Name Email:EMAIL AVAILABLESr. DBA Mobile: PHONE NUMBER AVAILABLEHartford, CTPROFESSIONAL ABRIDGEMENT Aspiring for challenging assignment and responsibility and workenthusiastically in team to achieve goal of the organization with devotionand hard work. PROFILE SUMMARY . Over 12 Years of diversified experience in Oracle Database administration and Maintenance of Databases. . Oracle 10g,11g,12c ,19c Database creation. . Extensive Knowledge on Oracle Architecture . House Keeping activities of Archive logs and Trace files . Experience in handling production database support and maintenance as well. . Taking scheduled backup as per backup strategy using RMAN. . Configured and maintaining RMAN to take backup of the Oracle databases. . Monitoring performance using AWR Reports and ADDM Reports . Switchover, Failover, Activating the Standby to Primary and No data loss. . Involved in Database Cloning. . Managing and monitoring the Indexes for better performance. . Expertise in installing different versions of Oracle on Linux and Windows. . Experience in Backups like Logical Backups (Exp, Imp, Data Pump). . Experience in query optimization using Performance Tuning using Explain Plan. . Hands on experience in creation of views and materialized views. . Have Knowledge in RAC. . Having experience in DATAGAURD. . Experience in Database Upgrade and Migration. PROFESSIONAL EXPERIENCEEvernorth (Cigna)Oct'23 - PresentDesignation: Sr. DBAEnvironment: Linux, WindowsTechnologies Used: oracle 11g,12c, OEM12c. > Installing Oracle binaries. > Creating Oracle databases through DBCA and OEM. > Scheduling Backups in OEM. > Installing patches in 11g and 12c databases. > Upgrading Databases from 11g to 12c and to 19c through DBUA and OEM. > Downgrading 12c databases from 12c to 11g. > Handling database operations and solving user issues. > Successfully completed Migration of Databases from legacy servers to RAC servers. > Taking backup through RMAN and database Restoration. > Analyzing the AWR reports. > Check the performance of the database and tune as when requires using tools AWR, EXPLAIN PLAN. > Experience in Performance Tuning. > Recovered table using RMAN.Regeneron PharmaceuticalsAug'2022 - Oct'2023Designation: Sr. DBAEnvironment: Linux.Technologies Used: oracle 11g,12c,OEM12c. > Installing Oracle binaries. > Creating Oracle databases through DBCA and OEM. > Scheduling Backups in OEM. > Installing patches in 11g and 12c databases. > Upgrading Databases from 11g to 12c through DBUA and OEM. > Downgrading 12c databases from 12c to 11g. > Handling database operations and solving user issues. > Successfully completed Migration of Databases from legacy servers to RAC servers. > Taking backup through RMAN and database Restoration. > Analyzing the AWR reports.Digital EllipsisJune'2017 - July'2022Designation: DBAEnvironment: Linux.Technology Used: Oracle 12c, SQL * Plus, Toad, Toad Data Modeler. > Controls and links the flow of all the Network and Technology IT systems. > Ensuring the Data Security with the SPI Mask Automation using the PL/SQL procedures and UNIX shell scripts which send out the updates regularly. > Data refresh from production to other environments and systems using SQL loader or Export/Import Utility. > Created and managed table spaces, data files, resizing and adding new data files etc > Created new user accounts, profiles, roles and assigned them to different users > Monitoring alert log on time base for critical errors, and space utilization issues. > Taking the backup of the database regularly using Logical, Cold and Hot Backups.Technosoft EngineeringOct'2011 - May'2017Designation: DBAEnvironment: Linux.Technology Used: Oracle 11g, SQL * Plus, Toad, Toad Data Modeler. > BDMS is a centralized golden source for both DSL and FTTP network of Verizon Network systems. > Appreciated by Development Managers for automating the interfacing tasks and improving the handshake between systems. > Maintaining Data Consistency across all the environments of the system by replicating the data and taking backup at regular intervals. > Taking backups using RMAN > Performed Database Cloning from Production to Test environment > Performed Query Tuning by Explain Plan and Tkprof utilities > Used ADDM for taking the advisories. > Monitoring and optimizing the performance of the Database through AWR. > Implemented ASMM feature in Memory Tuning. > Configured Data guard for production Database > Monitoring and maintaining Oracle cluster DB's for their Optimal Performance and ensuing 100% availability of the DB's. > Performed Index Rebuilding > Allocating and reorganization of table spaces > Backing up database using export/import. > Maintenance and monitoring of Database and Listener. > Checking Alert log, trace files, listener log and other database job logs. > User creation and providing necessary Roles, Privileges and quota as per the > Requirement. > Decommissioning of Schema's as per approved requests. EDUCATIONAL DETAILSBachelor of Technology (Electronics and Telecommunication), AmityUniversity - 2007-2011 |