Oracle Senior Database Administrator
About The Position
At Allstate, great things happen when our people work together to protect families and their belongings from life’s uncertainties. And for more than 90 years, our innovative drive has kept us a step ahead of our customers’ evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection. We are looking for a talented Database Administrator (DBA) with expertise in both Oracle and MongoDB or SQL Server or PostgreSQL databases. The ideal candidate will have a strong background in database administration, seeking to leverage their skills to ensure optimal performance, security, and reliability of our database systems. If you have 5-7 years of experience and are looking for an exciting opportunity to grow in a collaborative environment, we want to hear from you.
Requirements
- Bachelor’s degree in Computer Science, Information Technology, or related field.
- 5-7 years of DBA experience with a focus on Oracle and MongoDB/SQL Server/PostgreSQL.
- Extensive knowledge of Oracle SQL and PL/SQL, as well as MongoDB/SQL Server/PostgreSQL queries and aggregation framework.
- Proficiency in Oracle database management, including Oracle RAC and Data Guard.
- Experience with MongoDB/SQL Server/PostgreSQL deployment and management tools.
- Familiarity with database monitoring tools and best practices.
- Knowledge of agility tools such as Version1 and ServiceNow.
- Experience with Datadog monitoring.
- Cloud-based database administration experience with Azure or Amazon AWS.
- Familiarity with ITIL practices.
- Proficiency in Python and PowerShell scripting.
- Strong analytical and troubleshooting skills.
- Excellent communication skills for effective interaction with various stakeholders.
Responsibilities
- Manage, monitor, and maintain Oracle and MongoDB or SQL Server or PostgreSQL databases to ensure high availability and performance.
- Configure and optimize database parameters in accordance with best practices.
- Design and implement comprehensive database backup and recovery strategies for both Oracle and MongoDB/SQL Server/PostgreSQL.
- Conduct regular disaster recovery drills to ensure the effectiveness of backup strategies.
- Implement stringent security measures to protect sensitive data across both database platforms.
- Manage user access, roles, and permissions to comply with organizational policies.
- Analyze and optimize database queries, indexing, and overall performance.
- Monitor database performance metrics and address identified bottlenecks.
- Work closely with application development teams to support database-related application needs.
- Assist in schema design, data modeling, and database migrations.
- Maintain thorough documentation of database configurations, procedures, and policies.
- Generate reports on database performance, security, and compliance.
Benefits
- Opportunities for continuing education and professional development.
- Competitive salary and benefits package.
- Comprehensive technology setup, including a laptop, monitors, headset, keyboard, and mouse.
- Monthly connectivity reimbursement for eligible remote employees.
- Support for causes that mean the most to you.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
