DBA

Title: Application DBA
Location: San Antonio, TX or Plano, TX- ONSITE

Skill Set Requirements for Application Database Administrator

1. Data Modeling Expertise:
   • Strong experience in Star-schema, 3NF, Data Vault data modeling to design optimized, scalable database structures.
2. Proficiency with Data Modeling Tools:
   • Proficient in using data modeling tools like Erwin for creating and maintaining logical and physical data models.
3. Business Process Translation:
   • Ability to understand complex business processes and translate them into accurate and efficient data models that meet organizational needs.
4. Industry Experience:
   • Experience in the insurance industry is a plus, providing valuable insight into industry-specific data structures and requirements.
5. Complex Query Handling:
   • Proficiency in working with large tables and complex joins, ensuring data integrity and optimal query performance.
6. Performance-Driven Modeling:
   • Skilled in modeling tables and database structures with a focus on delivering the best query performance and minimizing response times.
7. AWS RDS Proficiency:
   • Extensive experience with AWS RDS (Relational Database Service), including managing and optimizing relational database systems in the cloud environment.
8. SQL Tuning Expertise:
   • Strong experience in SQL tuning, with a proven ability to analyze and improve query performance to meet business needs.
9. NoSQL Database Knowledge:
   • Essential knowledge and experience with NoSQL databases, particularly DynamoDB, to support a variety of data storage requirements.
10. Communication and Interpersonal Skills:
    • Excellent communication and interpersonal skills to effectively collaborate with both business stakeholders and IT teams.
11. Developer Guidance:
    • Ability to guide developers, providing recommendations and best practices for database design, performance optimization, and data management.
12. Database Security and Compliance:
    • Familiarity with database security best practices, ensuring compliance with relevant data protection regulations and standards.
13. Disaster Recovery and Backup Planning:
    • Experience in planning and implementing robust disaster recovery and backup strategies to protect critical data assets.
14. Automation and Scripting:
    • Proficient in automating routine database administration tasks using scripting languages like Python or Bash, improving efficiency and reducing manual work.
15. Version Control Knowledge:
    • Experience with version control systems like Git for managing database schema changes and maintaining version history.
16. Capacity Planning:
    • Ability to plan and manage database capacity, ensuring scalability and availability as data volumes and transaction loads grow.
17. Problem-Solving Skills:
    • Strong analytical and problem-solving skills, with the ability to troubleshoot complex database issues and implement effective solutions.
18. Database Monitoring Tools:
    • Proficiency with database monitoring tools and techniques to ensure optimal performance and quickly identify potential issues.
19. Cross-Platform Database Management:
    • Experience managing databases across multiple platforms (e.g., Oracle, SQL Server, MySQL) and integrating them into a unified data architecture.
20. Project Management:
    • Basic project management skills to oversee database-related projects, ensuring timely delivery and alignment with business objectives.