Senior Application Developer/Database Analyst

State of Ohio • Columbus, OH

4d • Onsite

About The Position

We are seeking a highly skilled Senior Application Developer/Database Analyst to design, develop, and maintain enterprise-level applications and database solutions that support critical business operations. This role combines advanced programming, database management, and business analysis expertise to deliver secure, efficient, and scalable systems.

Requirements

• Completion of undergraduate core program in computer science or information systems; 36 mos. combined work experience in any combination of the following\: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met including 12 mos. work experience in the primary technology as specified by the agency position description and job posting.
• Or completion of associate core program in computer science or information systems; 42 mos. combines work experience in any combination of the following\: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met including 12 mos. work experience in the primary technology as specified by the agency position description and posting.
• Or 60 mos. combined work experience in any combination of the following\: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met including 12 mos. work experience in the primary technology as specified by the agency position description & job posting.
• Or equivalent of minimum class qualifications for employment noted above.

Nice To Haves

• Experience with Salesforce Sales Cloud, Salesforce Marketing Cloud, Sitefinity, Tableau.
• Knowledge of SSRS, SSIS, ETL processes.
• Familiarity with SFTP and secure data transmission.
• Exposure to application security practices and risk assessment methodologies.
• Proficiency in VB.NET, C#, SQL, and MS SQL Server.
• Strong understanding of relational databases and data integrity principles.

Responsibilities

• Design, develop, and maintain web and in-house applications using VB.NET, C#, SQL.
• Implement solutions leveraging Salesforce Sales Cloud, Salesforce Marketing Cloud, Sitefinity, Tableau, and SFTP.
• Develop and optimize SQL Server stored procedures, queries, and database interfaces.
• Administer relational databases and data warehouses; implement SSRS, SSIS, and ETL processes.
• Perform testing (unit, integration, system), debugging, and documentation.
• Ensure application and database security; conduct risk assessments and penetration tests.
• Provide end-user support and troubleshoot issues.
• Assist with file transmission feeds, hardware/software evaluations, and occasional operational duties.
• All applicants must be authorized and able to in our Columbus, Ohio office. OTTA is unable to sponsor or take over sponsorship of an employment Visa.
• The State of Ohio is a drug-free workplace which prohibits the use of marijuana (recreational marijuana/non-medical cannabis).
• Please note, this position may be subject to additional restrictions pursuant to the State of Ohio Drug-Free Workplace Policy (HR-39), and as outlined in the posting.

Benefits

• Medical Coverage
• Free Dental, Vision and Basic Life Insurance premiums after completion of eligibility period
• Paid time off, including vacation, personal, sick leave and 11 paid holidays per year
• Childbirth, Adoption, and Foster Care leave
• Education and Development Opportunities (Employee Development Funds, Public Service Loan Forgiveness, and more)
• Public Retirement Systems ( such as OPERS, STRS, SERS, and HPRS ) & Optional Deferred Compensation ( Ohio Deferred Compensation )
• Benefits eligibility is dependent on a number of factors.
• Ohio is a Disability Inclusion State and strives to be a model employer of individuals with disabilities.
• The State of Ohio is committed to providing access and inclusion and reasonable accommodation in its services, activities, programs and employment opportunities in accordance with the Americans with Disabilities Act (ADA) and other applicable laws.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree