SUMMARY:

• Oracle Certified Associate (OCA) with over 8+ years of experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g, 11g and 12c.
• Experience as On - Call 24x7 production DBA support, application/development DBA, system administrator.
• Monitored physical I/O and Proper sizing of rollback segments.
• Optimized SQL using explain plan, Auto trace feature and TKPROF to analyze the execution plan and tune the statements.
• Tuning of database using Utlstat scripts Statspack and dynamic performance views to monitor system statistics and wait events, AWR, ADDM and Tuning of SGA.
• Installation and configuration of Oracle Golden Gate
• Experienced in using Golden Gate to support data replication in the Oracle database environment
• Able to resolve performance issue in database 12c using automatic big data caching, full database caching, and in-memory aggregation features
• Installed Oracle 12c on Redhat Linux platform using ASM
• Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems.
• Troubleshoot and resolve slowness or performance issues with extensive investigation and follow-up with respective application teams with RCA and proposed solutions.
• Responsible for RMAN backups, and improvement to backup with incremental back by adding block change tracking feature of Oracle 11gR2.
• Created Users, Roles and Profiles, Privilege management with role-based security.
• Performed database tuning using Explain Plan, TKPROF, Statspack, Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) and SQL Trace.
• Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.
• Upgraded Oracle 10g database version to 11g and finally from Oracle 11g database version to 12c version.
• Extensive experience in providing database related services and support to development & QA environments. Good experience of Installation and configuration of RAC (Real Application Server) on different nodes with ASM (automatic storage management).
• Configured Offline and Online Disaster recovery sites to maximized the database availability
• Applied Oracle Patches (CPU/PSUs and One-off patches)
• Strong skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.
• Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, coding, and configuring servers.
• Worked on Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers.
• Worked on Data transferring with export/import utilities and Data pump.
• Extensive experience in Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Extensive knowledge in maintain Oracle Cluster ware using Srvctl, Crsctl, has, ocrconfig, cluvfy, Private IP, public IP, SCAN IP and Virtual IPs along with NAS and SAN for ASM storage.
• Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning. Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listner, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters.
• Advanced knowledge and experience with Designing Database, tuning Database, Database Security & Assigning the Roles, Profiles and Privileges to the various Users on Objects and Maintaining Integrity by applying server enforced, and Optimization by Explain Plan, RAC.
• Expert Oracle DBA knowledge with a good understanding of application performance analysis and tuning expertise and Automatic Storage Management (Oracle ASM)

TECHNICAL SKILLS:

TOOLS: & UTILITIES: Installation, configuration and update of Oracle 11g using OUI, DBCA, DBUA, Monitoring and performance tuning using OEM Console, Toad, SQL Developer, Data pump, Oracle Imp/Exp, Statspack/AWR, ADRCI, ADDM, DRA, Dbms monitor. Database migration using Exp/Imp/Datapump, and SQL Loader

LANGUAGES: SQL, PL/SQL, HTML,CSS, C++, Visual Basic

OPERATING SYSTEMS: Win XP/7/8/10/Server 2003/Server 2008/2012, Linux INTERNET FTP, Telnet, and E-mail, Maxton, Netscape & Net

SOFTWARE: MS Office 2007/2010, Adobe Photoshop, Adobe Illustrator.

Hardware & Networking: Computer assembling and troubleshooting, Experienced in handling LAN, VPN and WAN, Mikrotik Router Configuration

DATABASE: Oracle 6i, 9i, 10g, 11g, 12c

WORK EXPERIENCE:

Sr. Oracle Database Administrator

Confidential, Minneapolis, MN

Responsibilities:

• Ensured and tested ERP based software Insurance Business Management System (IBMS) storage strategies and large data security plan for company’s operational Oracle 11g and 12c database, delivering solution that guaranteed recovery performance and high availability
• Responsible for performing production support activities for data warehouse and transactional servers running Sybase database management software.
• Participated in migration and integration of Sybase database servers.
• Performing replication using Sybase replication agent that captures transactions in oracle primary database and then transfers the transactions to replication server.
• Provide technical assistance for functional and performance testing.
• Provide instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Creating Database users and granting appropriate privilege, Privileges to Users, troubleshooting utilities, stripping of the database, Database Sizing.
• Managed all customer issues with regards to troubleshooting.Oracle RDBMS installation, configuration, administration and
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using Oracle data pump.
• Installed Oracle 12c on Redhat Linux platform using ASM.
• Utilized expertise of database switchovers to switch database many times during mission critical projects to avoid downtime and during database patching to avoid database interruptions and outage. Performed backup and recovery using RMAN and tuned backups for efficient recovery Used SQL Tuning Advisor and SQL Access Advisor to tune SQL statements.
• Compiled PL/SQL (Stored Procedures, Triggers and Transactions). database applications.
• Assisted development teams with development, testing, tuning and implementation of
• Database design and some logical modeling for environmental design
• Performed near zero downtime upgrade from 11.2.0.4 to 12.2.0.1 using data guard logical standby.
• Managing oracle wallet OWM to keep TDE master encryption keys and s and installing, configuring and administrating oracle Audit Vault including audit vault server, audit vault collection agent and collector etc.
• Worked on Oracle security Mechanism to enterprises databases including Oracle VPD, advanced security TDE to encrypt critical customer data with column and Tablespace encryption.
• Responded to and resolved help desk DBA support tickets
• Provided oversight, mentoring and leadership to less experienced staff
• Day to day maintenance included patching, cloning, and administration of concurrent manage process, Users, Forms, Reports and performance issues.
• Set up configured and maintained Oracle Data guard (primary and standby database) to ensure disaster recovery, high availability and data protection.
• Provided support for standard Crystal Reports as well as designed custom reports as per management request
• Performed user and security administration activities such as enrolling users, granting privileges to users and maintaining system security
• Provided Onsite and Offsite (On Call) support 24x7 in a group rotation
• Configured Mikrotik router for VPN connection and Installed LAN system for managing an integrated software across multiple users in different locations
• Contributed to company’s 10% revenue growth in 2017 by standardizing content from disparate databases, enabling sales and support staff to quickly respond to customer requests

Oracle Database Administrator

Confidential, Minneapolis, MN

Responsibilities:

• Responsible for the implementation of RMAN with Split mirror backups for several multi-terabyte database systems, this required the implementation of Grid Infrastructure, single node RAC environments, oracle restart, and Oracle ASM interacting with VERITAS and Net backups environment.
• Served as rotating on-call DBA in support of 24x7 operational databases.
• Supervising application of One-Off, patch sets and PSU patches patch rollouts across the enterprise
• Installed and maintained Oracle 11g/11gR2 databases having good exposure on Linux, HP-UX and Windows.
• Performed Database upgrade and patching including the planning, testing and analysis using SQL Performance Analyzer to determine execution plan changes with 11g.
• Set up and administered table spaces, data files, tables, indexes, views and sequences Configured and managed users, security and Redo logs.
• Worked with Oracle Data Pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Install and configure database changes, builds and deployments in support of QA and production testing and release schedules.
• Installed and implemented 10gR2/11gR2 RAC
• Design, installation, configuration and maintenance of Oracle 10g RAC & non-RAC databases with ASM
• Upgraded RAC databases from 10gR2 to 11gR2.
• Monitoring Smart Flash Cache Activity on Oracle Exadata
• Upgrade and character set conversion of RAC databases with the aid of Oracle's Golden gate utility.
• Installed and configured oracle Golden Gate on Linux.
• Set up uni-directional Golden Gate for replication.
• Established standby/cloned database via Data Guard for Database Disaster Recovery.
• Maintained Data Guard to provide high availability by implementing physical standby database and snapshot standby.
• Worked on Oracle ZFS Storage Appliance and EMC DMX4
• Worked on ASM redundancy levels, load re balancing on RAC as well as standalone systems.
• Data partitioning & tuning queries on large Oracle RAC databases.
• Monitored and performed daily incremental backups, weekly backups using RMAN.
• Used Low Archive Log Space event triggered RMAN backup job that would clean out the directory • Configuring and deploying of Physical Database Backups using RMAN using Net backup.
• Configured and maintained physical standby databases using Oracle Data Guard to perform quick disaster recovery.
• Monitoring the instance statistics and tuning the database to improve performance.
• Created dbms scheduler jobs for gathering statistics after the batch processing window.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Wrote scripts for Import and export procedure, setting up new environments, backup and recovery, Import and export procedure.
• Wrote shell scripts for backups, cloning of databases.
• Wrote Writing of UNIX shell scripts to manage the health of database proactively.
• Used tools like OEM, STATSPACK, TKPROF, SQL Trace, Explain Plan, AWR and ADDM reports to pro-actively monitor performance.
• Helped Development teams with POC for Oracle text and Oracle Spatial Implemented Oracle queues for downstream applications.
• Creation of data models and transporting data using tools like ERWIN.
• Involved in operating system tuning, optimizing database performance, query tuning using Explain Plan, TKPROF and Oracle Enterprise Manager (OEM).
• Developed shell scripts for automatic logical and physical backups of the databases and sending email notifications.
• Created and documented database maintenance plans on updating statistics, reorganizing indexes, disk optimization by managing data files and tablespaces.

Environment: Oracle 8, 9i, 10g, HP-UX 10 (IA64), Red Hat Enterprise Linux 4, Solaris, TOAD 9.2, SQL developer, SQL*PlusSQL*Loader, Erwin, Import/Export, Oracle Spatial, Visual Source Safe (VSS), Win SCP, Grid Control, OEM, RAC, Golden Gate 11.2, ASM, Exadat

Database/ BI Developer

Confidential, Minneapolis, MN

Responsibilities:

• Assisted developers in defining application requirements, coding, and testing of different software ecosystems Installed and configured Oracle 9i, 10g, 11g databases for database developers Ιnvolved in gathering Report Development Specifications for creating reports.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as Group by, Drilldowns, Drill through, sub-reports etc.
• Developed Stored Procedures to generate various Adhoc reports, Parameterized reports, Tabular reports and Matrix reports using SSRS.
• Modified existing databases and database management systems or directed programmers and analyzed to make changes
• Implemented various concepts of manipulation of SQL joins and keys for faster performance/tuning
• Researched and applied best practices for the design and administration of MySQL databases
• Created and maintained standard database policies, operating procedures, and overall documentation
• Implemented proactive database performance monitoring, fine tuning, and optimize database systems
• Developed and implemented database backup and disaster recovery strategies Eliminated outdated records by sending the records to be scanned
• Created Data Driven Subscriptions both Windows File share and Email.
• Identified the associated Store Procedures and parameters used for the reports.
• Created reports that projected business goals for future.
• Good working experience in Data Warehouse applications, directly responsible for the Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse using SSIS.
• Experience in creating SSIS Jobs and Scheduled SSIS Packages.
• Implementing Derived column, Condition split, Multicast, Merge transformations to clean the data and implementing the business logic.
• Created custom database reporting tools by coding stored procedures, triggers, and queries with PL/SQL
• Performance Tuning of the database (Memory Tuning, I/O Tuning)
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
• Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.
• 24x7 remote support and on call rotation

ICT Support Engineer

Confidential

Responsibilities:

• Collaborated with a large team to develop IT infrastructure for over 300 branches all over Bangladesh to maintain an online database software
• Working closely with Data Architects, Infrastructure Architect, developers to ensure database stability and performance optimization
• Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, and production environments.
• Daily monitoring and troubleshooting of streams issues
• Assisted network group with part-time LAN administration duties which included configuring file servers, maintaining backups, and monitoring network for congestion and bad links
• Configured Mikrotik router for VPN connection and Installed LAN system for managing an integrated software across multiple users in different locations