Senior Database Developer

Intelligence and National Security Alliance; Red Bank (NJ); On-site; USD 85,000 - 120,000; Full time

Job summary

Intelligence and National Security Alliance is seeking a data analytics specialist to interact with business stakeholders and design data movement solutions across multiple platforms. You will work with SQL and ETL tools to meet technical needs and ensure robust maintenance of database schemas and views.

The role entails shell scripting, advanced SQL development, performance tuning, and adherence to the SDLC with proper change control policies.

Responsibilities

• Interact with business stakeholders to provide solutions that address business data analytics requirements
• Work with SQL and other database access tools and methods to meet business or technical needs
• Design, implement, and support data‑movement solutions across multiple platforms and data sources (database tables/views and external files) using custom code and ETL tools/frameworks
• Conduct shell scripting and advanced SQL development
• Identify opportunities to fine‑tune and optimize SQL queries and views
• Become proficient in the data model and data structures to efficiently respond to business queries and requests
• Provide ongoing maintenance and support for database schemas and views
• Conduct root‑cause analysis and resolve production problems and data issues
• Work within the defined software development lifecycle, following established change‑control policies

Job description

Responsibilities:

• Interact with business stakeholders to provide solutions that address business data analytics requirements
• Work with SQL and other database access tools and methods to meet business or technical needs
• Design, implement, and support data‑movement solutions across multiple platforms and data sources (database tables/views and external files) using custom code and ETL tools/frameworks
• Conduct shell scripting and advanced SQL development
• Identify opportunities to fine‑tune and optimize SQL queries and views
• Become proficient in the data model and data structures to efficiently respond to business queries and requests
• Provide ongoing maintenance and support for database schemas and views
• Conduct root‑cause analysis and resolve production problems and data issues
• Work within the defined software development lifecycle, following established change‑control policies