Database Analyst/Programmer

Emerjence - Washington, DC

Full-time - Mid Level

Washington, DC

Professional, Scientific, and Technical Services

About the position

The Database Analyst/Programmer at Emerjence LLC is a full-time position based in Washington, DC, primarily focused on creating and managing database systems that store and organize data for the Internal Revenue Service (IRS). This role involves designing the structure of the data, writing the necessary code to ensure the database operates effectively, and maintaining its security and performance. The successful candidate will be responsible for formulating and defining system scope and objectives, preparing detailed specifications for programs, and engaging in all phases of applications, systems analysis, programming, and maintenance of computerized databases. This includes installing enhancements, security features, and analytical tools. The role also requires consulting with users to facilitate access to various databases and resolving data conflicts or inappropriate data usage. Additionally, the Database Analyst/Programmer will provide guidance and training to less experienced analysts and programmers, demonstrating strong oral and written communication skills. In detail, the responsibilities include designing and developing database architectures, analyzing data requirements, writing and maintaining database programs and scripts, optimizing database performance, implementing data integration solutions, and ensuring data security. The role also involves thorough testing and debugging of database applications, creating comprehensive documentation, collaborating with business analysts and developers, providing user support, and continuously improving systems and processes by staying updated with industry trends and best practices in database management.

Responsibilities

• Design and develop database architectures, including schema, tables, indexes, and relationships to support business applications and requirements.
• Analyze data requirements and create data models to ensure data consistency, quality, and integrity.
• Write, test, and maintain database programs and scripts, such as stored procedures, functions, triggers, and queries.
• Optimize database performance through indexing, query optimization, and other performance-tuning techniques.
• Develop and implement data integration solutions, ensuring seamless data flow between different systems and applications.
• Implement and maintain data security measures to protect sensitive data from unauthorized access and breaches.
• Conduct thorough testing and debugging of database applications to ensure reliability and efficiency.
• Create and maintain comprehensive documentation for database designs, data models, and programming code.
• Work closely with business analysts, developers, and other stakeholders to understand data requirements and deliver effective database solutions.
• Provide technical support and troubleshooting assistance for database-related issues, ensuring minimal disruption to business operations.
• Stay updated with the latest industry trends, technologies, and best practices in database management and apply this knowledge to improve systems and processes.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field; or equivalent practical experience.
• Prior experience working as a government contractor for a US Federal agency, ideally the IRS, SSA, or HHS CMS.
• Familiarity with SQL Server, Oracle, MySQL, PostgreSQL, NoSQL (e.g., MongoDB, Cassandra), PL/SQL, T-SQL, Python, ER/Studio, ERwin, ETL tools, AWS RDS, Azure SQL Database, Google Cloud SQL.
• Proficiency with DBMS such as SQL Server, Oracle, MySQL, PostgreSQL, or NoSQL databases (e.g., MongoDB, Cassandra).
• Strong knowledge of SQL for querying, programming, and database management.
• Experience with programming languages relevant to database management, such as PL/SQL, T-SQL, or Python.
• Expertise in designing logical and physical data models using data modeling tools (e.g., ER/Studio, ERwin).
• Excellent analytical and problem-solving skills with the ability to troubleshoot and resolve complex database issues.
• Meticulous approach to database design and programming to ensure high-quality and reliable databases.
• Strong verbal and written communication skills to effectively interact with team members and stakeholders.
• Ability to work effectively as part of a cross-functional team, contributing to shared goals and projects.
• Willingness to learn and adapt to new database technologies, tools, and methodologies.

Nice-to-haves

• Relevant certifications in database management, such as Oracle Certified Professional (OCP), Microsoft Certified: Azure Database Administrator, or similar.
• Proven experience in a similar role, with a strong portfolio of successful database projects and applications.
• Familiarity with ETL (Extract, Transform, Load) tools and processes for data integration and transformation.
• Experience with cloud-based database services (e.g., AWS RDS, Azure SQL Database, Google Cloud SQL).