Linux System/Database Administrator
Acorn Engineering
Full-time
Montgomery, AL
Job description
ABOUT NWMLS:
Northwest Multiple Listing Service (NWMLS), based in Kirkland WA, is a not-for-profit, member owned organization, and is the largest full-service MLS in the Northwest. We support a membership of more than 30,000 real estate brokers and appraisers by delivering systems, products, and services for the technologically savvy real estate industry in the Pacific Northwest.
We pay competitive salaries and offer a comprehensive benefits package including medical, dental, vision, flexible spending accounts, life insurance, EAP, and 401(k).
Visit www.nwmls.com/about-nwmls/join-our-team/ to see why we qualify as a Great Place to Work!
POSITION SUMMARY:
The .NET Developer / Database Administrator is a full stack developer responsible for the creation and support of applications, utilities and databases used at Northwest Multiple Listing Service. Responsibilities include designing, implementing, and maintaining applications and database systems. Primary job duties are .NET development and supporting SQL Server database administration and T-SQL development. The position may help architect database designs, build new table structures, create views, stored procedures and / or refine existing backend systems and applications as needed to support NWMLS business initiatives.
Coordinate with the IT Development Team Lead in application development initiatives. Ensure database environments support application development needs, website initiatives, RESO IDX, ETL and various system integrations.
JOB FUNCTIONS:
- Supports iterative, agile development methodologies and initiatives in close collaboration and synergy with the development team
- Performs requirements analysis and utilizes software development life cycle best practices to develop, document, test and maintain robust, user friendly applications and utilities
- Writes test plans, conducts unit testing and documents test results according to established standards of the dev team.
- Develops and maintains code documentation, procedures, and policies
- Monitors and conducts performance tuning of databases, indexes, stored procedures, SQL queries and applications
- Monitors database growth, allocates storage and conducts capacity planning
- Investigates and troubleshoots complicated database applications, and stability issues involving large, sophisticated, and evolving system functions including but not limited to database replication, clustering and load balancing
- Maintains database integrity and security including routine SQL Server database patching (typically after hours)
- Assists in database disaster recovery plans, ensuring databases are backed up and fully recoverable, in conjunction with overall disaster recovery initiatives
- Installs, configures, deploys and migrates database systems as needed
- Adheres to best practices for change management processes
- Conducts code reviews and design reviews with development team, and provides written and verbal review feedback to team members
- Works with Development Team Lead and other Developer DBA’s, to implement and maintain database source control and database deployment methods
- Creates and maintains documentation of code and database changes in accordance with IT policies and procedures.
- Evaluates new and emerging technologies, participates in prototyping and provides innovative solutions to benefit the overall dev organization
- Keeps Development Team Lead and Director of IT informed of project progress, potentially controversial matters, and any far-reaching implications
QUALIFICATIONS:
- Bachelor's degree in Computer Science from an accredited college or university; or equivalent education/experience in the computer science field
- Minimum 5 years full stack Application Development experience
- Minimum 2 years of SQL Server Database Administration including SQL Server relational database design and development.
- Strong experience in using: SQL and T-SQL, C#, ASP.Net. Proficient in HTML, CSS, JavaScript, and JSON.
- Strong understanding of application security, load balancing, app monitoring, and troubleshooting.
Job Type: Full-time
Pay: $140,000.00 - $160,000.00 per year
Benefits:
- 401(k)
- Employee assistance program
- Flexible spending account
- Health insurance
- Life insurance
- Paid time off
- Professional development assistance
- Referral program
Work Location: Remote