Database Administrator Sql Server

NIKITHA CHENA PH: 402-***-****

Database Administrator Email: *******************@*****.***

About me:

Talented Oracle certified database professional (OCP) With 9+ years of diverse experience in and managing Oracle 19c, 18c, 12c, 11g, 10g, SQL SERVER, MySQL and Postgres Databases database design & administration in production and non-production databases on various operating systems including Red-Hat Linux, HP-UX, Sun Solaris, IBM AIX and Windows server environments and 2+ years of experience as Oracle Fusion HCM Functional Consultant. Strong collaborator and team player with excellent communication skills and expertise in analytical problem-solving. Technology enthusiast, who likes to spend free time by educating others writing Database technology blogs.

Professional Summary:

Oracle Certified Professional (OCP) with extensive experience administering Oracle 11gR2 through 19c, including managing RAC (Real Applications Clusters), ASM, and Data Guard in both on-premise and AWS EC2/RDS environments.

Designed and implemented Oracle RAC, ASM, and Data Guard to provide high availability, scalability, and disaster recovery, ensuring continuous database uptime and efficient failover capabilities.

Led cross-platform database migrations (Unix/Linux to Windows) using Oracle Goldengate, achieving zero downtime during production migrations and configuring replication at both schema and object levels.

Managed AWS RDS and Redshift databases, optimizing backup solutions, disaster recovery strategies, and resource utilization to support business applications effectively.

Implemented RMAN backup strategies (Full, Incremental, Cumulative) for large databases, automated data refresh processes, and ensured data protection by optimizing backup windows and recovery operations.

Expert in performance tuning, utilizing AWR, ADDM, SQL Trace, and Explain Plans to optimize query performance, indexing, and partitioning, ensuring efficient resource management.

Implemented advanced security measures such as Transparent Data Encryption (TDE), Fine-Grained Auditing (FGA), and auditing controls, ensuring data confidentiality and compliance with industry standards.

Automated routine database management tasks with PL/SQL, shell scripting, cron jobs, and Jenkins for continuous database delivery, improving operational efficiency and reducing manual interventions.

Supported the implementation and maintenance of Oracle PeopleSoft ERP, specifically focusing on HCM data integration using HCM Data Loader (HDL), payroll batch loading, and OTBI reporting.

Managed the full lifecycle of database administration, including installation, configuration, upgrades, patching, migrations, troubleshooting, and providing 24x7 production support across various database environments.

These points effectively capture your expertise and accomplishments across a range of database administration tasks and technologies.

AWS summary:

Hands on Experience in creating and managing databases on Amazon web services (AWS) RDS and EC2 services.

Migrated databases from on premise to cloud environments. Including cross platform migrations.

Performed and documented proof of concept to migrate on premise databases from oracle to AWS aurora database using Data Migration services (DMS).

Can manage AWS services including but not limited to EBS, EFS, IAM, Load balancing, Vertical/Horizontal scaling of servers.

Created and managed S3, S3 glacier bucket for storage.

Knowledgeable of various AWS products like AWS Redshift, SNS, Lambda, DMS, Performance insights, cloud watch, cloud trail, route 53, networking, IAM roles/policies.

Technical SKILLS:

RDBMS Databases

Oracle 19c, 18c, 12c/11g/10g/9i, Oracle Real Application Clusters (RAC), MS SQL Server 2008/2012/2014, MySQL, Postgres, Grid Control, Aurora Postgres/Mysql, Redshift, AWS RDS.

Operating Systems

UNIX, Linux, Redhat Linux, Sun Solaris, HP-UX, AIX, Windows, XP/2012/2014/2018.

Scripting

SQL, PL/SQL, Python, C, C++, Shell scripting, windows batch scripting.

Oracle Utility

RMAN, OEM, Export/Import, Data Pump, SQL*Loader, Goldengate.

Performance Tuning

Grid control, Toad, Quest SQL Optimizer, Trace Analyze, STATSPACK, TKPROF, AWR, ADDM.

Tools

TOAD, Sql Loader Utility, OEM Grid Control, RMAN, Red gate Tools, Solar winds, VMware, Virtual box, Pgadmin.

PROJECT EXPERIENCE:

Datawin (Sprinklr Inc - Remote) June 2020 – Till Date

Role: Senior Database Administrator

About Project:

In this project along with Sprinklr USA. I was responsible to support migration of 100’s of databases from on-prem to AWS cloud, which have been from various vendors like Oracle, Sql Server, Mongodb, postgres on AWS cloud platform using native tools like data pump, backup-restore, goldengate and AWS tools like DMS.

Responsibilities:

Database Migration & Cloud Management: Led migration of databases from on-prem to AWS cloud (RDS, Redshift, DynamoDB), ensuring minimal downtime and seamless transitions.

High Availability & Disaster Recovery: Designed and implemented backup, recovery strategies, and Oracle failover technology for disaster recovery and high availability of critical databases.

Multi-Platform Database Administration: Administered various databases including Oracle, MySQL, PostgreSQL, MongoDB, and Redshift across on-prem and AWS environments.

AWS Cloud Services Expertise: Configured and managed AWS services including EC2, RDS, Aurora, Redshift, Lambda, DMS, and SNS to optimize database performance and automate tasks.

Database Performance Optimization: Conducted database tuning, performance testing, and query optimization in collaboration with application teams to ensure peak performance.

Automated Processes: Developed and maintained shell scripts, Lambda functions, and SQL scripts to automate backup, data loads, and other critical database operations.

Security & User Management: Managed database security by creating roles, permissions, and automating user management, adhering to security best practices.

Database Design & Development: Created and managed complex database objects (tables, views, triggers, packages) and implemented policies for scalable data management.

Cross-Database Migrations: Led migration projects between various database platforms (Oracle to PostgreSQL, SQL Server to Redshift, MongoDB to AWS DocDB), ensuring data integrity and compatibility.

PostgreSQL & Redshift Management: Specialized in PostgreSQL and Redshift administration, including user setup, scaling, query performance tuning, and monitoring.

24/7 Database Support: Provided 24/7 support for production, UAT, and development environments, addressing critical database issues, managing alerts, and ensuring uptime.

PeopleSoft ERP Management: Managed and optimized Oracle PeopleSoft databases (HR, Finance, Portal, EPM) on Oracle 19c, including upgrades to version 9.2.

AWS Project Summary:

Configured database Redshift, Aurora Postgres/MySQL, Oracle RDS.

Performed manual and automated snapshots and backups as needed.

Migrated databases from oracle to postgres, oracle to MySQL.

Configured alerts/notification using AWS SNS topics.

Hands On experience in migrating databases from oracle to Postgres Using SCT (Schema Conversion Tool) and DMS (Data Migration Services).

Good knowledge of AWS Lambda, IAM, Roles, Policies, Security Groups.

Hands-on experience in managing amazon RDS and EC2 instances in AWS (Amazon Web Services).

Created and managed Oracle and AWS Aurora RDS services in AWS.

Migrated multiple oracle databases from on premise to AWS cloud using Amazon DMS service with minimal downtime.

Configured scheduled backups using snapshots and stored them in S3 for a cost-effective solution.

Create AMI images for frequently used applications.

Create and manage IAM role users/roles/groups.

Environment: Oracle Server 19c,12c,11g, SQL, PL/SQL, RAC, Data Guard, AWS, Postgres, EC2, AWS RDS & AWS Redshift

Nelnet, Omaha, NE Dec 2017 – May 2020

Role: Database Administrator

At Nelnet our DBA team manages 100’s of databases that hold student’s payment, personnel and credit card information. As lead DBA I managed various databases including Oracle, SQL SERVER, MySQL and Postgres. My primary concentration is on the oracle side of organization. Our team is responsible for securing databases and supporting developers with activities like database/Schema/Tables data refresh between environments. It is our responsibility to make sure that our databases are level -1 PCI/DSS compliant.

Responsibilities:

Managed and administered Oracle 10g, 11g, 12c, 19c SQL Server 2012/2014, MySQL, and PostgreSQL databases on Linux, Solaris, UNIX, and Windows servers, ensuring high availability and optimal performance.

Installed and configured Oracle databases, including RAC environments, handling database sizes up to 50 TB, and implemented multitenant architecture with Oracle 12c RAC.

Led the migration of on-prem Oracle databases to AWS Aurora Postgres using Data Migration Services, documenting the proof of concept and ensuring seamless cloud integration.

Designed and implemented high availability and disaster recovery solutions using Oracle Data Guard, configuring primary and standby databases and performing switchover and failover tests.

Configured and managed Oracle Goldengate replication for high availability and zero-downtime migrations, including unidirectional and bidirectional replication for cross-platform migrations.

Conducted patching and upgrades on over 100 databases, including CPU, PSU, and interim patches, to maintain security compliance and improve system stability.

Developed and executed Oracle backup and recovery strategies using RMAN, writing custom scripts for database cloning, refreshing schemas, and ensuring enterprise-wide backup reporting.

Utilized Oracle Advanced Security (TDE) for database and tablespace encryption, ensuring compliance with PCI/DSS level 1 standards and implementing strong password security policies using Oracle Secure Store.

Implemented and managed partitioned tables and indexes for performance optimization, and utilized PL/SQL, PGSQL, and SQL for creating complex database objects like triggers, functions, and procedures.

Led DBA teams supporting critical applications, including PeopleSoft, providing continuous 24/7 support, automating tasks using Python, Bash, Korn Shell scripts, and implementing continuous deployment processes with Redgate and Jenkins.

AWS Summary:

Hands-on experience in managing amazon RDS and EC2 instances in AWS (Amazon Web Services).

Created and managed oracle, Aurora postgres RDS services in AWS.

Migrated multiple oracle databases from on premise to AWS cloud using Amazon DMS service with minimal down time.

Configured scheduled backups using snapshots and stored in S3 for cost effective solution.

Create AMI images for frequently used applications.

Create and manage IAM role users/roles/groups.

Configure and manage AWS auto scaling for Ec2.

Environment: Oracle Server 19c, 18c, 12c,11g, SQL, SQL Server 2012/2014, PL/SQL, RAC, AWS, Postgres.

Apollo Health Street, Hyderabad, India Nov 2014 –Jan 2017

Role: Oracle DBA

Apollo is one of the few companies worldwide that can offer end-to-end solutions for all major mobile communication standards. Our networks, telecom services and multimedia solutions make it easier for people, across the world, to communicate. This project is mainly for providing Oracle DBA support for maintaining performance of multiple databases in production, development and test environments.

Responsibilities:

Administered over 50+ database instances, including Oracle 10g/11gR2 and MySQL 5/6 on Linux, UNIX, and Windows platforms, ensuring high availability and optimal performance.

Led the installation, configuration, and upgrading of Oracle, MySQL, and aws

QL databases, including setting up and maintaining Oracle RAC for mission-critical applications.

Managed Oracle Grid Control (OEM) for centralized database monitoring and administration, proactively troubleshooting and resolving issues across databases and applications.

Designed and implemented highly available Oracle RAC clusters and Data Guard configurations for high availability and disaster recovery, ensuring business continuity across critical systems.

Configured and implemented Oracle Goldengate for Active-Active replication between data centers, enabling high availability and real-time data synchronization.

Performed regular database patching, including host OS and database software updates, ensuring that systems remained up to date and secure.

Involved in capacity planning and projecting database growth, advising on hardware configurations to optimize performance and scalability using Data Guard broker and other replication tools.

Utilized partitioning strategies on large tables and indexes (range, hash, list partitioning) to improve performance and streamline maintenance windows.

Developed and executed automated backup and recovery procedures, including shell scripting for both cold and hot backups using Oracle RMAN, ensuring data integrity and disaster recovery readiness.

Provided 24/7 on-call support for production, development, and test databases, resolving performance issues, conducting SQL tuning with Explain Plans, and ensuring consistent database health through proactive monitoring.

Environment: Oracle Server 12c,11g, SQL, PL/SQL, RAC, Postgres.

Berkadia Services, India Hyderabad, India.

Sr Finance Analyst Nov 2013 – Nov 2014

Roles and Responsibilities:

Underwriting analysis for investors on pools of loans from wide range of portfolios.

Generating financial analysis reports and dashboards for investors.

Financial Analysis of the loans which primarily includes Multifamily, Healthcare properties, Senior Housing and Student Housing.

Analyze financial information including operating statements and enroll statements to determine appropriate loan size, terms and pricing.

Review various reports including appraisals, environmental documentation and engineering reports and prepare narrative document to be submitted to mortgage lender.

Working on Multiple loan accounts to meet deadlines without compromising on quality to provide high Customer Satisfaction.

Evaluate mortgage loan requests in order to approve or deny applications.

Determine property values based on appraised market prices and borrowers credit worthiness.

Documentation on share point to build knowledge base for future references and trainings.

Extracting data from sales force to create reports and dashboards for internal and external clients.

Education:

Master’s in Business Administration from JNTUH - 2013 Passed Out

Certifications:

Oracle Certified 10g database Associate

Oracle Certified 11g/12c Database Professional.

Certified AWS cloud Solution Architect Associate.

Oracle Cloud Infrastructure 2023 Certified Foundations Associate.

Oracle Autonomous Database Cloud 2023 Certified Professional

LinkedIn link: https://www.linkedin.com/in/nikitha-chena-ba7293288/

Contact this candidate