What are the responsibilities and job description for the Senior Database Architect position at Motion Recruitment?
Database Architect
Atlanta, GA / Minneapolis, MN
Required Skills & Experience
Database automation in AWS with RDS . Preferable : Oracle / Postgres
Creating and maintaining high performance, scalable, and stable database solutions.
Work with customer, deployment squads, and product management to identify and document use case scenarios.
Lead on all data solution aspects including setting data standards and providing your deep technical expertise to development teams for best practices, systems, and architectures.
Design databases solutions that are highly available and meet disaster recovery requirements.
Design effective data store solutions that account for effective capacity planning, data tiering, and data life-cycle management
Design, Develop and maintain automated systems for process for AWS Cloud based products and services.
Troubleshoot issues with automations and ensure efficient solutions.
Collaborate with team members for effective and efficient automations.
Evaluate existing automation process and identify area of improvement.
Monitor and validate performance and functionality of the automated processes to ensure the objectives of automation are met.
Develop and maintain documentation for the automated processes and ensure knowledge transfer.
Mentor other team members on new technologies and automation process.
Work with QA to create detailed test plans and needed tooling to account targeted performance for production volume data
Ensure the successful delivery of solutions, training, and documentation, internally and with customers
Recommend solutions to improve new and existing database systems.
Participate in code reviews and create documentation for engineering and cross-functional practices.
Work with cross-functional teams to ensure end-to-end technical and business viability.
Learn new database technologies as necessary.
Responsibilities :
Provides database support for business applications and schedules back up jobs for user databases.
Provides access control (password resets / account creation / deletion) and checks IP compliance (violation report review, compliance updates and compliance set ups).
Performs data purging and data replication activities.
Researches on connectivity issues and recurring errors in Application database.
Responds to database alerts and takes appropriate actions.
Provides escalation Level 1 and 2 Technical 24x7 support.
Performs database creations.
Performs performance tuning and troubleshooting for database.
Performs application database maintenance and provides technical assistance to users.
Manages database account access and database object changes.
Ensures that monitoring and alerts are properly in place to meet monitoring requirements.
Performs application database and OS scripting.
Reviews Information Protection compliance reports and notifications for individual databases and internal processes (including compliance updates and compliance set ups).
Performs data purging and data replication activities
Performs database recovery from logs, hot & cold backups, Export / Imports and Disaster Recovery.
Performs database creation decommissioning and database updates / migrations to a higher / lower version or cross platform migrations. Also involved in database, schema, and object refresh activities.
Monitors and reports existing database Instance, Database, Server activities for CPU, Memory, and Cach, logs performance, and recommends effective resource utilization / emergency recovery procedures
Performs Business Continuity / Disaster Recovery activities during Business Continuity Plan events.
Plans, schedules, and implements operating system software installs and patches (including 3rd party tools) using change management and release management processes.
Implements database security and auditing features and periodic reviews. Conducts root cause analysis for repeated incidents.
Performs heterogeneous database interface deployment and support for various data interfaces with applications, Middleware interface and functionality deployment with database architecture.
Plans and develops processes for database updates and migrations to a higher / lower version or cross platform migrations. Also, involved in database, schema and object refresh activities.
Develops capacity planning processes that include monitoring of existing database Instance, Database, Server activities for CPU, Memory, Cache, Logs performance and recommends effective utilization of resources and emergency recovery procedures.
Conducts team training and responsible for resource management.
Provides escalation Level 2 and 3 Technical 24x7 support.
Provides Business Continuity Planning / Disaster Recovery support.
Researches new technologies to address operations reliability and compliance.
Implement's and performs configuration management of database cluster and replications.
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Senior Database Architect?
Sign up to receive alerts about other jobs on the Senior Database Architect career path by checking the boxes next to the positions that interest you.
