OBJECTIVE:

To contribute relevant experience and educational background to a challenging Senior Database Administrator position offering ample skill utilization and growth opportunities.

SUMMARY:

• A highly dependable and result - oriented professional with more than 12 years of progressive information systems experience with over 12 years of Oracle database administration in heterogeneous system environment including Solaris, Confidential -UX, Linux, IBM-AIX and Windows, supporting a variety of mission critical applications in Telecom, Consultancy and financial environment.
• Extensive experience with Oracle database administration, RAC, RMAN, standby(Data Guard), replication(Oracle Streams & Advanced Queue), installation, configuration, migration, sizing and space management, backup and recovery, performance tuning and troubleshooting. Broad technical knowledge of infrastructure management (network, systems, web hosting), combined with outstanding leadership ability, project management, and creative problem solving skills in both strategic and tactical areas.
• More than 12 years of IT experience as Senior Oracle Database Administrator in Production environment.
• Expertise in Oracle 11g/10g/9i/8i database administration in high availability production environment.
• Oracle 11g/10g/9i Real Application Clusters (RAC) installation and maintenance.
• Extensive experience in production database support.
• Expert in backup/recovery using RMAN, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning.
• Transforming Logical data model into Physical data models.
• Solid experience in disaster recovery (standby & DataGuard), routine maintenance for Oracle databases
• Solid experience in Oracle Recovery Manager (RMAN), advanced replication, and standby database using Data Guard 9i/10g/11g
• Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup. Implementing backup and recovery strategies.
• Employing Oracle Enterprise Management (OEM) with standard management, diagnostic, tuning, and change management packs to perform various administrative tasks. Setting-up and configuring Oracle Management Server (OMS) to monitoring database operation.
• Data transferring with export/import utilities and Data Pump and SQL* Loader.
• Performance monitoring/tuning/troubleshooting on Oracle, Unix, Linux, and Windows NT/2000/2003 servers
• Installation, configuration, upgrading and migration of Oracle software (9i, 10g) and tools. Applying patches under UNIX, Linux and Windows platform.
• Unix Shell scripts for hot backups, SQL*Loader, export and import of database
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, TOAD, monitor users, tablespaces, memory structures, rollback segments, logs, and alerts
• Excellent interpersonal and strong analytical, problem-solving skills
• Knowledge of Banking, Data Warehousing, Telecom and ERP technologies.
• IT Consultancy skills.
• Excellent written and verbal communication skills with all levels of personnel within a client organization.
• Persuading and influencing all levels of management in the design and implementation of an integrated Oracle solution.

TECHNICAL SKILLS:

Databases: ORACLE 11g Release 2 RAC, Oracle 10g RAC, 9iRAC, 9i/8.x/7.x. SQL Server 2008

DBA Tools: SQL developer, DBA Studio, Oracle OEM, TOAD, Spotlight, Quest CentralDB Artisan, SQL server Enterprise manager, Query Analyzer.

Operating Systems: Sun Solaris, Confidential -UX, IBM-AIX Linux (Redhat, SUSe, Oracle Enterprise Linux) & Windows 2000 professional.

Cluster Wares: Veritas, Oracle Cluster Ware

Case Tools: Platinum ERWIN, Sybase Power Designer.

Languages: Developer/2000, Developer 6i.

ETL TOOL: Oracle warehouse builder, IBM Datastage.

Hardware: Sun Sparc, IBM PC, Confidential Superdome, Confidential superdome 2, IBM Blades.

Volume Manager: Veritas Volume manager.

Storage: EMC SAN with SRDF, IBM San with PPRC.

ORACLE Tools: OS watcher, L-TOM, Oracle GoldenGate, Rapid Install, AD utilities, Oracle Universal Installer

High Availability: Physical Data Guard, Logical Data Guard.

Oracle Storage: ASM (with ASM Lib), Oracle 11g R2 ASM

Data Loading: Oracle data pump, SQL* Loader, Export/Import

Grid Infrastructure: ORACLE 11g R2 grid Infrastructure.

Messaging System: ORACLE advanced Queue, IBM Websphere MQ v 7

ORACLE Security: ORACLE Wallet, Oracle Transparent data encryption

ORACLE Diagnostic: 10046 trace, systemstate dump, hang analyze, event tracing

Monitoring Tools: Confidential openview, Guardium, Oracle Enterprise Manager, Introscope 7, IBM Tivoli

Automation Tools: Confidential Server automation

Scheduling Tools: Control-M, Maestro

Data Modeling: ER-Diagrams, Star schema, Snow Flake schema, Sybase Power Designer, ER-Win

Oracle Financials: Oracle E-Business suite R12

Virtualization: Oracle virtual Box, Oracle VM, Confidential -UX VPAR, IBM-AIX LPAR

Version Control: PVCS

WORK EXPERIENCE:

Confidential

Senior Oracle Consultant

Responsibilities:

• Installing Oracle 11g R2 Grid Infrastructure and Oracle 11g R2 RAC software on Confidential, Linux and IBM AIX platforms.
• Setting up multiplexed Oracle Data Guard environment as migration strategy to BDC data center.
• Performing Oracle Data Guard switch over between Production and DR servers using Oracle Data Guard Broker.
• Working with client to perform Pre-cutover activities before migrating Data Guard environment from CPO to BDC data center.
• Installing, Creating and managing new Oracle 11g R2 RAC Dev and PAT environment at BDC centre.
• Extensively using RMAN to backup and Recover 10 TeraByte of DB using IBM TSM media manager layer.
• Implemented Security in different levels of database. Utilizing Oracle Advanced Security options (Transparent Data Encryption using wallet).
• Applying quarterly released CPU and PSU patches to Grid Infrastructure and Oracle RDBMS.
• Performed data migration across databases and platforms.
• Worked with users, analysts, developers and system admins to realize root cause of performance issues, modelling, debugging and troubleshooting.
• Provide 24*7 production database support as well as development databases to ensure maximum availability of database for all applications.
• Database cloning/refresh from production to production reporting, and backup.
• Extensive experience with IBM TSM Tivoli monitoring, IBM TSM backup media manager layer.
• Converting Physical Standby database to Snapshot Standby database for User and application testing and vice versa.
• Working with Unix SA to patch Database servers.

Confidential

Senior Oracle/SQL server DBA

Responsibilities:

• Working as Senior Database Administrator (ORACLE & SQL Server) on Data center migration project & Build DBA resource following are my major responsibilities.
• Meeting with Unix, storage, Network, Backup and application/business users to analyze impact of a physical database server migration.
• Installing, creating and configuring new Oracle 11g R2 RAC and standalone Database Infrastructures before migration.
• Creating and configuring Oracle 11g R2 data Guard for minimum downtime migration.
• Using oracle 11g R2 RMAN to migrate small to medium sized DBs.
• Troubleshooting Oracle 11g R2 HAS, Oracle 11g R2 ASM and raw devices and Oracle clusterware startup issues.
• Configuring and troubleshooting post migration backup and High Availability issues.
• Installing, configuring and patching MS SQL server 2008 R2 named instances as part of build DBA.
• Configuring and troubleshooting MS SQL server 2008 R2 mirroring and synchronization.
• Using RMAN incremental backup and/or manual archive log restore to catch up gap between Production & DR during migration.
• Working with Oracle golden gate to enable and disable real time log apply for critical databases.
• Working with Unix, Backup, Network and application support group for end to end testing post migration.

Confidential

Senior Oracle DBA (Production &Infrastructure)

Responsibilities:

• Leading Team of 4 senior Production DBAs in Infrastructure migration project.
• Participating in planning and execution phases of Infrastructure migration project along with other teams.
• Demonstrating planning and execution activities to the senior management of the bank.
• Installing Oracle 11g Release 2 RAC software on Confidential (Superdome 2) &Red Hat Linux ( Confidential proliant) platforms.
• Creating Oracle 11g RAC instances and databases which are failover and load balance enabled.
• Installed Oracle E-Business suite R12 on Oracle Enterprise Linux and Confidential -UX servers.
• Provide operational support, including troubleshooting and resolving database and application problems.
• Applying Oracle E-Business R12 Suite patches.
• Developed, analyzed, designed, and implemented the organization’s storage infrastructure/architecture to ensure high levels of data quality and availability.
• Managing physical database resources.
• Configuring and managing oracle’s clusterware and its components (voting disk, OCR, VIP & nodeapps).
• Installing and configuring Oracle GoldenGate on Confidential -UX & IBM-AIX servers.
• Setting up uni-directional and bi-directional replication using Oracle GoldenGate.
• Implementing, maintaining and testing backup & recovery strategies using RMAN utility.
• Migrating Oracle 10g Databases to Oracle 11g R2 (Oracle 11.2.0.3)
• Applying Oracle quarterly released PSU patches for Oracle 11g R2 DBs (Oracle 11.2.0.3)
• Setting up auditing, security standards as per Bank’s standards to be PCI compliant.
• Monitoring system and instance resources & architecture to ensure continuous database operations (i.e., database storage, memory, CPU, network usage, and I/O contention).
• Providing 24*7 on-call technical support on rotation basis.

Confidential

Senior Oracle DBA (Production)

Responsibilities:

• Installation of Oracle 11g & 10g standalone as well as RAC software on Unix (Sun, Confidential, Linux and AIX) platforms.
• Creation of Oracle 11g & 10g Dbs.
• Applying quarterly released Oracle PSU and CPU patches to Dev, QA, UAT and Production environments.
• Participate in the design and maintain the physical models of multiple databases consistent with BA guidelines and the Information Strategic Plan.
• In collaboration with project teams, define access security and capacity requirements.
• Develop, implement and maintain the standards and procedures related to the creation, maintenance and usage of all database resources.
• Responsible for the database tuning and administration, backup strategies, data security.
• Work in close collaboration with the ongoing project and Operation teams.
• Designing, testing, correcting and optimizing systems to ensure that the objectives of the system are met and that the outputs produced are in accordance with client requirements.
• Identifying, monitoring, managing, and reporting risks, problems and change management requests
• Creating/managing and refreshing Materialized views manually.
• Creating & enforcing security and High availability architectural standards.
• Participating in Disaster Recovery exercises.
• Participate in monthly release activities for Confidential .
• Providing On-Call DBA support on rotational basis to ensure databases are operational 24x7.
• Restored & recovered 2 TB DB using RMAN and Symantec Netbackup
• Stabilized execution plan which changed due to table segment size and DB initialization parameters.
• Ensuring DB is compliant with IBM security standards (ISec) by running security scans every quarter.
• Working with DB auditors (external and internal) to address DB security leaks.

Confidential

Senior Oracle DBA (Infrastructure/Production Support)

Responsibilities:

• Production support for existing Oracle Databases.
• Actively involved in Performance/tuning of DB applications.
• Actively Involved with Storage and System administrators in capacity planning.
• Installed Oracle 11g Release 2 Grid Infrastructure software on IBM AIX servers to use Oracle’s ASM.
• Installed ORACLE 11g Release 2 Database Software on IBM AIX servers.
• Applied ORACLE security patches for Oracle 11g R2.
• Installed and configured ORACLE messaging Gateway for message propagation between ORACLE AQ and IBM Websphere MQ.
• Installing, configuring and creating Oracle 11g RAC Infrastructure/DataBases architectures on AIX.
• Configured ORACLE restart on AIX server.
• Installed and configured Oracle 11g R2 32-bit client software on AIX servers.
• Integrating Oracle Database applications with IBM websphere MQ applications.
• Configuring DB for Inbound and Outbound message propagation.
• Managing and monitoring the Messages flow from Oracle’s Advanced queue to IBM MQ and vice versa.
• Monitoring Oracle Messaging Gateway.
• Working with IBM Tivoli Monitoring Agent development team in engineering IBM Tivoli agent for Oracle Messaging Gateway monitoring.
• Implementation of iSeC security standards.
• Developing RMAN’s Backup and Recovery strategies for High Availability of application.
• Using Oracle 11g Release 2 compression and Encryption capabilities to compress and secure the critical trading data.
• Production support/On-call rotation for existing Oracle Databases.

Confidential

Senior Oracle DBA (Production)

Responsibilities:

• Installed/Cloned Oracle Software (Oracle 10.2.0.4.0 ) on Confidential machine using Silent Installation method.
• Built Physical Standby DB for BlackBerry North America Operations.
• Database Production support/on-call rotation for existing Oracle production Databases.
• Participating in On-Going Performance/tuning issue.
• Successfully installed and configured Oracle Grid Control 10.2.0.1 (Oracle Management Server & Oracle Agent) on Linux Box.
• Successfully upgraded Oracle Grid Control to Oracle Grid Control 10.2.0.5.0.
• Installing and configuring Oracle GoldenGate on Linux servers.
• Successfully Migrated the character set of production DB from WE8MSWIN1252 to AL23UTF8 using csscan utility.
• Used Oracle 10g data guard (data guard broker, data guard observer) to automate database failover/switchover between primary and standby DB.
• Used ASMLib on Oracle Enterprise Linux to configure ASM disk for ASM instances.
• Created Logical Standby DB using ASM (Primary and Standby DB both used ASM).
• Providing 2nd Level on-call support on rotational basis.
• Working with auditors and application developers for remediation of audit action items.
• Installing/configuring/managing SQL server 2005 named Instances for Business reporting purposes.
• Production support for existing SQL server Databases.
• Actively participating with DB architects for Capacity planning for existing DBs.

Confidential

Senior Oracle DBA (Production)

Responsibilities:

• Supported diverse database environment, both OLTP, as well as very large Data Warehousedatabases.
• Installation, configuration, upgrade of Oracle RDBMS software 9i, 10g (stand alone, RAC) on Confidential, Sun, AIX platforms and maintain patch level (One off patches, Patchests).
• Implemented Oracle 10g RAC, Standby and DataGuard in some production databases
• Installed and Upgraded 10.2.0.2 RAC (Red Hat Linux) to 11g (11.1) RAC.
• Converted Oracle 10g Non-RAC database to 10g RAC database.
• Installed Oracle E-Business suite R12 on Redhat Linux.
• Applying Oracle E-Business R12 Suite patches.
• Installing and configuring Oracle GoldenGate on AIX unix servers.
• Setting up Uni-directional replication using Oracle GoldenGate.
• Creating standby databases as part of the DR strategy and ensuring the Primary and standby DB are in sync with each other.
• Upgrade of DB running on Oracle 9i to Oracle 10g.
• Managing and supporting technical changes being implemented into the environment.
• Actively participating in Design (logical and physical), testing and implementation phases of Software Development life cycle for new projects.
• Utilized RMAN for backup and recovery strategy.
• Performed user and security administration activities, such as enrolling users, granting privileges to users, and maintaining system security.
• Completed export and import of different databases using Oracle Export / Import utilities
• Table fragmentation tuning, partitioning the large table by date.
• Increase database reliability and availability through process improvement.
• Responsible for successful execution of the ticket, documenting status, providing feedback to the owner and closure of the tickets.
• Actively participating in DR exercise to ensure the restoration of business continuity in a real disaster scenario.
• Actively participating with application owners/ application developers to fine tune the application code and optimal utilization of DB and system resources. Statspack and AWR reports are thoroughly analyzed to obtain the performance problems.
• Using various Oracle tools like (OS watcher, L-TOM) to capture the run time events and operating system/IO statistics and events.
• Ensuring the successful backups are happening and storing on tape using Net backup.
• Participating in BCV and RMAN backups.
• Providing after hours On-call Support for database related problems as part of an on-call rotation.
• Documented Oracle physical and logical data models. Developed master data management models. Reviewed and optimized current Oracle table structures.
• Implemented Oracle Data Guard, Standby, Oracle Enterprise Manager 9i/10g/11g Grid Control. Configured OEM / Grid Control to generate alerts for critical thresholds.
• Maintaining Confidential ' standards for database implementations and service.
• Installing/Administering SQL server 2005 Instances and DBs on Windows servers.
• Production Support/On-call rotation for existing Oracle and SQL server Databases.

Confidential

Senior Database Administrator (Production)

Responsibilities:

• Verifying the node reach ability, user equivalence, node connectivity, system requirements and kernel packages by using Oracle Clusterware CVU (Cluster Verification Utility) utility.
• Installation, configuration and management of Oracle 10g Clusterware (CRS, Voting Disk, OCR).
• Managing CRS (Cluster Ready Services) for start, stop and status checking.
• Managing Voting disk and OCR (Oracle Cluster Registry).
• Installation, configuration of Oracle 10g RAC software.
• Creating Real Application Databases which are Failover enabled and Load Balanced.
• Managing RAC DB using srvctl utility for various administration tasks.
• Installation and creation of Oracle 9i RAC software on VeritasClusterware.
• Creation of RAC DBs which are Failover enabled and Load Balanced.
• Installation, configuration of ORACLE 9i and 10g NON-RAC software on Sun Solaris platform.
• Migrating Oracle 9i Release 2 DB to ORACLE 10.2.0.3.0.
• Creation of RAC and NON-RAC databases on SUN Solaris platforms.
• Participating in the design, engineering, configuration, testing, and performance tuning of all Relational database management systems (RDBMS).
• Evaluating and recommending the acquisition of database and data management solutions to meet changing business requirements and to continuously optimize the business application environment.
• Coordinating and oversee ongoing maintenance and upgrades for all RDBMS's with internal teams and external service providers.
• Providing rigorous testing for new DBMS releases and patches, configuration changes, indexing strategies, maintenance routines, upgrade and data migration strategies, data distribution (replication) strategies, extraction-transformation-load (ETL) strategies, high availability strategies, disaster recovery, and other application design strategies.
• Providing project oversight for large-scale complex database application changes and implementation.
• Providing technical leadership in the Unix and Wintel based application environments working with the AEE group and the LOB CIO’s:
• Provides consulting services to application development teams to understand the World Markets DBMS standards and system infrastructure to optimize application performance attributes prior to production implementation
• Continuously develop and improve Confidential standards for software tools and system design
• Employ Confidential standards and industry best practices when designing and implementing new solutions.
• Actively provide leadership and technical expertise to ongoing problem identification/resolution and root cause analysis process for database environments:
• As a Level 3 escalation resource for problem determination and resolution of all issues encountered during development, quality assurance and user acceptance testing, production system integration, and all issues escalated by Level 1 and Level 2 Command Center staff post-production.
• Accountable for adhering to problem management process for DBMS related incidents consistent with Global processes to meet service expectations of regional customers.
• Provide mentorship to database engineers and Confidential Command Centre analysts in all aspects of database management, automation, trouble-shooting, and problem resolution.
• Accountable for problem determination, troubleshooting and resolution of database-driven application problems through use of system diagnostic utilities and industry recognized best practices.
• Participates in the improvement of support processes, subject matter expertise, and technical capabilities with the Database Services and Command Center teams to continuously improve service delivery and efficiencies.
• Participates as a team member in evaluating system resource utilization and storage usage/capacity, and makes recommendations to increase application performance to meet business and financial requirements.
• Support production environments, configuration, testing, and performance tuning of all Oracle database environments.
• Verify the database support requests and execute them in timely manner as the business SLA’s.
• Coordinate and oversee ongoing maintenance and upgrades for all Oracle with internal teams and external service providers
• Manage the production, deployment & maintenance of Oracle RAC. Provide expertise around optimizing performance and ensuring high-availability.
• Provide consulting services to application teams and possess good understanding of Confidential DBMS standards and system infrastructure.
• Provide rigorous testing for new Oracle server releases and patches, configuration changes, indexing strategies, maintenance routines, upgrade and data migration strategies, data distribution (replication) strategies, extraction-transformation-load (ETL) strategies, high availability strategies, disaster recovery, and other application design strategies.
• Managing problem/project tickets queue and maintaining communication with business team members.
• Consult with problem/project ticket owners in resolving issues and executing scripts as per the requirements.
• Continuously monitor the request queue and prioritize tickets in the queue as per the guidelines from the management.
• Responsible for successful execution of the ticket, documenting status, providing feedback to the owner and closure of the tickets.
• Working with auditors and application developers for remediation of audit action items

Confidential, New York

Senior Database Administrator

Responsibilities:

• Installation of Oracle software (10g, 9i/8.x) on SUN SOLARIS & Windows 2000 professional.
• Creation and configuration of oracle based databases on Sun Solaris and Windows platforms.
• Conduct research and provide advice to other informatics professionals regarding the selection, application and implementation of relational database management systems.
• Design/support in defining and modifying logical and physical database model for data warehouse and data marts.
• Managing users by assigning them privileges through roles, and quotas.
• Enforcing security using encryption/decryption and Fine grained access control.
• Entirely responsible for maintaining the Production, Test and Development databases of the company, which mainly includes the following:
• Managing files of a database.
• Creation of tablespaces and data files.
• Setting storage parameters for dictionary managed tablespaces.
• Monitoring the growth and sizing the tablespaces for the smooth running of daily batch on production server.
• Creating tablespaces based on raw datafiles using Veritas Volume manager.
• Managing schema objects.
• Estimating storage parameters for tables, indexes and materialized views
• Analyzing the tables, indexes and schemas on the production server to gather up-to-date statistics in the oracle dictionary.
• Monitoring the usage of indexes and hence dropping the unnecessary indexes consuming space.
• Managing rollback segments.
• Creation and setting storage parameters of rollback segments (in manual UNDO MANAGEMENT mode).
• Altering rollback segments and assigning large batch transactions explicitly to bigger rollback segments.
• Monitoring rollback segment growth.
• Replicating the data between production databases (Avis and Budget) residing on same server using snapshot master replication method and Oracle streams.
• Analyze SQL queries and make recommendations to Data Warehouse engineers and extraction programmers for possible alternates to accomplish the tasks.
• Execute backup procedures: COLD backup, HOT Backup with database in Archive log mode using RMAN & also Full and Incremental Database Exports.
• Execute restoration procedures of complete & incomplete media recovery using RMAN. Restoring full backup & Time based Recovery.
• Design and implement Networking between Oracle Servers on different operating Systems.
• Extensive hands on working experience of Oracle Utilities: Export, Import, SQL*Loader, RMAN.
• Hands on working experience of TOAD, Spotlight, OEM and DBA studio.
• Experienced in Partitioning large tables across physical disks to increase throughput and better management and maintenance.
• Provide 24x7 system support as a system DBA for Production and development systems on a rotational basis

Confidential

Oracle DBA

Responsibilities:

• Installation and configuration of ORACLE and MS SQL server 2000 software, installation and configuration of application database at customer sites.
• Diagnose and tune performance problems and locking conflicts using Oracle database monitoring and diagnostic tools (SQL TRACE, EXPLAIN PLAN, TKPROF, UTLBSTAT/UTLESTAT) and dynamic performance tables/views.
• Writing bespoke PL/SQL code (packages and procedures) to accomplish the requirements for the production and Admin modules of the ERP.
• Performing the Tuning and Maintenance of the application and database.
• Performing physical and logical backups of application database running on ORACLE and MS SQL server 2000.
• Tuning RDBMS to optimum levels of performance.
• Checking and controlling user access and authentications to the DB through roles and system/object privileges.
• Implementation of audit trails for key transaction/data.
• Provide rigorous testing for new DBMS releases and patches, configuration changes, indexing strategies, maintenance routines, upgrade and data migration strategies, data distribution (replication) strategies, extraction-transformation-load strategies, high availability strategies, disaster recovery, and other application design strategies.
• Creating and implementing the physical design form the logical design.
• Verifying that all instances are up and running and checking unusual entries in alert log and trace files on daily basis.
• Checking of CPU, memory and disk utilization and checking the existing constraints and indexes. Also checking and verifying rollback segments and temporary tablespaces.
• Provide 24x7 system support as a system DBA for Production systems on a rotational basis

Confidential

DatabaseAdministrator (ORACLE)

Responsibilities:

• Planning, Installation and deployment of Oracle based applications to 3rd party Sites.
• Writing bespoke PL/SQL code according to client specification.
• Writing Shell scripts to wrap PL/SQL code.
• Advising customer of coding techniques for optimum performance.
• Performing the Tuning and Maintenance of the product specific database.
• Performing physical and logical backups and advising Customer of Backup and Recovery routines.
• Tuning RDBMS to optimum levels of performance.
• Installation of Oracle Software at customer’s sites and Islamabad office on Sun and Confidential servers.
• Checking and controlling user access and authentications to the DB.
• Configuring the Sun and Confidential servers for the installation of ORACLE software and creation of DB.
• Verifying that all instances are up and running and checking unusual entries in alert log and trace files on daily basis.
• Overseeing the day-to-day requests for objects creation, user creation and structure modifications.
• Provide 24x7 system support as a system DBA for Production systems on a rotational basis.

Confidential

Computer Officer/DBA (ORACLE)

Responsibilities:

• Smooth functioning and management of Database. This included controlling user access, backup and recovery, storage management, application software upgrades, SQL Tuning, and automating support issues with bespoke program suites.
• Analyzing, designing, development and implementing new software to fulfill the needs of organization.
• Working for the welfare of 30 Database operators under my jurisdiction.
• Performance reviews for Oracle resulting in massive gains for Oracle based systems
• Administration and planning of In-house databases for high performance output.
• Taking Backups of database using oracle’s features for backups and restore.
• Providing Oracle Consultancy to other National Logistic Cell departments to integrate organization’s skill set.
• Tuning RDBMS to optimum levels of performance for optimal usage of database resources.
• Checking and controlling user access and authentications to the DB.
• Overseeing the day-to-day requests for objects creation, user creation and structure modifications.
• Checking of CPU, memory and disk utilization and checking the existing constraints and indexes. Also checking and verifying rollback segments and temporary tablespaces.
• Verifying that all instances are up and running and checking unusual entries in alert log and trace files on daily basis.