This is a remote position.
We are seeking a Senior Database Administrator (Oracle/AWS)to join our team. Responsible for migration of data from Oracle to AWS. Analyze the design development and delivery or implementation of data solutions including architecture design prototyping of concepts to proof of concept analysis of the development of standards design and test plans code module design development and testing data solution debugging design and implementation of a solution that follows efficient design techniques and development that meets and exceeds the intent of the design of the data solution. Assist with the planning and engineering of the organizations databases.
Requirements
- 8 years experience with a development and maintenance of Logical and Physical database models.
- Handson experience with migration of an Oracle Database to AWS (required).
- Actively developing PLSQL DDL DDM scripts for large/complex data tables.
- Experience with supporting Linux Solaris and Windows systems engineering efforts in system design and evaluation solution engineering software development or system administration.
- Experience with Database Schema as Code tools (e.g. Toad).
- Ability to design and develop complex SQL queries and reports to retrieve required data.
- Ability to develop DDL and DDM to support changes to Oracle tables.
- Experience with database partitioning and microservices.
- Knowledge of Agile methodologies or the software development life cycle (SDLC).
- Experience with installation maintenance and administration of Oracle and AWS.
- Experience analyzing and tuning queries to improve performance.
- Experience configuring integrating patching and securing Oracle database.
Nice to Have:
- Experience with code reviews on SQL change sets and work with developers to create and enforce best practices.
- Exposure to security scanning tools configuring their use and working with teams to fix vulnerabilities.
- Experience with ETL and Data Warehousing methods.
- Experience with Replication technologies such as AWS DMS or Oracle Goldengate.
Required Education/Years of Experience:
- A Masters Degree in a technical discipline 10 years of relevant experience is required. An additional 10 years of experience can be accepted in lieu of education.
Benefits
- Work Location: Remote
- 5 days working
Experience with code reviews on SQL change sets and work with developers to create and enforce best practices. Exposure to security scanning tools, configuring their use and working with teams to fix vulnerabilities. Experience with ETL and Data Warehousing methods. Experience with Replication technologies such as AWS DMS or Oracle Goldengate.