Support SQL Server databases and ensuring their performance, availability and security. Database maintenance and support for databases for the parent organization and assisting with customer support issues.
The Data Base Administrator (DBA) is responsible for providing technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies, and providing Information Technology with a long-term perspective on the relationship of database technology to the business opportunities facing the company. The DBA is challenged to work with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives. Provides and designs tools to assist in the management of the database and transaction processing environment. Works to provide a working model of our transaction processing environment for capacity assessment and planning.
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. Provides leadership during the development and enhancement of production applications including working with applications, technical support and operations during the design, development and implementation of applications. Work with the transaction processing area to develop both the physical and the logical database administration functions and assists in the development of our processing database and computing environments. Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process. Work with vendors in evaluating and implementing new technologies.
Other responsibilities include:
Ensure backups and redundancy is maintained to assure failover mechanisms.
Proactively monitor the database systems to ensure secure services with minimum downtime.
Provide trend analysis to management team to enable them to make informed decisions regarding resource management.
Troubleshoot and problem solving of SQL related issues, including advising on customer issues
Improve and maintain databases to include rollout and upgrades.
Implement and release database changes according to agreed timescales and costs.
Monitoring SQL instances and correcting issues that arise.
Adhere to long-term strategic goals for production databases in conjunction with data owners and department managers.
Work with application development staff to abide by database architectures, coding standards, and quality assurance policies and procedures.
Work with Application Development Manager to create models for new database development and/or changes to existing ones.
Install and configure relevant network components to ensure database access as well as database consistency and integrity as approved by management.
Respond to and resolve database access and performance issues.
Monitor database system details within the database, including stored procedures and execution time. Monitor, optimize and allocate physical data storage for database systems as approved by management.
Assist with planning and monitoring data migrations between systems.
Create, or support creation of, required reports in response to business user needs.
Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
Assist with database transaction and security audits.
Develop routines for end-users to facilitate best practices database use.
Perform database tuning including monitoring, troubleshooting and optimizing performance of the databases.
Setup, monitor, and resolve database mirror issues.
Apply SQL service packs and patches.
The successful applicant will possess the following qualifications:
Bachelor's degree in Computer Information Systems, Computer Science, or equivalent, preferred or a minimum of 5+ years of relevant experience in database administration.
Experience in data warehouse / large database implementation and support.
Experience with SQL Server 2005 and 2008 required.
Database replication, clustering knowledge, and mirroring.
Experience with database design tools. Report server setup and administration.
Strong performance monitoring and tuning skill set.
Extensive knowledge of the SQL language and how to use it.
Strong background in SQL security principles, procedures and best practices.
Working knowledge of single instance/single tenant and single instance/multi-tenant database architectures.
Understanding of SOX, ISO 9000, and web based transaction standards.
Familiar with database encryption.
Familiar with CLR routine support within the database.
Capable of supporting and implementing technology projects in support of business initiatives.
Working knowledge of windows systems administration related to SAN architecture and Raid configurations.
Strong written and verbal communications skills required.
Create and maintain positive and professional business relationships with both internal associates and external customers.
Ability to multi-task and work well under pressure, in a fast-paced environment.
Good understanding of the organizations goals and objectives
Good interpersonal, written, and oral communication skills
Technical documentation skills
Ability to present ideas in user-friendly language
Self motivated and directed, with keen attention to detail
Able to prioritize and execute tasks in a high-pressure environment
Experience working in a team-oriented, collaborative environment
Good written and oral communication skills