RAJBIR SINGH

Advanced Oracle Database Management: Oversee all facets of Oracle 11g/12c/19c
database management and configuration, with deep focus on performance tuning, structure
optimization, and operational efficiency.
•

Exadata and Dataguard Expertise: Lead Exadata implementation and Dataguard
high-availability solutions, ensuring reliable failover and backup processes for critical
applications.
•

Backup & Restore with Zero Supervision: Developed comprehensive backup and restore
procedures, utilizing RMAN, GoldenGate replication, and NetApp snapshot technologies.
•

Performance Tuning and Optimization: Collaborated with developers to optimize SQL queries
and database performance, reducing query execution times and improving overall database
response.
•

Scripting with Unix and Python: Automated repetitive DBA tasks with Python and Unix shell
scripts, enhancing process efficiency.
•

User and Developer Collaboration: Worked directly with users and developers, maintaining a
responsive support framework to resolve issues in a high-demand environment.
•

• 24x7 Production database administration, support.
• Exadata migration from X3 -> X8M -> X10M
Installed and configured Bi-Directional replication on production databases using
GoldenGate.
•

Installed and configured tools to monitor and maintain database health. Testing environment
refresh using NetApp snapshots, Creating the database table spaces, tables, indexes, setting
privileges and user logins.
•

Provided database/application tuning including as reducing lock contention, analyzing
objects.
•

Involved in RAC administration including 11g/12c/19c Database cloning, tuning, patching and
monitoring.
•

• Designed and created infrastructure for 3rd party applications like abinitio,mapr.
• Planned and implemented security measures to safeguard vital business data.
Set up and controlled user profiles and access levels for each database segment to protect
important data.
•

• Eliminated downtime by accurately implementing replication between databases.

Proactive Database Monitoring and Tuning: Utilized Oracle Enterprise Manager and custom
scripts for database tuning and resource monitoring.
•

SQL Optimization: Optimized high-resource SQL queries and implemented changes that
reduced database load, contributing to efficient application performance.
•

System and Backup Management: Configured backups using RMAN and managed database
structures, ensuring business continuity and minimizing downtime.
•

• Coordinated and designed database migration strategies to migrate data.
Worked with PM for various RFS (Request for Service) Projects and Coordinate with SDM's
(Service Delivery Managers) on various projects to provide subject matter expertise for
customer requirements and troubleshooting issues on mission critical databases.
•

Interacting with GR (Global Resources) DBA's and Application developers to achieve project
meet project timelines.
•

Installed and configured Oracle 11g (R1), 10g (release 1 and 2), 9i, (release 1 and 2)
databases, Applied Patches on Oracle owned software.
•

Written and maintained generalized scripts to create databases, to get definition of the
existing databases, to rename the databases, to monitor and maintain databases and their
alert log files and listener log files, startup scripts, shutdown scripts, RMAN backup and restore
scripts and export & import scripts on HP-UX 10.x and 11.x, Linux boxes.
•

Configured ASM (Automatic Storage Management) enabled database, ADDM and SQL
advisor.
•

• Database Tuning – Tuning Applications, Memory Tuning and Tuning Disk Usage.
• Upgraded databases from Oracle 8i to 9i/10g, Oracle 9i to 10G.
Performed frequent database refreshes/ Cloning in different environments using 10G
Datapump, Hot backup and TTS.
•

• Written PL/SQL procedures, packages and triggers to solve the mutating trigger issues.
• Capacity planning for changes in the size of databases due to business growth.
Migrated the projects from development to test and to production environments and building
objects associated with those projects.
•

• Lead team member for upgrades to 10g and installation of ASM.
• Expertise in Managing and Administration of VLDB systems ranging from 1GB to 20TB.
• Responsibilities include review of SGA and init.ora modifications.
Backup/Recovery strategy, testing and shell scripting for backup and refresh as well as EMC
Timefinder/SRDF backups.
•

Coordinated with Oracle Corporation's support and Application teams on testing, migration
and implementing latest patches, bugs and enhancements.
•

• Work with application developers to re-design high resource consumption applications.
• Work on multi functional teams to resolve short and long-term escalated issues.

• Responsible for large to very large and complex development and production database (mix of Oracle 10g, 9i, 8i) on 24/7 basis.
• Managing Instances, Redo log files, Archived log files, Table spaces, Data files, Rollback segments, Temporary segments, Data structures, Indexes, Clusters and storage allocation.
• Optimizing SQL queries using SQL Trace, TKProf, and Explain Plan and standardizing SQL queries for Developers to use in Applications.
• Installation, Upgrade and Configuration of Oracle (8i, 9i, 10g).
• Used Export/import for copying data across schemas.
• Creating snapshots and materialized views for data refresh between Production, Test and development databases.
• Creating Primary keys and Referential Integrity constraints.
• Written shell scripts to automate various jobs.
• Analyze the queries and code written by the developers to make sure it performs optimally.
• Before it is implemented in production database.
• Configured and Implemented Cold/Hot Backups of database using Sql-backtrack, 3.0.10, 4.0.10, 5.4.33 and RMAN.
• Creating and upgrading existing schemas based on the user request with the DDL scripts.
• Performed better Space Management using Locally managed table spaces.
• Configuring databases for auto UNDO management defining UNDO table spaces.
• Participate, as the project DBA, in various assigned projects through plan, analyze, design, build, and rollout.
• Provide support for all assigned projects, which includes database backup and recovery, performance tuning, capacity planning, and monitoring.
• Security compliance on all supported databases following internal and corporate security guidelines.
• Participate in the 7 x 24 x 365 on-call support rotation.
• Open SR/Tar , searched metalink for troubleshooting and alternative solutions.
• Used RMAN and Veritas Net Backup database backup/recovery tool.
• Responsible for application development and transformation of the source data into steps involving staging using stored procedures / functions, packages and UNIX shell scripting.
• Assisted the testing team with steps involving cross-referencing in the database.
• Used the DBMS UTIL_FILE package for logging the data and DBMS JOB_QUE for running processes simultaneously.
• Participate in establishing guidelines for standards, tools, methodology, documentation, and project planning and provide documentation on assigned databases.
• Took part in Release implementation meetings and helped them formulate detailed implementation plans for the various application releases that enhance the plans for the business.