Database Architect and Developer

Job Description

Typical Duties and Responsibilities 

  • Provide development and administration support for various databases, primarily 
  • SQL Server databases in a client-server development environment including stored procedures and triggers, SQL and index performance tuning, and database design and file storage. 
  • Develop, deploy, and maintain Extract-Transform-Load (ETL) scripts and schedules. 
  • Develop and implement all database indexing, maintenance, backup, transformations, and stored procedures. 
  • Expose data to application various Business Tiers. 
  • Assist software developers in implementing appropriate data access permission schemas. 
  • Participate in the refinement and development of user stories, assessing the impact of new development on current database implementation and providing level of effort estimates during Sprint planning. 
  • Communicate with technical and product product owner stakeholders to help them anticipate and mitigate configuration management issues

Common Skills and Proficiencies 

  • Experience developing reports using Crystal Reports or SQL Server Reporting Services. 
  • Experience using database tools such as TOAD, Oracle’s SQL Developer or MS SQL Server Management Studio. 
  • Knowledge of developing analytic reports and dashboards using Microsoft Power BI or other similar tools. 
  • Excellent command of the SQL language with the ability to write and optimize complex queries. 
  • Solid knowledge of Relational Database architecture and concepts.

Frequently Required Credentials and Education 

  • Multiple years of development experience in an Oracle or Microsoft SQL Server database environment. 
  • Bachelor's degree in MIS, Information Technology, Computer Science, or Data Analysis. 
  • Hands on work experience in database design, architecture, development and production support for enterprise applications.