Job Description :
Job Summary

Responsible for the design, development, implementation, and maintenance of complex Microsoft SQL Server databases. Demonstrates a thorough understanding of concepts of relational databases. Responsible for defining, implementing, and maintaining database structures, procedures, and techniques to ensure data security and integrity. Expected to have a working understanding of DB standards and reasons for implementation, and is expected to understand Change Management methodology and its utilization for database changes. Requires a service oriented mentality and a high sense of ownership of the problems and requests assigned.

Key Activities

Develops and manages consistent database environments that are flexible, reliable and facilitate application development, data delivery and data management. Works closely with developers and technology leaders to ensure that quality solutions are developed. Analyzes and tunes application performance by optimizing database objects. Troubleshoots and provides technical solutions to database issues encountered by new and existing applications in the environment. Actively monitors and recommends changes to the DBMS environment to increase efficiency, improve reliability and minimize operating expenses. Establishes automated procedures for the proactive notification of potential space and performance concerns. Learns the tools used for real-time and proactive monitoring of the database and recommends ways to better leverage them in the environment. Develops, implements, administers and maintains policies and procedures for ensuring the security and integrity of the organization’s database assets. Query tuning, job scheduling and linked server management activities.

Qualifications

Associate’s degree specializing in information systems, technology, or equivalent work experience. Bachelor’s degree preferred.
Two or more years of experience as a SQL Server DBA.
Innovative team player with strong analytical, problem solving and planning skills.
Strong organization skills and ability to effectively handle multiple concurrent assignments.
Strong interpersonal, communication, and leadership skills.
SQL development and SQL tuning experience.
Thorough understanding and compliance of database security best practices.
Must be available for off-hour and on-call work in the event of outages, problems and off-hour required changes.
Experience with Oracle preferred.


In some cases, positions require access to certain sensitive information, which is limited to "Protected Individuals" as defined by U.S. federal immigration law. Protected Individuals include, but are not limited to: U.S. citizens; U.S. nationals; U.S. permanent residents who are not yet eligible to apply for naturalization, but intend to apply once eligible to do so; and U.S. permanent residents who have applied for naturalization within six months of being eligible to do so.
The Reserve Bank does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, sexual orientation, or genetic information in the solicitation, award, or administration of contracts. The Reserve Bank also promotes the acquisition of good and services from small businesses. The Reserve Bank is committed to ensure that all firms interested in doing business with the Reserve Bank, including minority-and women-owned businesses, have the maximum practicable opportunity to participate fairly in contracts awarded by the Reserve Bank.



The Reserve Bank requires that its contractors confirm in writing their commitment to the principle of equal opportunity in employment and contracting. To implement this commitment, a contractor shall, to the maximum

extent possible consistent with applicable law, provide for the fair inclusion of minorities and women in its workforce. If requested by the Reserve Bank, a contractor shall provide documentation, satisfactory to the Reserve Bank, of the actions it has undertaken to verify it''s good faith compliance with this requirement. To the extent permitted by applicable law, the contractor shall comply with this policy in the awarding of subcontracts and shall require it''s subcontractors, if applicable to provide, to the maximum extent possible consistent with applicable law, for the fair inclusion of women and minorities in each of their respective workforces.