Overview SQL Server Developer Summary : Delaware Nation Industries (DNI)/Creative IT is currently looking for a SQL Server Developer to join our team located at Tinker AFB in OKC. This team oversees support of the CAMS-FM/G081 application including software development, security, and maintenance. This application provides maintenance, logistics, and aircraft status for the entire mobility fleet. This position is Monday through Friday, 40-hour work week and DNI contributes 100% to employee benefits offering BCBS PPO, vision, dental, matching 401K, short- and long-term disability, and life insurance. Clearance/Certifications: * Must have an active fully adjudicated Secret Security Clearance * Bachelors degree or equivalent years of experience
* Certification in Security required Responsibilities * Creating database triggers for use in automation
* Maintaining data quality and database security
* Ability to code review SQL queries for integration with other applications
* Perform assistance for application bug fixes.
* Knowledge of best practices for database design and development activities. Qualifications Preferred Skills and Experience: * Creating Service Broker Queues and Services
* Trouble shooting Service Broker.
* Trouble shooting with Profiler
* Fix issues related to database performance and provide corrective measures.
* Software updates and patches. * High Availability (i.e. Availability Groups, Replication, Clustering), production releases on 24/7 environments. * Backup and Recovery, Backup archiving. Software knowledge: * Microsoft SQL Server Management Studio (Mandatory)
* Microsoft Visual Studio : create/maintain Database projects (Preferred)
* Microsoft Teams (TFS) : create/maintain of GIT Repository branches (Preferred)
* Quest Toad (Preferred)
* IBM Websphere MQ Series (Preferred)
Databases: * Microsoft SQL Server (Mandatory)
Programming Language Knowledge: * Cobol - At least working knowledge is required
* C#, ADO.net
* Certifications in Database design is a plus AAP/EEO Statement: DNI complies with all federal, state and local laws designed to protect employees and job applicants from discrimination based on race, religion, color, sex, parental status, national origin, age, disability, genetic information, military service, or other non-merit-based factors. Other Duties: Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.