Sr. RDS DBA w/ Redshift Spectrum - Dallas/Fort Worth Area (must be local) - No 3rd Party

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:

1. Amazon Redshift
2. Spectrum
3. PostgreSQL
4. 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