What are the responsibilities and job description for the Database Solutions Architect with Cloud and Security Expertise position at Artmac?
Who We Are
Artmac Soft is a technology consulting and service-oriented IT company dedicated to providing innovative technology solutions and services to Customers.
Job Description
Job Title : Database Solutions Architect with Cloud and Security Expertise
Job Type : W2
Experience : 5-15 Years
Location : Ofallon, Missouri
Position Requirements
Artmac Soft is a technology consulting and service-oriented IT company dedicated to providing innovative technology solutions and services to Customers.
Job Description
Job Title : Database Solutions Architect with Cloud and Security Expertise
Job Type : W2
Experience : 5-15 Years
Location : Ofallon, Missouri
Position Requirements
- 5 years of DB2 or PostgreSQL database administration experience
- 2 years of Snowflake data warehouse administration and development experience
- Experience working with cloud PaaS database services.
- Jenkins, GitLab/bit-bucket
- Linux/Unix experience
- Experience supporting highly available and fault-tolerant systems.
- Participate in on-call shifts, our infrastructure runs 24/7
- Security knowledge & experience (Ex. Database Encryption/masking/Certificates/PKI/SSH/VPN)
- An expert problem solver by applying problem analysis methodologies.
- Advanced Azure cloud technologies experience
- Experience on cloud database deployment using terraform.
- Azure Cosmos or similar database technology experience
- Desire to automate everything & anything
- Database development experience
- Networking experience (Ex. TCP/IP, UDP, Routing, Firewalls, load-balancers)
- Desire to document everything
- PCI-DSS or similar experience (ex. financial/government/healthcare)
- Understanding of the ITIL framework.
- Collaborate with cross-functional teams, including customers, project management, software engineering, and network operations, to gather database requirements, improve existing systems, and develop new systems.
- Install and upgrade database systems, ensuring smooth and efficient processes.
- Implement and maintain robust database security measures, adhering to industry standards and guidelines.
- Design and support 24x7 high-availability solutions for seamless database operations.
- Optimize database and server performance by analyzing and configuring physical server hardware, operating systems, and database software settings. Provide recommendations for upgrades and new systems.
- Develop and optimize database components, including queries, stored procedures, ETL processes, and conduct code reviews and optimizations to enhance performance.
- Execute database schema and code changes, perform bottleneck analysis, and ensure efficient server/database performance, including recovery and restores when needed.
- Plan for system growth and scalability to accommodate future requirements.
- Ensure compliance with vendor license agreements to maintain legal and operational integrity.
- Handle various reporting and data export/import tasks, working with different formats like CSV, XML, and unstructured data.
- Document the database environment, processes, and best practices to maintain a comprehensive knowledge base.
- Provide technical support and prompt problem resolution to address any database-related issues.
- Be available for production/on-call support to maintain continuous system availability and address emergencies effectively.
- Be willing to learn new technologies and assist with architecture and design.
- Work efficiently within a high-security environment (Ethoca is PCI-DSS Level 1 certified)
- Communicate clearly and effectively to all levels of the organization.
- Computer Science or Engineering degree or equivalent experience.
- Masters or MBA
