Watch Systems

Junior SQL Server DBA / Data Developer

Location

Mandeville , LA

Type

Full Time

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 Junior SQL Data Developer / DBA. 
Qualified candidates will have a bachelor’s degree with a minimum of 1-3 years’ experience.  Primarily a database administrator with database dev skillset 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.
  • Some experience at writing stored procedures, functions, triggers
  • Some experience in monitoring, managing, and maintaining servers, routines, processes.
  • Some experience 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, Availability Groups
  • Familiar with Azure SQL, has had some experience in moving into the cloud
 
JOB REQUIREMENTS
Position requirements:
  • Bachelor's Degree in a Computer Software or a related field or equivalent years of experience .
  • 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 complex SQL Server databases
  • 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 Responsibility No
Position Type/Expected Hours of Work This is a full-time position, and hours of work and days are Monday through Friday, 8:30 a.m. to 5 p.m. Watch Systems offers a hybrid work environment with a flexible schedule that allows work from home each week as focus time. 
Travel No 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 
  1. Must pass criminal background check and drug screening.





AAP/EEO Statement OffenderWatch 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 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. 

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Company Website: WWW.WATCHSYSTEMS.COM

(if you already have a resume on Indeed)

Or apply here.

* required fields

Location*
Resume/Qualifications*

U.S. Equal Opportunity Employment Information (Completion is voluntary)

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Form CC-305
OMB Control Number 1250-0005
Expires 5/31/2023


Why are you being asked to complete this form?

We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.


How do you know if you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition. Disabilities include, but are not limited to:


Disabilities include, but are not limited to:

  • Autism
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
  • Blind or low vision
  • Cancer
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or hard of hearing
  • Depression or anxiety
  • Diabetes
  • Epilepsy
  • Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
  • Intellectual disability
  • Missing limbs or partially missing limbs
  • Nervous system condition for example, migraine headaches, Parkinson’s disease, or Multiple sclerosis (MS)
  • Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression

Reasonable Accommodation Notice

Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job or to perform your job. Examples of reasonable accommodation include making a change to the application process or work procedures, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

i Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.