Senior RDS DBA
Senior Level RDS Database Administrator with 6+ years of experience. Must possess advanced skills in database design, development, security, backup, recovery, performance tuning, and troubleshooting.
**MUST HAVE**
- Amazon Redshift Spectrum
- PostgreSQL
- OLAP
- Local to Dallas/Fort Worth area
Job Duties:
- Responsible for ensuring all database system operational processes are managed according to established service level agreements
- Administration of database objects such as indexes, tables, views, constraints, stored procedures
- Archiving, backup / recovery, replication, cloning, import/export, and refresh
- Administration of database users
- Capacity Management and storage management
- Design, test, and optimize/tune RDBMS components
- Contribute to design, maintenance, and documentation of integrated database security and components in relation to SOX and SAS70 compliance
- Review and assess new features or upgrades to existing RDBMS components as well as application database changes
- Develop, maintain, and optimize programming code for maintenance jobs and application reporting tools
- Develop shell scripts as required
- For databases that may be supported in the future, reviews product literature to assess RDBMS differences and unique features
- Test new technologies and report results
Education/Experience:
- BS/BBA in MIS or CS required or equivalent education
- 5+ years of experience as a DBA in a production and development environment
- Required hands on experience with:
- Amazon Redshift
- Spectrum
- PostgreSQL
- OLAP
- Prefer experience working with healthcare related databases and environments
Specific Requirements:
- Able to identify performance issues and design/implement solutions in an effective manner.
- Able to complete assignments that are defined in general terms
- Self-motivated to direct own workflow in a manner that maximizes results and meets goals and schedules
- Desire to produce high quality, thorough work
- Able to prepare and maintain comprehensive and accurate documentation
- Must be able to adapt presentation to a specific target audience (i.e., client management/personnel)
- Able to transfer conceptual knowledge from current skill set in order to quickly develop expertise in new databases, platforms, or networks
- Adapt well to changing project and departmental priorities. Able to work scheduled hours and overtime when needed
- Strong team orientation, open-minded, able to listen to other's ideas. Good understanding of his/her role, his/her Manager's role, and is able to work well with others
- Willingness to develop expertise in other areas
- Willingness to actively participate in group cross-training by sharing personal areas of expertise with other engineers