This position is primarily responsible for database design, performance monitoring and optimization, administration, and support. Specific responsibilities include working with software developers to assist in meeting their client requirements in efficient methods and working with client’s system administrators to ensure proper server configuration.
Responsibilities:
- Design and document database architecture
- Analyze and predict capacity and performance requirements
- Automation of DBA functions via scripting
- Evaluate and recommend new database technologies
- Analyze and tune SQL scripts, indices and databases for optimal efficiency
- Support upgrades and patches
- Work with developers to ensure efficient database usage
- Monitor systems and platforms for maximum availability
- Oversee backup, replication, and failover
- Ensure data integrity and privacy
- Knowledge and experience with replication and ETL technologies
- Work with customer DBAs to review and obtain approvals
- Support performance test cycles and troubleshooting to fix any issues
Skills / Experience Required:
- 3+ years of experience with data modeling tools including experience with relational, star schema, and big data models
- 3+ years of experience performing database administration and development using various database technologies such as Oracle, MySQL, PostgreSQL (Teradata, Hadoop would be a plus)
- Experience with data warehousing, and business intelligence
- Solid programming skills, using scripting languages and SQL
- Experience supporting enterprise level complex applications in various architectures, e.g. AWS cloud, etc.
- Experience with database management utilities, reading and interpreting the results of routine database issues and the means to research and determine the causes of more advanced problems
- Ability to assist development teams in troubleshooting cause of SQL and/or application failures
- Experience modeling and working with both transactional 3rd normal form databases and data warehouse star schema databases
- Experience performance tuning transactional and data warehouse system
