Priya Chopra
Minneapolis
Summary
Highly skilled Database Specialist with 9+ years of experience managing complex database environments, specializing in Oracle/postgreSQL/AWS RDS/AWS Aurora/MySQL database system optimization, ensuring data integrity and high availability through proactive monitoring and robust backup strategies, resulting in significant performance improvements and minimal downtime. Possesses excellent communication skills and people skills with a nice blend of technology and business. Proficient in an assortment of technologies, including Oracle 12c, PostgreSQL, MS SQL Server 2016, Python, PL/SQL, Linux,Unix , Solaris, Windows, Agile.
Overview
9
9
years of professional experience
1
1
Certification
Work History
DB Specialist
Amdocs development center
12.2019 - 08.2024
- Supporting multiple databases for production, development, testing, and staging purposes on Linux, Sun Solaris, and Windows environments.
- Regularly performed security assessments and managed patching processes, reducing vulnerabilities by 40%.
- Implemented data replication between two different databases using the Data Guard/Streaming replication feature of the Oracle/PostgreSQL database server.
- Configuring PostgreSQL, pgBadger, for generating statistic reports and checking AUTO VACUUM jobs.
- Implemented robust security measures across Azure environments, ensuring compliance with industry standards such as ISO 27001.
- Deployed patches and upgrades on a timely basis to keep up-to-date with latest software releases.
- Implemented the Azure Monitor agent to monitor data, which can maximize the availability and performance of your applications and services.
- Experience with supporting PostgreSQL database migration from on-premise to AWS Cloud.
- Optimized database queries and indexing strategies, resulting in a 25% improvement in application performance.
- Implemented monitoring and alerting systems to proactively address performance issues, reducing downtime by 15%.
- Managed user access and privileges to secure sensitive data effectively.
- Configured and troubleshoot pgbouncer for connection pooling.
- Restructuring of data and defragmentation of the table result in saving gigabytes of disk space.
- Implement and enforce security best practices for AWS Aurora PostgreSQL databases. .
- Installed and configured Oracle 12c Goldengate on the Oracle 12c database.
- Worked on Optima ACC and C1 products, both.
- Monitor the PostgreSQL database server's CPU utilization, memory, database connections, and storage space using pg_stat activity.
- Experience in handling logical and physical PostgreSQL database backups using pg_dump, pg_restore, etc.
- Successful in applying RDBMS patches, like PSU, CPU, and Opatch, for improving the security and functionality of the databases.
- Loading data from flat files to database using SQL Loader, External Tables.
- Solid discipline in providing end-users timely updates on their problems
- Worked closely for better performance in applications, writing the packages, triggers, and indexes on the tables.
- Achieved optimized performance for the databases by rebuilding indexes on tables and indexes.
- Created and worked with multiple PDBs and CDBs.
- Installed the ASM environment and migrated databases from NON-ASM to ASM.
- Added data files to logical volume groups, file system, and ASM.
- Made optimal use of Oracle Support in resolving the SRs
- Documented the standard processes for peers to follow.
- Conducted regular database capacity planning to accommodate business growth.
- Provided support for complex issues related to software tools, applications and databases.
- Monitored database performance and implemented changes to improve response times.
- Performed regular health checks on all databases to ensure optimal performance levels are maintained.
- Assisted in disaster recovery planning by testing various backup strategies and scenarios.
- Provided technical support and training to end-users and junior DBAs.
- Collaborated with stakeholders to gather business requirements for enhancements and change requests.
Database Administrator
NCR corporation
01.2016 - 11.2019
- Installed, configured, and maintained Oracle/PostgreSQL databases on Linux and Solaris environments.
- Create the database as per requirements using DBCA and scripts.
- Monitoring the production Oracle alert logs for database errors.
- Set up jobs and events using Oracle Enterprise Manager Console (OEM).
- Experienced in implementing ASM for data storage and raw devices for clusterware files in RAC environments.
- Creating database objects, like tables, views, and indexes, as per the requirements of the project.
- Implemented Data Guard with high availability and performance configurations, and participated in Data Guard failover tests.
- Scheduling repetitive activities, like gathering schema statistics, exports, and table space usage reports, using crontab.
- Successfully implemented backup and recovery using RMAN, which includes hot backups and cold backups.
- Installed and configured Oracle 12c Goldengate on the Oracle 12c database.
- Performing database/schema/table refresh by using Oracle Data Pump (expdp/impdp).
- Experienced with 11g cluster maintenance using CRSCTL and SRVCTL commands for the Oracle 11g RAC database.
- Written shell scripts that automatically mail and alert for high tablespace usage, alert log errors, high fragmentation of tables, etc.
- 24/7 support for databases and production operation teams.
Education
MCA -
GGSIPU
01.2016
B.Sc.(H) - Computer Science
University of Delhi
01.2013
Senior Secondary -
C.B.S.E.
01.2010
High School -
C.B.S.E.
01.2008
Skills
- Linux (Red Hat)
- IBM AIX
- Sun Solaris
- Oracle 11g/12c/19c
- PostgreSQL
- Azure portal
- Recovery Manager (RMAN)
- Oracle Enterprise Manager (OEM)
- Oracle Data Guard
- Real Application Clusters (RAC)
- ASM
- Data Pump (expdp, impdp)
- AWS services/RDS/Aurora
- EXPLAIN PLAN
- PgAdmin
- Toad
- Team collaboration
- Disaster Recovery
- Replication
- Auditing
- Security remediation/Compliance
- Query optimization
- Performance Tuning
- Troubleshooting
- Change Control/Management
- Agile
- SSRS
Certification
- Oracle Certified Associate 12c (OCA)
- Oracle Autonomous Database Cloud 2019 Specialist
- Certification on Azure fundamentals
- AWS solution architect associate certified
- AWS solution Architect associate
- Azure certified
- Certified Scrum Master (CSM)
Personal Information
Title: Database Architect
Timeline
DB Specialist
Amdocs development center
12.2019 - 08.2024
Database Administrator
NCR corporation
01.2016 - 11.2019
MCA -
GGSIPU
B.Sc.(H) - Computer Science
University of Delhi
Senior Secondary -
C.B.S.E.
High School -
C.B.S.E.
Similar Profiles
Pratik Bhairavnath TawalePratik Bhairavnath Tawale
Software Engineer at Amdocs Development Center India LLPSoftware Engineer at Amdocs Development Center India LLP
Shashank MohitShashank Mohit
Program Manager/ Software Line Manager (Director) at Amdocs Development Center of IndiaProgram Manager/ Software Line Manager (Director) at Amdocs Development Center of India
Kiran Vishnu KothuleKiran Vishnu Kothule
Windows Engineer at Amdocs Development Center India LLPWindows Engineer at Amdocs Development Center India LLP