Municipal Securities Rulemaking Board Washington , DC 20319
Posted 2 weeks ago
The MSRB is looking for a Senior Database Administrator to work as a member of a highly functioning collaborative team who are responsible for maintaining high levels of availability, security, performance and reliability, while executing the strategy and direction of database administration. This hands-on position provides mentorship to others on the team in database design, operation, and support of a data driven architecture with fit for purpose databases. This position works in a least privileged security environment adhering to strong IT general controls and ensures they are enforced. It drives and ensures database architecture and system alternatives keep pace with industry and monitors current database developments in Cloud native technologies to maximize organizational investments. This position also partners with and supports the data and development teams to ensure proper fit for purpose design and necessary support is received to maximize the MSRB's investment in a data driven architecture.
Qualified applicants will have 8+ years of related experience with other DBMS software including Oracle, PostgreSQL, SQL Server, Aurora. A bachelor's degree in computer related studies, Oracle DBA and AWS certifications are preferred. Applicants must possess advanced knowledge of database practices, Oracle and PostgreSQL DBA administration, database tuning, and recovery. Demonstrated knowledge and experience with Linux/UNIX operating systems, PL/SQL development and IT General Controls. Demonstrated knowledge and experience with AWS Cloud databases, Cloud Watch and SNS alerts, and AWS CDK Pipelines development in Python.
Ability to work in a fast-paced development environment and provide 24x7 support to ensure continuous market presence. Strong writing skills with the ability to read and comprehend complex instructions, write detailed reports and standard operating procedures (SOP), business correspondence, system requirement documents, and training manuals.
Applicants will need to have strong verbal communication skills with the ability to effectively present information and respond to questions from all staff levels. They must also have the ability to perform analysis and interpret general business periodicals, professional journals, technical procedures, and governmental regulations.
Essential Duties and Responsibilities:
Provides leadership for creating and articulating the strategy and direction of database administration for the MSRB Programs
Provides experience in directing the organization to the most effective fit for purpose database solution
Serves as a liaison with key database users, developers and technology delivery team
Key member/driver of the MSRB product development teams
Responsible for cross training team members in appropriate fit for purpose solutions
Develops and monitors a standard process for implementing database, system patches and upgrades
Defines, refines, standardizes, and oversees database performance and tuning practices
Conduct fit for purpose database prototypes
Responsible for database automation to ensure accuracy and minimize costs
Ensures appropriate database backup and recovery practices are in place and executed
Implements, monitors and tests data replication schemes
Maintains Meta-data repository and ensures it is updated as part of the practice
Establishes capacity objectives and oversees the collection and maintenance of capacity data for reporting to management
Plans, performs, and oversees migration of organization database systems to desired state
Enhances the MSRB data replication processes to reduce the amount of time between replications
Performs routine and advanced fit for purpose database development, planning, and coordinating, including base definition, structures, documentation, upgrades, long-range requirements, operational guidelines/protection and support
Provides technical input to software developers and end users in the areas of hardware and database capabilities
Acts as subject matter expert for all database systems
Provides training and guidance to peers and other Database Administrators and Data Developers
Escalation point for 24x7 MSP in support of operational support of organization databases on a rotating schedule
Performs necessary activities for compliance with Regulation Systems Compliance and Integrity
Recommends, writes and follows all relevant policies and procedures to operate a controlled production environment
Mentors and trains staff on AWS PostgreSQL database configuration, monitoring, troubleshooting, and tuning
Performs Python based AWS CDK coding and pipeline development and deployment
Performs other duties as assigned
OUR VALUES
We consider how you do your job as important as what you do, and we live our values daily.
Integrity
Honesty and consistency are core to our values, and we believe that all individuals should be treated with respect, regardless of position. We strive to create a culture that celebrates diversity as a means of inspiring and cultivating innovation, purpose and inclusion among our most important stakeholders, our colleagues.
Teamwork
We feel safe to express our ideas and enthusiastically collaborate to achieve common goals, while reaping the rewards as a team. Exhibiting personal drive and resilience, even in challenging circumstances, is core to our culture.
Trust
We believe in the reliability, competency, and honesty of our colleagues. The confidence in our relationship with others is the groundwork for how we interact and build on those relationships.
Strive for Excellence
We care about making a difference. We contribute our time, talent and creativity to deliver innovative, high-quality and impactful work for the investors, communities and professionals that count on a fair and efficient municipal market. In service to our mission, we strive to build our knowledge, develop our skills and overcome obstacles.
Municipal Securities Rulemaking Board