Database Developer

The position includes applying business logic through stored procedures and user-defined functions, SSIS packages for ETL and task automation, and maintaining SSRS reports. The person in this position will analyze, consolidate, and tune the database for optimal efficiency, and maintain and ensure the integrity of all data housed in the company’s database. The role will also entail managing day-to-day tasks supporting database administration, data integration and migration, and performance tuning and query optimization.

Responsibilities

We are looking for a unique individual who has skills in both SQL development and SQL database administration. Our focus will be on your SQL development skills.

  • Develop T-SQL Stored Procedures and Integration Services (SSIS) packages in support of ETL activities
  • Maintain existing Reporting Services (SSRS) reports.
  • Recommend solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications
  • Maintain database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products
  • Provide optimization tasks including TSQL optimization, indexing optimization, and database configuration optimization.
  • DBA Tasks
    • Install, configure, upgrade, monitor, maintain and manage multiple SQL Server instances in standalone and virtual environment.
    • Installs revised or new systems by proposing specifications and flowcharts; recommending optimum access techniques; coordinating installation requirements
    • Set up, configure, and perform SQL server patching & upgrades, database migrations and upgrades.
    • Implement and maintain database security and Disaster Recovery solution while implement and maintain backup and recovery procedures.
    • Monitoring systems for performance, stability and capacity using MS Performance Monitor and other tools.
    • Maintain SQL Server replication, mirroring, and clustering.
  • Identify database requirements by interviewing users; analyzing department applications, programming, and operations; evaluating existing systems and designing proposed systems
  • Participate in product roadmap discussions and identify key areas for database improvements
  • Maintain service quality by establishing and enforcing organization standards
  • Follow Change Management procedures to move code and database changes to production

Qualifications

  • 5+ years’ experience with SQL Server and 3+ years’ experience with versions 2017 and/or 2019
  • VERY STRONG T-SQL programming experience
  • 2+ years of experience with SSIS and SSRS
  • 2+ years of experience with SQL Server high availability solutions
  • Database performance tuning (use of Profiler, Query Explanation Plan)
  • Microsoft certifications are a plus
  • Demonstrated ability to write efficient stored procedures
  • Use of development support tools such as Jira and Git

Let us help you find this person. Get in touch with our professional recruiters to help find the right person for this position. It costs you nothing unless you hire the person!

12 + 6 =

By providing my phone number to Harvard Partners, I agree and acknowledge that Harvard Partners may send text messages to my wireless phone number for any purpose. Message and data rates may apply. Message frequency will vary, and you will be able to Opt-out by replying “STOP”. For more information on how your data will be handled please read our Privacy Policy.

`; const blob = window.htmlDocx.asBlob(fullHTML, { orientation: "portrait" }); saveAs(blob, filename); } }); });