Database Analyst

Cai - Trenton, NJ

Full-time - Mid Level

Trenton, NJ

Chemical Manufacturing

About the position

The Database Analyst at CAI is responsible for designing, developing, and maintaining the database infrastructure essential for the organization. This full-time position, which offers a hybrid work environment in Trenton, NJ, requires a comprehensive understanding of database design principles and practices. The role involves creating and maintaining detailed documentation of database designs, including Entity-Relationship Diagrams (ERDs), schema descriptions, normalization forms, logical data models (LDMs), and physical data models (PDMs). Additionally, the Database Analyst will develop and maintain a comprehensive data dictionary that documents table descriptions, column definitions, and relationships within the database. In terms of database development and maintenance, the analyst will design, develop, and maintain various database objects such as schemas, tables, views, indexes, and sequences. Ensuring data integrity and security is paramount, and the analyst will implement appropriate normalization principles and security measures. Performance optimization is also a key responsibility, which includes indexing, query tuning, and performance monitoring to enhance the overall efficiency of the database. The role further encompasses the creation and scheduling of database jobs for essential tasks like backups, indexing, and statistics updates. The Database Analyst will also develop and implement maintenance plans to ensure the health and performance of the database. Establishing and enforcing data governance policies and procedures is crucial to ensure data quality and consistency. Collaboration with business stakeholders is necessary to understand their data requirements and ensure that the database infrastructure aligns with their needs.

Responsibilities

• Create and maintain detailed database design documentation, including ERDs, schema descriptions, normalization forms, LDMs, and PDMs.
• Develop and maintain a comprehensive data dictionary documenting table descriptions, column definitions, and relationships.
• Design, develop, and maintain database schemas, tables, views, indexes, sequences, and other database objects.
• Ensure data integrity and security by implementing normalization principles and security measures.
• Optimize database performance through indexing, query tuning, and performance monitoring.
• Create and schedule database jobs for tasks such as backups, indexing, and statistics updates.
• Develop and implement maintenance plans to ensure database health and performance.
• Establish and enforce data governance policies and procedures to ensure data quality and consistency.
• Collaborate with business stakeholders to understand data requirements and ensure the database infrastructure meets their needs.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a Database Architect or a similar role.
• Strong knowledge of database design principles and best practices.
• Proficiency in SQL and a relational database management system (DBMS), such as Oracle, SQL Server, or MySQL.
• Experience with data modeling tools and techniques.
• Strong analytical and problem-solving skills.
• Excellent written and verbal communication skills.

Nice-to-haves

• Certification in database administration or design.
• Knowledge of data warehousing and business intelligence concepts.