Summary/Objective
OffenderWatch is the nation’s leading sex offender registry management and community notification network. More than 3,500 local, state, and federal agencies entrust their sex offender information to OffenderWatch to ensure compliance, increase efficiency, and reduced IT costs, all while helping to protect the public with accurate, timely and complete information. Join us to make a change and help to increase safety and awareness.
We are a growing and increasingly innovative company located in Covington, LA. Over the last two decades, our core technology and network has evolved with the input of thousands of users. The OffenderWatch network group has given insight into not only meeting the minimum requirements of the laws, but also meeting the public safety intent.
OffenderWatch is seeking a qualified applicant to fill the position of SQL Developer / DBA.
Qualified candidates will have a bachelor’s degree with a minimum of 3-5 years’ experience. Primarily a database developer that will work on enhancements and support of a large-scale SQL database for a business-critical application. Must have good troubleshooting skills in order to be able to provide backup support to the production support team for any DB performance-related issues. Ability to work from a requirements or detail design document, coding enhancements to an enterprise-wide collections system.
Major Job duties are, however not limited to the following:
Must be able to meet with business partners to understand requirements.
Will be responsible to create design documents, develop and unit test code changes, and participate with users in UAT testing.
Must be able to look at new processes without documentation and come up with methods to resolve issues.
Support of system and coordinated user testing, and support of enhancements promoted to production.
Ability to create documentation on enhancements coded using Microsoft Office.
Expert at writing stored procedures, functions, triggers
Expert on indexes and performance-sensitive coding methodologies to ensure efficient data retrieval from a large DB, including index management and statistics
Familiar with tools that can aid with profiling server resource usage and optimizing it
Strong Experience with SSIS, SSRS, SQL server Replication
JOB REQUIREMENTS
Position requirements:
Bachelor's Degree in a Computer Software or a related field.
In-depth experience with SQL Server.
Proficient in designing/implementing/administering SQL Server environments
Ability to identify requirements, develop data models, perform data analysis, write SQL queries, design and code complex stored procedures, and performance tune existing database processes.
Assist with complex query tuning and schema refinement.
Proven work experience troubleshooting transaction logs, viewing execution plans, tuning queries, and indexing strategies
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Design, implement and maintain SQL Server database systems
Knowledge of SQL Server from architecture to administration including design, development, and optimization of SQL Server databases.
Database Design and Development
Maintenance and Support (including replication)
Monitoring and Performance Optimization
Review and optimize functions, scripts, stored procedures, triggers, to ensure optimal coding goes into production (JSON, XML, Datasets)
Must feel comfortable in a team-based environment
Ability to effectively present information and respond to questions from groups including co-workers, managers and customers
Supervisory ResponsibilityNone
Position Type/Expected Hours of WorkThis is a full-time position, and hours of work and days are Monday through Friday, 8:30 a.m. to 5 p.m.
TravelNo travel is expected for this position.
Education and Qualifications
Bachelor’s degree in an IT related discipline
Demonstrated knowledge and skills in various programming languages and databases
Work Authorization/Security Clearance
Must pass criminal background check and drug screening.
AAP/EEO StatementOffenderWatch provides equal opportunity in all of our employment practices to all qualified employees and applicants without regard to race, color, religion, gender, national origin, age, disability, marital status, military status, genetic information or any other category protected by federal, state and local laws. This policy applies to all aspects of the employment relationship, including recruitment, hiring, compensation, promotion, transfer, disciplinary action, layoff, return from layoff, training and social, and recreational programs. All such employment decisions will be made without unlawfully discriminating on any prohibited basis.
Other DutiesPlease 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.