The Database Administrator (DBA) is responsible for the health and stability of all Company Microsoft SQL Databases. The DBA supports the activities of the IT staff for specific applications by providing in-depth consulting to all levels of the development team, and IT personnel. The DBA works to establish and maintain a very high level of user trust and confidence towards IT's responsiveness to user's needs. He\She must be able to work in a fast paced, focused environment with a confidence that compliments technical capability.
The DBA resolves all database-related issues and works closely with the Development, Project Management and Infrastructure staff. This includes the identification and resolution of information flow, content issues, and the transformation of business requirements into database definitions. The DBA is required to work successfully with individuals of varying technical levels in a high-pressure and complex environment.
The DBA performs database design reviews managing towards best practices and standards and may help develop detailed logical data models. The DBA must have the ability to architect, design, install, and configure large, complex databases with replication and high-availability. Support activities include analyzing, testing, and implementing physical database designs to support various business applications. Familiarity with Hardware and Operating Systems is needed to complete this job function.
He\She must be familiar with Microsoft SSIS, SSAS, and SSRS database support systems as well as possess version upgrade experience (SQL 2005 to 2012). Experience with design and performance tuning of VLDB's outside of a data warehouse environment is expected. Must be able to guide and consult in the construction of ETL and Data Warehouse using the Microsoft tool suite.
The DBA should possess the following education and experience:
The DBA should have a four-year (or higher) degree from an accredited university. Four or more of years of Information Technology experience, using MS-SQL Server on a Windows platform, is a requirement.
The DBA should possess the following skills:
- Excellent written and oral communications skills
- Proficient SQL scripting skills including stored procedure, functions, and ddl
- Mid-level knowledge of Windows O/S systems administration tasks
- Mid-level knowledge of Hardware in general, and hardware knowledge as it pertains to SQL Server installations
- Display a good understanding of both the RDBMS and the underlying operating system including but not limited to:
- Database performance tuning, replication, monitoring tools and tuning procedures
- Strong database management skills including backup and recovery best practices in a high-availability environment.
- Solid skills in productivity factors and the ability to understand impact of problem on overall database performance
- Knowledge of fault detection and resolution processes
- Strong skills in maintenance tools and best practices processes.
- Ability to work well with customers of varying levels of technical expertise
- Successful experience as a member of a project group
- Demonstrated initiative, good judgment, and the ability to work in a team
- Ability to independently provide time estimates for database related tasks
- Data modeling, data entity analysis, and database design skills may be required
- Use of a data modeling tool such as Erwin, ER/Studio or Designer/2000 a plus
The DBA must possess strong analytical ability, judgment and problem analysis techniques. The DBA should possess in-depth knowledge of the business unit's functions and applications, and an excellent knowledge of system technology alternatives.
The DBA acts on database-related efforts according to established standards with minimal assistance. The DBA is also involved in technical decisions and providing guidance to other members of the IT staff. Management is only required for general guidelines and final reviews.
The final products produced by the DBA are used by the application in Production. There is a direct correlation between job quality and final application quality and stability. Potential risks include data integrity issues, data loss, poor application performance, and system instability.
Performs the following activities:
1. Specify, create, and maintain database instances in Development, Testing, UAT, and Production environments. This includes consistency with standards, security, data models and backup strategy for the database.
2. Create, review, and maintain database objects (including the physical data model).
3. Facilitate the migration of database objects from Development to UAT/Production.
4. Recommend and review database architecture best practices and standards.
5. Has frequent interaction with application development staff.
6. Ensures database reliability and performance.
7. Configure, create, and troubleshoot all SQL Server components.
8. Database objects migration – Transfer and synchronize data records, triggers, SPs, tables, databases, SQL Server agent jobs, DTS packages, etc. amongst different SQL Servers.
For an immediate response include your updated resume and contact information.
Consumer Safety Technology, LLC (CST) is a Des Moines, Iowa based company that prides itself on a strong Iowa work ethic to provide our customers with professional and competent service and the most reliable alcohol monitoring devices available.
In conjunction with researchers at Iowa State University, CST developed the Intoxalock using alcohol-specific fuel cell technology in 1992. CST was the first company in the country to use this cutting-edge technology, which is now an ignition interlock industry standard.
In 2010, CST added advanced technology features through its Intoxalock eLERT™ products and today continues to actively work to advance the IID industry with technology that suits the needs of various federal, state, and local requirements.
No Phone Calls Please