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