Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic
Srinivas Kamanaboina

Srinivas Kamanaboina

Austin,USA

Summary

Results-driven Oracle Database Administrator with over 15 years of comprehensive experience, including more than 11 years in Oracle/GIS development and a decade managing enterprise IT data under high-security protocols. Proven expertise in database administration includes installation, configuration, upgrades, performance tuning, backup and recovery, as well as space management and security measures across various Oracle versions from 8i to 12c. Demonstrated success in supporting large-scale OLTP and OLAP systems, extensive experience in high availability RAC environments, and cloud infrastructure management using Google Cloud Platform. Skilled in implementing advanced features such as Golden Gate for data replication and managing very large databases (VLDB) of up to 11TB across multiple environments.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Oracle - Sr. Database Consultant

Austin Technology Services
Austin, TX
01.2025 - Current
  • Responsible for administration and supporting Oracle 9i and 10g databases.
  • 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
  • Worked with Siebel Application team in enabling performance improving Oracle parameters.
  • Closely worked with Siebel Application team in data refreshment for dev & QA environments.
  • Configuration, Administration and tuning of Oracle 10g and 9i RAC.
  • Designed and implemented ETL pipelines to extract, transform, and load data into Azure SQL databases.
  • Integrated data from multiple sources including on-prem databases, APIs, and flat files.
  • Used tools like Azure Data Factory / SSIS for data migration and transformation.
  • Configured GoldenGate replication between Production and Prime Production, Performance and Prime Performance environments.
  • Installed GoldenGate Director to have a web view of all the GoldenGate implemented servers.
  • Installed GoldenGate Veridata to compare the difference between source and target databases.
  • Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
  • Assisted a team of DBA’s in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2.
  • Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetrix.
  • Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Stats pack.
  • Performed conversion single instance to Real Application Cluster (RAC) database instances.
  • Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
  • Provided database/application tuning including as reducing lock contention, analyzing objects.
  • Down-sizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g and Production to development refresh.
  • Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
  • Install, configure, and maintain Oracle databases, particularly those that handle spatial data using Oracle Spatial and Oracle Locator features.
  • Apply necessary patches and updates for Oracle databases and GIS-related software such as ArcSDE.
  • Manage and maintain spatial data storage, ensuring spatial datasets (e.g., polygons, points, lines) are stored and retrieved efficiently.
  • Optimize spatial data queries and indexing using Oracle Spatial technologies like R-tree indexing and Quadtrees.
  • Integrate Oracle databases with ESRI ArcGIS software, particularly with ArcSDE for spatial data management and versioning.
  • Ensure smooth data exchange between Oracle Spatial and ESRI products, ensuring geospatial data consistency.
  • Tune database performance, focusing on query optimization for geospatial data.
  • Monitor performance of spatial queries and geospatial operations to ensure optimal resource utilization and response times.
  • Environment: HP-UX 11, Red Hat Linux4, Windows 2000/2003, Oracle 9.2.0.8/10.2.0.3/11i, DB2, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, Data Guard, SQL
  • Plus, PL/SQL, ASM, ToadV9.7 & SQL, Navigator V6.1.

Oracle DBA - Apps Developer

Department of Veteran Affairs
03.2024 - 01.2025
  • Participated in Agile (Scrum) ceremonies including sprint planning, daily stand-ups, and retrospectives.
  • Worked across full Software Development Life Cycle (SDLC) from requirements to deployment and support.
  • Provision and configure a new FileMaker Cloud instance under the Claris platform.
  • Implemented CI/CD pipelines for database deployments using tools like Git, Azure DevOps, Jenkins.
  • Automated database builds, releases, and version control processes.
  • Validate that all tables, fields, relationships, scripts, and privilege sets are accurately replicated in the new environment.
  • Confirm readiness of the on-premise database for migration by performing integrity checks and resolving any data or access issues.
  • Upload a verified copy of the on-premise FileMaker database (or sample set, if full backup unavailable) to the new FileMaker Cloud environment.
  • Perform detailed data validation and functional testing, ensuring:
  • Certify migration completion to the Agency, confirming database functionality, accuracy, and successful transition to FileMaker Cloud.
  • Administered RDBMS environments (SSMS, TOAD, SQL Developer) including schema design, performance tuning, query optimization, security, and backup strategies.
  • Configured and monitored data integration pipelines (ADF/SSIS), reviewing query execution plans to identify and resolve performance bottlenecks.
  • Designed and delivered Power BI/Tableau dashboards integrated with SQL Server, Azure SQL, and Access for real-time insights and operational reporting.
  • Applied Agile/Scrum methodologies, tracked deliverables in JIRA, managed source control via GitHub, and contributed to CI/CD deployment pipelines.
  • Collaborated with healthcare and public sector clients, ensuring HIPAA compliance and data governance standards across Federal agency projects.
  • Environment: Windows 2000/2003/2008/2012/2016/2019, Windows 10/11, Red Hat Linux 6/7, MS Access 2003/2007/2010/2016/2019 with VBA, SQL Server 2005/2008R2/2012/2016/2019, Azure SQL Database/Managed Instance, AWS RDS (SQL Server/MySQL/PostgreSQL), PostgreSQL 9.x/10.x/11.x, Oracle 10g/11g, FileMaker Server Admin Console, FileMaker Pro, FileMaker Pro Advanced, FileMaker Cloud Admin Console, Claris ID, FileMaker Data Migration Tool, FileMaker Backup and Restore Utilities, SSH, Remote Desktop, WinSCP, FileZilla, SFTP, 7-Zip, WinRAR, OpenSSL, Windows Server Manager, macOS Server Admin, AWS Management Console, Firewall Configuration Tools, Microsoft Excel, SQL Validation Tools, FileMaker Script Debugger, PowerShell, macOS Terminal, Microsoft Word, SharePoint, Confluence, GitHub, JIRA, Agile/Scrum

Oracle Exadata DBA / MSSQL

Consolidated Edison
New York
03.2023 - 03.2024
  • Administering AMI MDMS oracle DB, MS SQL - azure & aws environments.
  • Setup and administer Oracle EXADATA machines
  • Optimize Oracle and MS SQL databases.
  • Plan the migration and execution to Exadata
  • Experience working with Oracle DB 19c, MS SQL - 2005,2008 & Containers with Oracle Multinent , CDB-PDB
  • Migration between both RDBMS.
  • Experience working with Oracle OEM Cloud control
  • Experience working with ZDLRA for database backups and restores
  • Experience working with Oracle ZDLRA backups and restores
  • Experience installing and administrating Oracle, MS SQL on both linux, windows
  • Experience tuning optimizing Oracle DB on various platforms
  • Experience installing and configuring Oracle DG & GG along with MS SQL SSIS & SSMA.
  • Implemented HA/DR solutions such as Always On Availability Groups, Data Guard, replication, and backup strategies.
  • Managed large-volume databases with focus on uptime, failover, and disaster recovery planning.
  • Designed, implemented, and optimized relational databases using Microsoft SQL Server for various business applications, ensuring efficient data storage and retrieval.
  • Developed and maintained complex SQL queries, stored procedures, triggers, and views for data manipulation and reporting.
  • Applied normalization and indexing strategies to optimize database performance and minimize redundancy.
  • Conducted in-depth performance tuning using tools such as SQL Profiler, Database Engine Tuning Advisor, and Execution Plans to resolve bottlenecks and optimize query performance.
  • Implemented indexing strategies, optimized query execution plans, and applied partitioning to handle large datasets efficiently.
  • Deployed and managed Azure MSSQL Database instances to scale applications in the cloud, leveraging Elastic Pools to manage multiple databases efficiently.
  • Designed and implemented geo-replication and automatic failover using Azure SQL Database Hyperscale and Azure SQL Managed Instance for high availability and disaster recovery.
  • Designed and developed ETL pipelines using Azure Data Factory (ADF) to move data from on-premise SQL Server databases to Azure MSSQL Database, ensuring seamless integration across environments.
  • Integrated Azure Logic Apps and Azure Functions to automate tasks like data cleansing and processing, improving overall data flow and reducing manual effort.
  • Configured and managed Azure Blob Storage and Azure Data Lake Storage (ADLS) to store unstructured and structured data for analysis and archiving purposes.
  • Worked with Azure Synapse Analytics (formerly SQL Data Warehouse) to design data warehousing solutions for handling big data and performing large-scale analytics.
  • Monitored database performance using Azure Monitor, Azure MSSQL Analytics, and Azure Log Analytics to track query performance, database health, and system resource utilization.
  • Environment: HP-UX 11, Red Hat Linux4, Windows 2000/2003, Oracle 9.2.0.8/10.2.0.3/11i, DB2, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, Data Guard, SQL
  • Plus, PL/SQL, ASM, ToadV9.7 & SQL, Navigator V6.1,ZDLRA,X5,X7M,X8M

Oracle - GIS DBA

Communications and Technology Management, City of Austin
Austin, TX
07.2017 - 02.2023
  • Responsible for administration and supporting Oracle 9i and 10g databases.
  • 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
  • Successfully migrated databases from windows2000/2003 running oracle 9i over to Linux boxes10g.
  • Installation, Upgrade and Configuration of Oracle 9i and 10g Databases.
  • Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
  • Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
  • Migrated on-premises databases to Azure (Azure SQL, Managed Instance, VMs) with minimal downtime.
  • Optimized database structures for cloud-native environments including cost and performance tuning.
  • Worked with Azure services like Azure Storage, Azure Monitor, and Azure Backup.
  • Worked for Siebel CRM HR Model performance improvement.
  • Worked with Siebel Application team in enabling performance improving Oracle parameters.
  • Closely worked with Siebel Application team in data refreshment for dev & QA environments.
  • Configuration, Administration and tuning of Oracle 10g and 9i RAC.
  • Data Refresh in Test and Integration Databases using Transportable Table spaces.
  • Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.
  • Oracle Streams Bi-Directional replication implementation at Table, Schema and Database Level.
  • Implemented backup strategies using hot/cold, exp/imp used on the business req.
  • Cloning databases using scripts as well as RMAN and performed Table space point in time recovery (TSPITR) using RMAN.
  • Configured GoldenGate replication between Production and Prime Production, Performance and Prime Performance environments.
  • Installed GoldenGate Director to have a web view of all the GoldenGate implemented servers.
  • Installed GoldenGate Veridata to compare the difference between source and target databases.
  • Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
  • Assisted a team of DBA’s in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2.
  • Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetrix.
  • Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Stats pack.
  • Performed conversion single instance to Real Application Cluster (RAC) database instances.
  • Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
  • Provided database/application tuning including as reducing lock contention, analyzing objects.
  • Down-sizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g and Production to development refresh.
  • Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
  • Install, configure, and maintain Oracle databases, particularly those that handle spatial data using Oracle Spatial and Oracle Locator features.
  • Apply necessary patches and updates for Oracle databases and GIS-related software such as ArcSDE.
  • Manage and maintain spatial data storage, ensuring spatial datasets (e.g., polygons, points, lines) are stored and retrieved efficiently.
  • Optimize spatial data queries and indexing using Oracle Spatial technologies like R-tree indexing and Quadtrees.
  • Integrate Oracle databases with ESRI ArcGIS software, particularly with ArcSDE for spatial data management and versioning.
  • Ensure smooth data exchange between Oracle Spatial and ESRI products, ensuring geospatial data consistency.
  • Tune database performance, focusing on query optimization for geospatial data.
  • Monitor performance of spatial queries and geospatial operations to ensure optimal resource utilization and response times.
  • Utilize Oracle performance tools to track and resolve bottlenecks related to spatial data processing.
  • Develop backup and recovery strategies specific to geospatial data, ensuring the integrity of spatial datasets.
  • Perform regular database backups and implement disaster recovery plans that consider spatial data needs.
  • Manage user access, roles, and privileges, ensuring secure handling of both traditional and spatial data.
  • Implement security measures to protect sensitive GIS data.
  • Facilitate the migration and conversion of spatial data between different systems (e.g., ESRI ArcGIS, Oracle Spatial, and other GIS software).
  • Use Oracle's tools to convert data from different spatial formats, ensuring accurate data representation.
  • Design and implement efficient database schemas to handle spatial data (geometries) within Oracle.
  • Collaborate with GIS teams to model spatial data and create suitable structures for handling geographic and geometric information.
  • Provide support for GIS applications such as ESRI ArcGIS or custom GIS applications that use Oracle Spatial as a backend.
  • Work closely with GIS developers to ensure efficient access to spatial data through APIs or direct database queries.
  • Implement and maintain spatial indexes for large geospatial datasets to optimize query performance.
  • Assist users in writing optimized queries to access spatial data using Oracle's spatial functions and operators (e.g., SDO_GEOM, SDO_RELATE).
  • Ensure the quality and accuracy of spatial data stored in Oracle databases.
  • Perform consistency checks and validations on spatial data using Oracle Spatial's validation functions.
  • Environment: HP-UX 11, Red Hat Linux4, Windows 2000/2003, Oracle 9.2.0.8/10.2.0.3/11i, DB2, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, Data Guard, SQL
  • Plus, PL/SQL, ASM, ToadV9.7 & SQL, Navigator V6.1.
  • Oracle Spatial and Graph: Oracle’s advanced spatial database technology.
  • ArcSDE (Spatial Database Engine): Enables ESRI ArcGIS to work with geospatial data stored in Oracle, ESRI ArcGIS: Geographic Information System (GIS) software
  • PL/SQL: Oracle’s procedural language extension to SQL
  • SQL Loader, Data Pump: Tools for data migration and loading
  • Performance Monitoring Tools: Oracle Enterprise Manager (OEM), AWR, ADDM for monitoring spatial data performance.

Sr. Oracle DBA

New York Life Insurance
Austin, TX
05.2015 - 07.2017
  • 24x7 remote support and on call Database support for Database developers & end-users.
  • Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0, IBM-AIX
  • Successfully upgraded Oracle 10g to Oracle 11g on Solaris nodes.
  • Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 12c from HP UX to Redhat Linux.
  • Installed new oracle 12c standalone & RAC databases as per application requirement.
  • Installed & Configured 12c OEM grid.
  • SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
  • Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
  • Creating and Scheduling Oracle Backend Process Jobs in Crontab.
  • Cloning & duplicating databases using scripts as well as RMAN.
  • Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
  • Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
  • Experience in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
  • Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.
  • Environment: Windows 2000/2003/XP, AIX 5.2/5.3 and Red Hat Linux 5.0, Oracle 10g and 11g, 12C, TOAD 9.0, Oracle Enterprise Manager (GC), RMAN, RAC, Data-Guard, ASM, , TKPROF, Explain plan, AWR, ADDM, SQL
  • Plus, PL/SQL, SQL
  • Loader.

Sr. Oracle DBA

Freescale Semiconductor Inc
Austin, TX
10.2012 - 05.2015
  • Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0, IBM-AIX
  • Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.7) on IBM-AIX nodes.
  • Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 12c from HP UX to Redhat Linux.
  • Installed new oracle 12c standalone & RAC databases as per application requirement.
  • Installed & Configured 12c OEM grid. Configured monitoring metrics for 400+ databases.
  • Worked as a part of team in Data Center Migration project for 6 months.
  • Worked on installations, upgradations & configurations of R12 (E-business suite)
  • Involved in Installation and configuration of Oracle 10g &11gRAC using Cluster ware and ASM.
  • Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.
  • 24x7 remote support and on call Database support for Database developers & end-users.
  • Experienced in the installation of Oracle Grid Control in Server (OMS Oracle management Server) and installing the Agents in all the production, test and development databases and configuring them.
  • Implemented Streams replication between RAC and non RAC database environments.
  • Successfully configured and installed Oracle Golden Gate for replication.
  • Experience in cloning RAC databases using RMAN tool.
  • Configured Goldengate extract and replicate during the database character set conversion.
  • Configured Goldengate datapump extract to move the trail files from source database server to target database server.
  • Installed Goldengate Director to have a web view of all the goldengate implemented servers.
  • Used Goldengate Tokens to get the values of modified date, modified user and operation type from trails.
  • Converted Siebel CRM supporting Oracle database into three node RAC database.
  • Worked with Siebel Application support team in improving the Siebel App-DB performance.
  • Experienced in upgrading Siebel CRM 7x, 8 and other version upgrades & Also helped CRM teams in day to day data refresh & object refresh for dev CRM analysis.
  • Used to merge statement in goldengate replicateparameter file to insert primary key column, modified date, modified user and operation type in the cdc table
  • Experienced in Design, implementation and generating documentation of Oracle 10g Data Guard on both physical/logical standby databases in high availability mode.
  • Implemented Data guard, creating both Logical and Physical Standby databases in 10g &11gRAC environment for the Production databases.
  • Participated & carried out database SOX auditing.
  • Lead DBA team through FSL database SOX standards. Presented & corrected levels of SOX standards.
  • Modified DB environment to meet SOX standards. Presented the Freescale DB environment to external auditors.
  • Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
  • Installed Oracle Streams as an enhancement for the Client’s DW method and monitored Streams Issues using Grid Control.
  • SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
  • Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
  • Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
  • Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
  • Performance tuning and diagnosing DBMS and individual Production databases. Organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
  • Performed policies on data confidentiality, integrity, availability, and auditability, Based on Access Controls for Access to Data at the database level.
  • Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
  • Logical and Physical Database Modeling using CA Erwin 4.1.
  • Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
  • Creating and Scheduling Oracle Backend Process Jobs in Crontab.
  • Cloning&duplicating databases using scripts as well as RMAN.
  • Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
  • Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
  • Implemented VERITAS Net Backup using RMAN (Recovery Manager) as a media management layer.
  • Applying security patches both Server side and Client side and Performed testing.
  • Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
  • Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
  • Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
  • Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.
  • Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink) and managing database security.
  • Environment: Windows 2000/2003/XP, AIX 5.2/5.3 and Red Hat Linux 5.0, Oracle 10g and 11g, 12C, TOAD 9.0, Oracle Enterprise Manager (GC), RMAN, RAC, Data-Guard, Golden Gate, ASM, , TKPROF, Explain plan, AWR, ADDM, SQL
  • Plus, PL/SQL, SQL
  • Loader.

Oracle Developer/DBA

Natsoft Corporation
05.2012 - 09.2012
  • Installed RAC on Oracle 10g release1 and worked on ASM feature of Oracle.
  • 24x7 Production database administration, support and monitoring to ensure a proactive problem Recognition and resolution of database issues.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
  • Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
  • Oracle Grid Control Management Server Installation.
  • Used transportable table spaces (TTS) to move the data Oracle on a different platform and also much faster than performing either an export/import or unload/load of the same data.
  • Implementation of 10g Data Guard and Bi-directional streams implementation.
  • Handling large database environments using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
  • Made performance improvements to the database by building Partitioned tables, IndexOrganized Tables, Materialized Views and Bitmap Indexes.
  • Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
  • Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
  • Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
  • Implemented and followed data security standards and Security User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.
  • Performed application migrations to non-cluster databases to cluster databases.
  • Devised & Implemented backup strategies using hot, cold, and exports based on the business requirements.
  • Applying security patches both Server side and Client side and Performed testing.
  • Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.
  • Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
  • Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
  • Worked with production DBA team in perfect coordination with seniors and team members.
  • Environment: Oracle database 10g (10.1.0.4 to 10.2.0.5), 9i (9.2.0.8), Redhat4, HP-UNIX 10.0, RAC, TOAD, TTS, Erwin 7.2, J2EE, ASM, Oracle Enterprise Manager, Network setup and Management, ASM, RMAN, SQL
  • Plus, PL/SQL, SQL
  • Loader.

Oracle Developer/ DBA

Deccansoft
Hyderabad, India
08.2008 - 08.2009
  • 24x7 Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
  • Migration of Oracle databases from windows to Linux.
  • Applied patches to Oracle Databases and Oracle Applications.
  • Upgrading development and production databases to Oracle 10g.
  • Proactive database monitoring using 10g grid monitoring tool.
  • Database tuning using SQL-Trace, STATSPACK, EXPLAIN PLAN and TKPROF.
  • Extensive Performance Tuning, Memory (SGA) Tuning, net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
  • Performed database cloning to setup test and development databases.
  • Responsible for optimizing the queries and application tuning.
  • Performed SQL tuning and assist developers with coding PL/SQL.
  • Provided support to Application Database Administrators in designing the database.
  • Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups. And performed backup validations using RMAN.
  • Management of schemas, objects partitioning the tables & indexes.
  • Automation of data load using Korn shell scripting and SQL
  • Loader.
  • Responsible for setting and managing user accounts, and granting required privileges to users.
  • Performed other DBA activities like including space management and performance monitoring.
  • Experienced in Oracle Database monitoring, troubleshooting and resolve the issues.
  • Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
  • Created complex analytical reports using inline view, lexical parameters with Oracle Reports 9i.
  • Modified Korn shell scripts as per technical specifications.
  • Prepared Data Flow Diagrams for existing PL/SQL code.
  • Involved in coding MS coding.
  • Developer ASP.Net code for web consoles & created ADO.Net interfaces to database.
  • Designed database tables as per technical specifications.
  • Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
  • Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
  • Environment: MS Visual Studio 2005, MS SQL Server, MS SQL DBA, XML/HTML CSS, Oracle 8.1.7/9i, HP-UX, XML/HTML Windows NT/2000, PL/SQL, SQL Server 2000, T-SQL, Database Tools/Utilities, OPS, Shell Scripting.

Education

Master of Science - Computer Science, Mathematics & Statistics

McNeese State University
Lake Charles, LA
05-2012

Skills

  • Oracle Certified Associate (OCA) in Oracle 11g Database Administration
  • Oracle OCI & MS Azure Administrator
  • AWS / GCP Cloud Practitioner
  • GoldenGate implementation
  • Database troubleshooting
  • Oracle database administration
  • Database security management
  • Oracle exadata management
  • Database cloning
  • AWS, AZURE, GCP database services
  • AWS, AZURE, GCP auto scaling strategies
  • AWS,AZURE, GCP backup and recovery
  • GIS analysis
  • Replication management
  • Log shipping
  • Data warehousing

Certification

  • Certified OCA, Oracle
  • Certified AWS - Cloud Practitioner
  • Certified Google Cloud Engineer

Languages

English
Full Professional
Hindi
Full Professional
Telugu
Native or Bilingual

Timeline

Oracle - Sr. Database Consultant

Austin Technology Services
01.2025 - Current

Oracle DBA - Apps Developer

Department of Veteran Affairs
03.2024 - 01.2025

Oracle Exadata DBA / MSSQL

Consolidated Edison
03.2023 - 03.2024

Oracle - GIS DBA

Communications and Technology Management, City of Austin
07.2017 - 02.2023

Sr. Oracle DBA

New York Life Insurance
05.2015 - 07.2017

Sr. Oracle DBA

Freescale Semiconductor Inc
10.2012 - 05.2015

Oracle Developer/DBA

Natsoft Corporation
05.2012 - 09.2012

Oracle Developer/ DBA

Deccansoft
08.2008 - 08.2009

Master of Science - Computer Science, Mathematics & Statistics

McNeese State University

Similar Profiles

CREATE PROFILE