Senior Database Administrator

JOB DESCRIPTION DETAILS

The Senior Database Administrator ensures that IT-related administrative infrastructure and systems are functioning properly, efficiently, and integrity is secured with minimal downtime; that end-users receive the appropriate levels of rights and privileges to system resources required for them to carry out their work effectively and efficiently.

PRIMARY DUTIES & RESPONSIBILITIES

• Monitor and proactively maintain a multi-server environment consisting of SQL Server 2005 and 2008 servers on both Windows 2003 and above platforms in production, staging and laboratory environments

• Maintains database results by setting and enforcing standards and controls.

• Prepares for database expansion by studying plans and requirements; advising senior technical

management; coordinating design and programming.

• Keeps senior technical management informed by preparing reports on system performance and problems.

• Upgrades hardware and software by assessing transaction processing and database production options.

• Maintains database performance by troubleshooting problems.

• Accomplishes platform upgrades and improvements by supervising system programming.

• Secures database by developing policies, procedures, and controls.

• Updates job knowledge by participating in educational opportunities; reading professional

publications; maintaining personal networks; participating in professional organizations.

• Recommends certification and accreditation as well as security remediation for various business applications with a focus on database related tasks

• Develop and implement improved processes for server maintenance, back-up and recovery, fail over and clustering

• Maintain documentation for maintenance processes, server configurations (both how to

configure and current configurations)

• Maintain, administer, and monitor Firm related databases and data stores

• Propose improvements to directories and directory structures to facilitate ease of

administration

• Propose, plan and implement security solutions to counter and prevent threats of all forms

• Prepare detailed data backup and recovery plans for all platforms

• Conduct routine backups of server data on all platforms

• Provide support and training in use of the application, including orientation for all new staff and specialized training in response to changing roles, business processes and database

functionality.

• Work with help desk to provide technical assistance to users and troubleshoot and resolve

application and database related problems (including donor, grants and financial databases).

• Manage the relationship with software vendors support team, escalating issues that require

immediate resolution and advocating for fixes/patches to the applications when appropriate.

QUALIFICATIONS

• Bachelor's degree in Information Technology, Computer Science or other related fields

• At least 3 years of experience as a Database Admin on Windows platform and in administering SQL/Pervasive, Oracle, Linux/UNIX

• Understanding of performance monitoring tools, index and query optimization

• Knowledge of SQL Server architecture, such as objects, schemas, system database, SQL Services and SQL Agent

• Knowledge of SQL Server backup/restore and other maintenance strategies

• Ability to troubleshoot and solve SQL Server performance issues

• Experience writing SQL statements

• 2 to 4 years experience designing, developing and generating reports from a relational database application. Database design, deployment and management experience is highly desirable.

PREFERRED QUALIFICATIONS

• Strong analytical and organizational skills

• Eye for detail and accuracy and can work independently

• Works well under pressure and position is on-call basis

• Business awareness and understanding of IT requirements