The database administrator (DBA) is responsible for providing technical support for the database environment including overseeing the administration 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. It is extremely important to the company that on-line processing database systems offer the highest reliability and performance possible. 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. Evaluates, provides and designs tools to assist in the management of the database and transaction processing environment. The DBA works to provide a working model of our transaction processing environment for capacity assessment and planning.
The individual develops a methodology for the ongoing assessment of database
performance and the identification of problem areas. Develops and manages security scheme for the database environment, as well as assisting in disaster recovery if necessary. Provides leadership during the development and nhancement 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.
REQUIRED EXPERIENCE
- Degree in one of the following subject areas : Computer Science,
Business Administration, Information Technology or related field preferred
3+ years IT operation with strong understanding of database structures,theories, principles, and practices
3+ years Microsoft SQL Server experienceUnderstanding of, and experience with, server-client computing andrelational database environments
Experience with data management and data processing flowchartingtechniques
Knowledge of reporting and query tools and practicesGood interpersonal, written, and oral communication skillsTechnical documentation skillsAbility to present ideas in user-friendly languageSelf-motivated and directed, with keen attention to detailAble to prioritize and execute tasks in a high-pressure environmentExperience working in a team-oriented, collaborative environmentGood written and oral communication skillRESPONSIBILITIES
Responsible for ensuring availability and performance of the databasesthat support the system.
Work to ensure that the associated hardware resources allocated to thedatabases and to ensure high resilience and performance tuning.
Proactively monitor the database systems to ensure secure services withminimum downtime (SQL Server 2005 / 2008R2).
Responsible for providing trend analysis to management team to enablethem to make informed decisions regarding resource management.
Responsible for troubleshooting and problem solving of SQL development.Responsible for improvement and maintenance of the databases to includerollout and upgrades.
Responsible for implementation and release of database changesaccording to agreed timeframes
Installation, configuration and upgrading of Microsoft SQL Server / MySQL /Oracle server software and related products.
Evaluate MSSQL features and related products.Establish and maintain sound backup and recovery policies andprocedures.
Implement and maintain database security (create and maintain users androles, assign privileges).
Database and query tuning and performance monitoring.Application tuning and performance monitoring.Setup and maintain documentation and standards.Plan growth and changes (capacity planning).Work as part of a team and provide 7×24 supports when required.Do general technical trouble shooting and give consultation to development teams.Interface with external vendors, internal staff for technical support.ITIL Skill set requirement (Problem Management / Incident Management / Chain Management etc)Work with IT and Hosting team on optimal configuration / tuning / configuration of SQL and associated infrastructure / (hardware / network / SAN, etc) to assure optimal performance of the client applications disk configurationAll other responsibilities as assignedCreate, monitor and optimize data exactions, ETLs and other database jobs / processes to assure reliability, and optimal performance of client products and servicesAssess production impact of proposed changes in database environment and support the change management deployment and rollback process as necessaryParticipates in development standards and practices for DBAadministration and maintenance.