SQL Server Database Administrator - iWorks Corporation

Title: SQL Server Database Developer

Location: Remote

About iWorks:

iWorks Corporation, founded in 2005, is a leading provider of information technology and professional services to the federal government. We are a recognized leader in personnel security and vetting solutions, Agile, DevOps, DevSecOps, data analytics, and cloud solutions. Our continuous process improvement approach, combined with our business and technology expertise, results in innovative solutions.

We offer exceptional comprehensive benefits (Medical, Dental, Vision, Life and Disability); 401(k); Profit Sharing; Health and Wellness Benefits; and Paid Sick Time, Vacation Time, and Holiday Time. You're eligible for bonuses throughout the year as part of our incentive program for innovation, and business development. All employees are also considered for an annual raise, commensurate with performance and company commitment.

About this position:

We are seeking a skilled SQL Server Database Developer with expertise in designing, optimizing, and maintaining SQL Server databases for ASP.NET web applications. This role will play a key part in ensuring the performance, scalability, and reliability of our database systems to support our web application initiatives.

Salary Range: 90k-115k - commensurate with candidate's skills, experience, location, and qualifications. 

On a day-to-day basis you will:

1. Design and develop SQL Server database schemas, tables, views, and stored procedures for ASP.NET web applications.
2. Write and optimize complex T-SQL queries, stored procedures, triggers, and functions to support data retrieval and manipulation.
3. Optimize database performance through query optimization, indexing strategies, and database tuning.
4. Implement data models and database architecture to meet application requirements and performance goals.
5. Collaborate closely with software developers to integrate database functionality into ASP.NET applications.
6. Review SQL and T-SQL code written by developers and recommend optimization best practices.
   
7. Conduct database testing, validation, and troubleshooting to ensure data integrity and reliability.
   
8. Perform database migrations, upgrades, and backups in coordination with software releases and deployments.
   
9. Implement and enforce database security policies and best practices to protect sensitive data.
   
10. Stay abreast of new SQL Server features, tools, and industry trends to drive continuous improvement in database performance and scalability.
    

Required Education/Qualifications:

• Clearance: MUST be fully adjudicated & maintain a Top Secret security clearance or higher.
• Education: Associate/Bachelor's degree in Computer Science, Information Technology, or related field; or equivalent work experience.
• Certifications: Security+ CE Certified
• Microsoft SQL Server Certification
• Proven experience in an SQL Server DBA or similar role.
• Strong understanding of data models and database architecture principles.
  
• Strong proficiency in Microsoft SQL Server database development, including T-SQL, stored procedures, and performance optimization techniques.
• Experience with database tools and utilities for monitoring, troubleshooting, and maintenance.
• Familiarity with version control systems and agile software development practices.
• Excellent problem-solving skills and attention to detail.
• Effective communication skills and the ability to collaborate with cross-functional teams.
• Experience in Microsoft SQL Server Reporting Services (SSRS) such as creating, deploying and managing reports using SQL Server Data Tools

Preferred Qualifications:

• Familiarity with scripting languages such as PowerShell for automating routine database tasks, managing deployments, and maintaining database environments.
• Knowledge of Previous experience working with DoD systems, showcasing familiarity with defense-related projects and security requirements.
• Proficient in Microsoft products such as Excel, PowerPoint, Word, Visio, Project and SharePoint.

FLSA & EMPLOYMENT STATUS: FLSA EXEMPT AND FULL-TIME POSITION

iWorks Corporation is an Equal Employment Opportunity/Affirmative Action Employer. We evaluate qualified applicants without regard to race, color, religion, sex, national origin, disability, Veteran status, sexual orientation, or other protected characteristic.