MS SQL Database Administrator
Summary
The SQL Database Administrator is responsible for the design, administration, and support of all database environments including development, QA staging, and production. In this key role, the SQL DBA should have an exceptional understanding of Microsoft SQL 2005 server, MS.NET application development, database design, and hands-on experience in SQL Server administration, security, performance tuning, high availability and exercise solid judgment in choosing the most appropriate approach to solving complex problems.
The SQL DBA will demonstrate dedication, teamwork, initiative and a good understanding of supporting application development environments, web hosting using Microsoft IIS, .NET, and SQL server technologies.
Major Activities
Provide database/application support for a number of business-critical applications which are coupled to Microsoft SQL Server database architecture. Applications may include MS-CRM, Data Warehouse, SAP, Clarity Budget and Planning, TSA Watchlist, Sabre Flight Control Suite, Guest Database, and other in house developed applications.
Support existing Microsoft SQL Server environment with 18+ MS SQL servers and databases in a regulated Airline environment. Plan, install, and implement new databases using Microsoft SQL Server 2005, standalone or clustered architecture; Implement and support multi-tier application architecture using SQL Server as the primary Database platform; Provide technical requirements and support during application evaluation and implementation. This may include suggesting guidelines for vendor product evaluation; Configure and install client/server applications and web-based environments; Troubleshoot issues of performance and/or errors in a multi-tiered environment; Provide ongoing database support in a 24x7 multi-server production environment.
Projects
- Inventory and consolidation of all MS-SQL databases.
- Documentation and the development of a database schema library containing all data elements and artifacts.
- Perform a security review and perform security remediation efforts. This includes the development of database security policies, change management procedures and authorization provisioning.
- Assist in the annual Microsoft Enterprise Agreement True-Up process.
- Develop an enterprise Data Model and Schema reflective of the applications accessing the data and shared data fields and elements.
Skills
- A minimum of 5 years of stable, progressive experience building and supporting MS SQL server database infrastructures in an enterprise level environment with strong SQL server database administration experience.
- Oracle administration experience is a plus.
- Design and implement all database security to ensure integrity and consistency among the various database regions.
- Implement and oversee all database code deployments and changes to the database environment to ensure proper change management processes are adhered to and documented.
- Establish and enforce all database change management, security standards and best practices.
- Strong scripting, debugging and performance tuning experience.
- Demonstrate an exceptional understanding of Microsoft database code troubleshooting practices, development tools and technologies, database clustering technologies and experience with Microsoft Operations Support processes.
- Working knowledge of load balancing and SSL technology, and demonstrated proficiency troubleshooting application and database issues.
- Exceptional verbal and written communications skills, and the ability to effectively and professionally communicate with management, staff and customers as well as demonstrate sound judgment and reasoning skills.
- Ability to assess complex situations, set priorities and implement action plans with a business oriented approach and a proactive understanding and ability to manage end user/customer expectations.
- Data Definition Language, Data Manipulation Language, Standard Query Language
- Physical Database Design Concepts
- Database Performance Tuning
- MS SQL Server Replication
- MS SQL Server Clustering
- Good Oral and Written Communication Skills
- MS SQL Server Certification
- Relational Data Modeling and Logical Database Design
- Physical Database Design and Implementation Experience
- Experience with Online Transaction Processing Systems
- Experience with other DBMS (Oracle, Pervasive, MySQL)
Other
None
Screening and Evaluation Criteria
A Bachelor's degree in Computer Information Systems or Computer Science or equivalent; 3-5 years experience administrating and supporting a Microsoft SQL Server; Comprehensive understanding of SQL Server architecture to include hardware configuration, logical and physical database implementation, performance tuning and security models; Excellent analytical, verbal, and written communication skills.