Company:
EDI Staffing
Location: Washington Highlands
Closing Date: 19/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Job Summary:
We are looking for a committed and driven Senior Database Administrator with a broad understanding and appreciation of AWS Cloud Databases and hands-on experience with AWS database components and CI/CD pipelines.
We expect our team members to demonstrate technical proficiency as well as strong communication and collaboration abilities. The Senior Database Administrator will contribute directly to design and operational processes and will be empowered to proactively drive best practices and changes at the program and organizational level. Candidates should demonstrate knowledge and understanding of Oracle and AWS Cloud databases technologies, frameworks, and concepts along with excellent communications skills and a desire to learn and grow.
The Database Administration Team is responsible for securing the databases systems by supporting existing controls and processes and through leading efforts to continually improve security across multiple dimensions and domains and enterprise systems. The Senior Database Administrator will support operational database management processes. We expect the Senior DBA to work effectively with internal stakeholders, including the information security team, leadership, developers, system operations and network administrators, and with external vendors including Cloud Service Providers and databases vendors.
The Senor DBA will also be responsible for performance monitoring and tuning. They will work collaboratively with developers, IT Infrastructure and IT Operations to ensure the system is operating within desired specification ranges.
Expertise in enterprise databases management, including Oracle and AWS Cloud platform, Identity and Access Management (IAM), Cloud Watch, Performance Insights and PostgreSQL queries management is desirable. We welcome candidates with strong Cloud or application deployment backgrounds with a willingness to develop expertise in additional database engineering specialties.
Essential Duties and Responsibilities:
Serve as a key escalation point within the database administration team, providing guidance for effective resolution.
Directly triage and respond to databases alerts, database capacity and performance reports, and end-user requests on a regular basis.
Identify and resolve issues in database related controls, systems, and applications.
Lead and support maintenance and troubleshooting activities for the Database Administration program.
Lead and support database vulnerability management processes, such as database patching, database security scanning vulnerability assessment, prevention and remediation efforts.
Databases Systems Availabilities and Reliabilities:
Monitor database status activity daily to make sure that database is up running and is working properly
Support database server Linux patching activities on database server monthly to keep server secured and minimize the risk of malicious impact
Manage and Maintain and Apply Oracle Critical Patch Updates (CPU) patches each quarter and other oracle recommended patch sets when they become available and upgrade AWS Aurora PostgreSQL databases to ensure proper security measures and address any known security risks
Configure and validate Oracle and AWS database backup, exports and snapshots every day to make sure they are working properly
Maintain and update SOPs for Database disaster recovery. Perform periodic review and testing for database recovery processes.
Follow DBA Protocol and procedures to promptly address any database system issues. Ensure adapts to the changing database security landscape, making informed recommendations and decisions to database systems configurations, security controls.
Automate controls and processes where possible.
Compliance
Reach the goal of always being compliant. Collect and centrally maintain all database systems artifacts to respond to audits in a timely manner, with limited SME impact.
Follow best practice to maintain and monitor classic oracle database DBA privilege users
Follow best practice to maintain and monitor the AWS cloud databases to ensure the secrets storing database user information are automatic rotated every 90 days.
Follow best practice to grant proper permission when creating database users.
Maintain classic Oracle database storage to ensure it is good stewards and saving cost by using proper storage type
Monitor the classic Oracle database space usage daily to make sure it has proper available space for the database to reduce space usage cost
Chose proper resource type and size when provisioning AWS RDS database related resources to reduce expenses
Ensure all database related audits information is collected in a timely manner.
Cloud Systems Design and Management
Design and implement AWS Cloud databases systems to ensure failover and monitor capabilities are in place for high availability of database resources.
Design and support the DMS tasks of migrating Data from classic Oracle databases to Aurora Postgres clusters and s3 buckets
Follow best practice to design and creation of database resource using CDK and ci/cd pipelines
Create, maintain and implement Aurora Postgres Database clone from one environment to multiple environments.
Continue to implement, improve, and secure database systems to enhance users' management and databases resources monitoring.
Working with project teams to plan, architecture design, implementation, setting and enforce database standards on AWS Cloud systems environment including Aurora PostgreSQL, AWS DynamoDB and AWS Glue/Athena,
We are looking for a committed and driven Senior Database Administrator with a broad understanding and appreciation of AWS Cloud Databases and hands-on experience with AWS database components and CI/CD pipelines.
We expect our team members to demonstrate technical proficiency as well as strong communication and collaboration abilities. The Senior Database Administrator will contribute directly to design and operational processes and will be empowered to proactively drive best practices and changes at the program and organizational level. Candidates should demonstrate knowledge and understanding of Oracle and AWS Cloud databases technologies, frameworks, and concepts along with excellent communications skills and a desire to learn and grow.
The Database Administration Team is responsible for securing the databases systems by supporting existing controls and processes and through leading efforts to continually improve security across multiple dimensions and domains and enterprise systems. The Senior Database Administrator will support operational database management processes. We expect the Senior DBA to work effectively with internal stakeholders, including the information security team, leadership, developers, system operations and network administrators, and with external vendors including Cloud Service Providers and databases vendors.
The Senor DBA will also be responsible for performance monitoring and tuning. They will work collaboratively with developers, IT Infrastructure and IT Operations to ensure the system is operating within desired specification ranges.
Expertise in enterprise databases management, including Oracle and AWS Cloud platform, Identity and Access Management (IAM), Cloud Watch, Performance Insights and PostgreSQL queries management is desirable. We welcome candidates with strong Cloud or application deployment backgrounds with a willingness to develop expertise in additional database engineering specialties.
Essential Duties and Responsibilities:
Serve as a key escalation point within the database administration team, providing guidance for effective resolution.
Directly triage and respond to databases alerts, database capacity and performance reports, and end-user requests on a regular basis.
Identify and resolve issues in database related controls, systems, and applications.
Lead and support maintenance and troubleshooting activities for the Database Administration program.
Lead and support database vulnerability management processes, such as database patching, database security scanning vulnerability assessment, prevention and remediation efforts.
Databases Systems Availabilities and Reliabilities:
Monitor database status activity daily to make sure that database is up running and is working properly
Support database server Linux patching activities on database server monthly to keep server secured and minimize the risk of malicious impact
Manage and Maintain and Apply Oracle Critical Patch Updates (CPU) patches each quarter and other oracle recommended patch sets when they become available and upgrade AWS Aurora PostgreSQL databases to ensure proper security measures and address any known security risks
Configure and validate Oracle and AWS database backup, exports and snapshots every day to make sure they are working properly
Maintain and update SOPs for Database disaster recovery. Perform periodic review and testing for database recovery processes.
Follow DBA Protocol and procedures to promptly address any database system issues. Ensure adapts to the changing database security landscape, making informed recommendations and decisions to database systems configurations, security controls.
Automate controls and processes where possible.
Compliance
Reach the goal of always being compliant. Collect and centrally maintain all database systems artifacts to respond to audits in a timely manner, with limited SME impact.
Follow best practice to maintain and monitor classic oracle database DBA privilege users
Follow best practice to maintain and monitor the AWS cloud databases to ensure the secrets storing database user information are automatic rotated every 90 days.
Follow best practice to grant proper permission when creating database users.
Maintain classic Oracle database storage to ensure it is good stewards and saving cost by using proper storage type
Monitor the classic Oracle database space usage daily to make sure it has proper available space for the database to reduce space usage cost
Chose proper resource type and size when provisioning AWS RDS database related resources to reduce expenses
Ensure all database related audits information is collected in a timely manner.
Cloud Systems Design and Management
Design and implement AWS Cloud databases systems to ensure failover and monitor capabilities are in place for high availability of database resources.
Design and support the DMS tasks of migrating Data from classic Oracle databases to Aurora Postgres clusters and s3 buckets
Follow best practice to design and creation of database resource using CDK and ci/cd pipelines
Create, maintain and implement Aurora Postgres Database clone from one environment to multiple environments.
Continue to implement, improve, and secure database systems to enhance users' management and databases resources monitoring.
Working with project teams to plan, architecture design, implementation, setting and enforce database standards on AWS Cloud systems environment including Aurora PostgreSQL, AWS DynamoDB and AWS Glue/Athena,
Share this job
Useful Links