Indiana Center For Congregations Web Programming and Database Associate Indianapolis, IN · Full time Company website

Apply for Web Programming and Database Associate

Key Responsibilities

1. Web Development

• Maintain and enhance web applications, APIs, and web services using programming languages such as Ruby on Rails, WordPress/PHP, HTML, CSS, and JavaScript
• Resolve issues connecting to and querying backend MySQL and Microsoft SQL Server databases
• Collaborate with designers and other stakeholders to ensure functional, visually appealing, and user-friendly websites
• Collaborate with colleagues to support and implement the long-term product vision and roadmap for the CRG and Center web projects as directed by the Senior Director of CRG and Resources
• Collaborate with the Senior Web Developer to write well-designed, testable, efficient code by using software development best practices
• Stay up to date with emerging web technologies and best practices to continuously improve website performance and functionality
• Provide technical support to internal teams, troubleshooting issues and offering solutions to improve system performance and reliability
• Assist in the development and documentation of technical requirements, procedures, and guidelines. Monitor and report on system performance, identifying trends and areas for improvement

1. Database Administration

·      Maintain and enhance the Center’s proprietary database to support organizational data needs utilizing SQL and any other database associated apps and languages. Develop and optimize database queries, stored procedures, and indexes for efficient data access and retrieval

·      Implement and maintain data security measures, backups, and disaster recovery plans to ensure data integrity and availability. Monitor database performance, troubleshooting issues, and implement improvements as needed

·      Provide technical support to internal teams, troubleshooting issues and offering solutions to improve system performance and reliability

·      Assist in the development and documentation of technical requirements, procedures, and guidelines

·      Generate reports and presentations to communicate findings and support decision-making. Collaborate with internal teams to understand data needs and develop appropriate data models and structures

Technical Proficiencies

• Knowledge of Ruby on Rails web application framework
• Basic knowledge of AWS web application hosting and related AWS products (Elastic Beanstalk, EC2, RDS, and S3)
•  WordPress and PHP
• Database work –Microsoft SQL Server and Visual Studio (Visual Basic WinForms)
• Delivra bulk mailing needs
• Solid understanding of how web applications work, including security, session management, constant integration, and development best practices
• Working knowledge of all layers of the application stack from the OS to front-end, including relational database systems, object-oriented programming (OOP), and web application development
• Knowledge of HTML5, CSS3, and JavaScript front-end technologies
• Basic knowledge of search engine optimization (SEO) process
• Proficient in database management systems (e.g., MySQL and Microsoft SQL Server)
• Knowledge of data modeling, normalization, and SQL
• Experience with data analysis and reporting tools (e.g., Microsoft Excel, Power BI, Tableau, Google Analytics)

Required Skills and Competencies

• Strong analytical, problem-solving, and critical thinking skills
• Excellent written and verbal communication skills
• Ability to work collaboratively in a team environment
• Strong attention to detail and organizational skills
• Initiative-taking with a passion for continuous learning and staying current with industry trends

Personal Traits for Cultural Fit

·      Alignment with Center's mission with congregations.

·       Lifelong learner: desire to grow professionally and personally through interactions with diverse audiences

·      High personal work standards to succeed in a high expectation workplace

·      The Web Programming and Database Associate will contribute to the Center's fundamental values of Equity, Responsibility and Relationship.