Lead Database & Application Administrator

Posted 03/01/2024

Research & Information Services (RIS): The mission of RIS is three-fold: (1) to provide objective information and analysis on the development of the region for use in the area planning and economic development activities; (2) to support the information service needs of NCTCOG; and (3) to assist local governments in the implementation of information technology. Join our team! The RIS team believes in always doing the right thing and treating people with respect. Work in a place where your team values you.

The North Central Council of Governments is currently seeking a highly skilled and motivated individual to join our team as a Lead Database and Application Administrator. We are a dynamic organization that values innovation, collaboration, and a commitment to excellence. This role offers a unique opportunity to work on diverse projects, shape the technological landscape of our organization, and contribute to the success of our business.

As a Lead Database and Application Administrator, you will play a crucial role in driving database and web application design and development. Key responsibilities include:

• Monitors and improves database performance, web performance, network performance, system performance, and generate regular reports.  Gathering requirements from customers and provide overall direction for database requirements and the software development life cycle. Researching and recommending third-party software solutions as needed.
• Define and prioritize project goals, and coordinate and review project work and progress.
• Acts as a technical consultant for new and existing database design and software applications used by the Agency; supports and works on custom coding for databases and web pages, enforcing coding standards and best practices.
• Designs, develops, maintains various databases models, web applications, user interfaces and websites such as:  database models and interactive functions using T-SQL, Stored Procedures, SSRS, and Power BI; web applications using ASP.NET, .NET Framework, .NET Core, C#, JavaScript, HTML, CSS, and PowerShell; user interfaces, reports, and processes/scripts for databases and web applications, often leveraging PowerShell; websites using the Agency Content Management System (CMS) and implement custom functionality within the CMS.
• Administer Microsoft IIS web server configuration, security, management, and maintenance and SQL Server instances, implementing secure user and application environments to best practice.
• Migrate local SQL Databases to Azure, creating both the migration plan and performing the steps and applications and code built on local IIS servers to Azure and other appropriate cloud-based solutions.
• Administer Azure infrastructure resources, ensuring a secure, available, and structured database environment, and the components for successful applications and Azure DevOps system, managing the source control repository and automated build processes.
• Manages external technical resources (contract developer/consults/vendors) on a project-by-project basis by providing feedback, evaluation, and assistance.
• Participates in the interview process to assess the technical abilities of candidates that apply for open Database and Web Developer positions within the department as well as train other Developers, review code quality, and provide recommendations for improvement in all phases of the application development process.
• Maintains Expert-level knowledge of ASP.NET, .NET Framework, .NET Core, C#, JavaScript, HTML, CSS, T-SQL, SQL Server Database technology, SSRS, Power BI, and administration of Microsoft IIS services.  Including knowledge of Azure infrastructure resources.

Qualifications:  

Bachelor's degree in Computer Science, Information Technology, or a related field and 9 years of related work experience.  Additional work experience will be considered in lieu of a degree.

Proven experience in database and web application design and development.

Proficiency in T-SQL, Stored Procedures, SSRS, ASP.NET, .NET Framework, .NET Core, C#, JavaScript, HTML, CSS, and PowerShell.

Experience administering SQL Server instances and Azure infrastructure.  

Familiarity with Azure DevOps and source control systems.

Strong project management and leadership skills.

Excellent communication and collaboration abilities.

If you are a motivated and skilled professional looking for a challenging and rewarding opportunity, we invite you to apply for the Lead Database and Application Administrator position at NCTCOG. Join us in shaping the future of our organization through cutting-edge technology solutions.

FLSA: Exempt

Salary:  

•  $97,536.00 - $110,00.00 - depends on qualifications, skills, & experience.

Benefits Provided:  

• Health - We provide an outstanding package of health and life benefits for employees, with coverage available for their families. We offer medical, dental, and vision coverage, as well as basic and optional life, long term disability, and flexible spending accounts. Our Full-Time employee health coverage is paid for 100%.
• Retirement - Full Time employees participate in the (401a) Retirement Plan offered through Mission Square Retirement by payroll deduction with employer match at 12%.
• Work-Life Balance - At NCTCOG, we want you to achieve a balance between your work and your home life. You'll receive vacation days, holidays, and personal days to use as you choose.
• Professional Development - We view employees as our most valuable resource and promote the professional development of each individual. At NCTCOG, employees receive the support and resources to reach their full potential. Opportunities include tuition reimbursement, paid membership in professional organizations, and a wide range of training opportunities.
• Flexible work schedules.
• Hybrid Officing - Based on performance, job duties, and business requirements, hybrid work environment may include remote work opportunities.

Equal Employment Opportunity Employer:
NCTCOG is an equal opportunity employer/program. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, veteran status, and other classifications covered under federal, state, or local laws. Auxiliary aids and services are available upon request to individuals with disabilities.

Background Check & Drug Testing:
All selected candidates must undergo a pre-employment background check and drug screening. Background checks include national criminal background check, employment history, motor vehicle record check, social security verification, education verification, and other elements as needed. NCTCOG is committed to a safe and drug free workplace and performs pre-employment substance abuse testing. All new hires are required to undergo a drug test which detects the presence of illegal drugs for months prior to testing. We appreciate your cooperation in keeping NCTCOG safe and drug free. In order to receive an offer of employment from NCTCOG, selected candidates must successfully pass the pre-employment background check and drug screening.

E-Verify:
The North Central Texas Council of Governments participates in the federal E-Verify program in order to verify a new employee's authorization to work in the United States. Applicants must be lawfully authorized to work in the U.S.

Job postings are kept open for a minimum of 10 calendar days and may close anytime thereafter at the discretion of the hiring manager.