What are the responsibilities and job description for the Sr. Database Engineer/ Architect position at Avance Consulting?
Job Details
Job Title: Sr. Database Engineer/ Architect
Location Carrollton, TX (4120 International Parkway, Suite 2300, Carrollton, Dallas, Texas 75007) 4 Days onsite Role.
Mandatory Skills: Cloud, AWS, Python, UNIX, Shell Scripting, Oracle DB and Postgres DB
Required Key Skills:
Knowledge of Database concepts
o Architecture, storage option, optimizing storage
o Managed services, advantages , disadvantages
Knowledge of database operations
o Backup, Methods, and Tools
o Monitoring
Knowledge of data recovery
o DR Strategies
o DR Tools
o Pros and Cons of different approaches
Knowledge of Data Protection
Knowledge of Data Virtualization technologies
o Conceptual
o Architecture
Python REST API Development (core python skills needed)
AWS Experience - AWS functions Cloud formation, Lambdas, S3, Artifactory, cloudwatch, cloud trail, KMS keys, IAM roles, Security Groups, etc.
builds and maintains Pipelines that deploy databases.
Python, Unix ,Scripting.
Github - Understanding API calls with Swagger
Day to Day responsibility:
While you need to know oracle and Postgres, this team mainly builds and maintains Pipelines that deploy databases. Almost all the build scripts have already been built,
We are just updating them, fixing issues, and adding new functionality.
The person needs to have a good background in Python, Unix ,Scripting.
We use a lot of AWS functions Cloud formation, Lambdas, S3, Artifactory,CloudWatch, cloud trail, KMS keys, IAM roles, Security Groups, etc.
GitHub - a lot of branching and merging. Understanding API calls with Swagger, Java coding could be a requirement as well, or at least knowledge of how to Make changes, etc.