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
• Provides Escalation Level 2 Technical 24x7 support.
• 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.