Database Administrator

Database Administrator
Contract to hire

Summary
The applications database administrator role is responsible for database design and application development, performance tuning, testing of new hardware and software, application troubleshooting and analysis, pre-deployment test plans, production deployment plans, establishing corporate wide security and data integrity standards. Unique challenges are that our product deploys on Microsoft SQLServer, Oracle, and DB2 on multiple hardware platforms, which requires flexibility and creativity from the database administrator.

Responsibilities
The Applications DBA will be responsible for designing, reviewing, of existing database applications, and advising the software development group on all aspects of database design and deployment, working closely with the application architects and designer.

Creates stored procedures, views and design definitions
Performance analysis, index optimization, and query tuning
Creates data mart and data warehouse designs
Designs, configures and deploys Databases
Ensures availability and performance of the databases that supports our application system.
Works to ensure that the associated hardware resources allocated to the databases and to ensure high resilience and performance tuning.
Proactively monitors the database systems to ensure secure services with minimum downtime (both SQL Server and Oracle interface).
Provides trend analysis to management team to enable them to make informed decisions regarding resource management.
Troubleshoots and resolves problems related to SQL and Oracle development.
Improves and maintains databases to include rollout and upgrades.
Implements and releases database changes according to agreed timescales and costs
Ensures that storage, archiving, backup and recovery procedures are functioning correctly
Communicates regularly with technical and operational staff to ensure database integrity and security
Installs DBMS vendor products, and applies updates and patches

Qualifications
Knowledgeable and comfortable in various Backup and Recovery strategies
Experience in applications database design and development with regard to Microsoft SQL Server, Oracle, or DB2, with deeper performance tuning skills in one or more
Knowledge and experience on DB architecture, functions of various DB processes and objects, DB monitoring and tuning, Data Dictionary, DBMS Utilities and tools
Skilled in table, view, stored procedure design
Skilled in database capacity planning
In depth SQL Server and Oracle Database Administration experience including performance monitoring
Strong self-sufficiency and initiative working on Database projects
Excellent knowledge of SQL in multiple vendor dialects
Practical experience in managing the internal and external MS SQL database security
Experience of managing multiple RDBMS on large systems
Experience of working in a team that delivers a high availability service and works closely with project managers, database programmers and web developers
Experience in monitoring and tuning a database to provide a high availability service
Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
Developing, managing and testing backup and recovery plans

Experience / Education
Bachelors Degree (preferably in Computer Science/ Information Systems / Engineering) is desirable
Minimum 5+ years direct work experience
Exposure to Database Training / Workshops / IT Seminars & Conferences
Excellent communication skills
Excellent O/S skill sets in UNIX/Windows
Ability to work well alone or in a group