Sachchida (Sachi) Ojha

Served as a Development interface that is responsible for creating documentation that supports technical and work flow processes that ensures successful implementation of database adds, moves, changes and correctly assess respective system implications.Responsible for building, installing, configuring, and maintaining Oracle Databases that meet production, development and QA requirements.Responsible for of evaluating and reporting Primus rating and trading database consumption, general use, growth patterns and proficient at researching and recommending alternative solutions that decrease costs and increases security.Responsible for installing 11G RAC on RHEL6, upgrading(10G to 11G) and patching Oracle systems, Storage migration (from USP-100 to USP-VM/ AMS 2500) , migrating database from Non-ASM(UFS) to ASM and migrating single instance database to RAC database. Responsible for Monitoring all systems and respective database structures and adjust where required to ensure optimum performance and prevents unneeded financial investments. Facilitate vendor management and relationship building; which includes serving as primary DBA interface for daily issues, negotiating best priced hardware, software and annual support agreements.Configure, monitor, and manage backups for all database instances via NetBackup and RMAN. Identify and implement solutions that monitor and report usage, performance metric’s (CPU high water marks, Memory high water marks, and critical applications usage) across all critical back office systems.Responsible for solid solution change management which factors in performance, performance monitoring, query response times and query response times changes for both end users and applications.Responsible for Oracle ERP database management and Oracle Financial Applications.

Responsible for managing CFSAN production, UAT, QA and DEV databases. Installed and configured OEM Grid Control. Responsible for monitoring RMAN and Export backups. Troubleshooting performance issues and fixing them. Mentoring Jr DBA's and Application dev members. Writing Unix shell scripts for routine maintenance tasks. Migrating non RAC database instances to RAC instances.

Worked at client side. CFSAN, FDA and Office of Management Yystems(OMS).

Oracle Database Administration (DBA) support for agency Oracle Production and development databases running on the Solaris operating systems. The target database environment includes Data warehouse, online transaction processing (OLTP) applications, online analytical processing (OLAP) applications, and decision support systems (DSS). In addition provides Oracle Database Administration (DBA) support for the MMA Management Information System data warehouses, data marts, interfacing database systems, and other CMS mission critical Oracle databases as the operational scenarios warrant. Responsible for developing and executing appropriate Data Definition Language (DDL) to support projects. Provides query performance monitoring and tuning recommendations. Involved in tuning explain plan, studying stats pack metrics, AWR metrics and ADDM analysis reports. Performed memory tuning like PGA tuning and parallel queries tuning and creating Materialized views as required. Performed upgrades, migration, cloning of database instances. Reviewing and approving all application based scripts, utilities, stored procedures, functions, and triggers, other duties like performing database backup and recovery, providing input on instance parameter settings and tuning, providing general database expertise to application projects. Leading and conducting technical reviews of physical database models. . Led several tuning efforts using AWR, SQL tuning.

Worked for Client "Centers for Medicare & Medicaid Services".

•Creation and maintenance of schema objects.•Writing SQL and PL/SQL Scripts to create stored procedures, functions, packages and database triggers.•Loading data into database using SQL*Loader. •Work closely with and provide consultation to developers.•Evaluate software that access RDBMS, such as front-end tools and Provide recommendations. •Explore features of new RDBMS versions and make recommendations.•Using oracle 8i/9i analytical function to optimize the large OLAP Queries used for generating Reports.•Effectively using Hints to optimize the throughput and response time.•Monitoring Fragmentation, Row Chaining and High water marks. •Planning and Implementing Materialized views, Snapshot Replication and Advanced Replication.•Testing and validating backup procedures on a simulated database to recover from different types of DB failures.

About Secure-ElementsSecure Elements develops innovative products that help organizations achieve IT security compliance. We enable organizations to audit, evaluate, and comply with internal, industry, and regulatory policies. Our solutions reduce business risk and IT management costs while improving systems performance and maintaining business continuity. Based in Northern Virginia, Secure Elements serves organizations in the federal government and critical infrastructure markets, as well as the Global 1000. http://www.secure-elements.com. Being DBA in secure-elements, I was responsible for all database design, management, SQL scripting, shell scripting and migration from PostgreSQL to Oracle and vise-a-versa.

•Capacity planning, partitioning/sub-partitioning, performance tuning & performance enhancements.•Managing Very large database (Size > 5 TB)•Creation and maintenance of schema objects.•UNIX/PERL Scripting.•Schema/data Migration.•Performs analyses, development and evaluation of data mining in a data warehouse environment which includes data design, database architecture, and metadata and repository creation. Work with user community to produce various reports and charts.•Prototyping solutions, preparing test scripts, and conducting tests and for data replication, extraction, loading, cleansing, and data modeling for data warehouses.••Database Backups and Recovery using DB Export/Import.•Writing SQL and PL/SQL Scripts to create stored procedures, functions, packages and database triggers.•For effective and efficient deployment, build and keep a checklist which defines required deliverables at each stage.

•Creation and maintenance of schema objects.•Writing SQL and PL/SQL Scripts to create stored procedures, functions, packages and database triggers.•Loading data into database using SQL*Loader. •Work closely with and provide consultation to developers.•Evaluate software that access RDBMS, such as front-end tools and Provide recommendations. •Explore features of new RDBMS versions and make recommendations.•Using oracle 8i/9i analytical function to optimize the large OLAP Queries used for generating Reports.•Effectively using Hints to optimize the throughput and response time.•Monitoring Fragmentation, Row Chaining and High water marks. •Planning and Implementing Materialized views, Snapshot Replication and Advanced Replication.•Testing and validating backup procedures on a simulated database to recover from different types of DB failures.

Capacity planning, Loading Data into Data Warehouse from different sources, Cleaning, Filtering, making Data Marts, Developing Reports, Charts and Maps using Crystal Report, Responsible for Backup and Recovery. Working platforms includes UNIX, Windows NT, Oracle 8, PL/SQL, SQL*Plus, Crystal Report 7.0.

Project planning, management, implementation and support, capacity planning, performance tuning & training.

System analysis and design, develop coding schemes, application development and testing using C++, schema design and development, capacity planning, tuning & performance enhancements.

System analysis and design, develop coding schemes, application development and testing using C++, schema design and development, capacity planning, tuning & performance enhancements.