Database Administrator
• Minimum 3-5 years of recent DBA experience
• Ability to work any hours to support 24/7 operations
• Must resolve problems entirely by either completing the work or gathering all of the resources needed for ultimate resolution and continuity of problem management
• Requires a professional approach in all situations
• Maintains on-line processing database systems at the highest reliability and performance possible
• Improves database integrity through quality assurance and implementation of change control processes related to the SQL environments
• Analyzes existing database applications for performance tuning, alerting & monitoring
• Provides and designs tools to assist in the management of the database and transaction processing environment
• Works with the transaction processing area (OLTP) to develop both the physical and the logical database administration functions and assists in the development of our processing database and computing environments
• Works with the analytic processing area (OLAP) to develop both the physical and the logical database administration functions and assists in the development of our processing database and computing environments
• Develops a methodology for the ongoing assessment of database performance and the identification of problem areas
• Develops a security scheme for the database environment, as well as assisting in disaster recovery if necessary
• Develops and maintains a working model of all transaction processing environment for capacity assessment and planning
• Works with Data Architect to maintain a working model of all analytic processing environment for capacity assessment and planning
• Automates installs of database schemas and other artifacts using modern tools such as use of DacFX and Octopus
• Works with application developers to integrate efforts with relational databases
• Works with Vendors in evaluating and implementing new technologies
• Maintains state-of-the-art knowledge of existing best practices in database administration, design, and implementation, capacity planning
• Liaison with other departments, attend meetings involving other departments and working groups and summarize meetings/requirements related to database administration.
Source link