Violet Sania
Certified PostgreSQL Database Administrator | Cloud & Data Security Specialist 🚀
- Role
- Senior Postgresql Database Administrator at Citi
- Location
- Dallas, TX, US
- LinkedIn followers
- 500 followers
About Violet Sania
Enterprise Database Administrator specializing in PostgreSQL platform architecture…
Experience
Senior Postgresql Database Administrator
Jun 2019 — Present · Dallas, TX, US
Managed PostgreSQL and AWS RDS databases for critical applications, ensuring high availability, strong security, and peak performance- Set up high availability through pgAutoFailover and streaming replication, reducing downtime and safeguarding data during failover events- Led migrations from on-premises databases to PostgreSQL on AWS EC2 and RDS, using cloud services to boost scalability and reliability- Built and maintained disaster recovery plans using logical and physical replication tools like pgBackRest and Barman to ensure business continuity- Automated database tasks with Ansible and Terraform, integrating these into AWS environments (EC2, S3, RDS, CloudWatch) for smooth operations. Utilized Shell Scripting and Bash for consistent and efficient database management- Configured backups using pgDump, pgBackRest, and AWS S3, enabling data redundancy and point-in-time recovery for data protection- Implemented role-based access control (RBAC) and data encryption with AWS KMS to protect sensitive data and meet compliance standards. Regularly applied updates and patches to PostgreSQL instances, strengthening database security- Deployed monitoring tools like PEM, Datadog, PMM, and DPA to track system health, query performance, and security compliance.Developed custom scripts to quickly identify and address bottlenecks, ensuring optimal resource use.
Education
University of Buea
Bachelor's degree In Computer Science
University of Maryland
Associate's degree
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.