SQL Database Developer / Administrator


Cognowiz
Dice Job Match Score™
🧠 Analyzing your skills...
Job Details
Skills
- Database Administration
- ERwin
- Database
- Analytics
- Microsoft SSRS
- Microsoft SSIS
- Microsoft SSAS
- Microsoft SQL Server
- SQL
- Windows PowerShell
- Stored Procedures
- Migration
- NIEM
- Performance Tuning
- Recovery
- Regulatory Compliance
- Extract
- Transform
- Load
- CONNX ETL
- SQL Database
Summary
Job Title: SQL Database Developer / Administrator Job Location: Remote/US
Duration: 12+ months
Job Description:
The client is seeking a SQL Database Developer/Administrator to support database development, performance optimization, and data transformation efforts while collaborating with business teams, infrastructure teams, and analytics stakeholders.
- Design and review database schemas for application releases.
- Perform database maintenance (index rebuilds, table reorganization).
- Support day-to-day database operations and troubleshooting.
- Optimize database performance and query efficiency.
- Assist with database upgrades and migration strategies.
- Administer multiple SQL Server databases across environments.
- Develop views, stored procedures, triggers, and functions.
- Work with Microsoft BI stack (SSRS, SSIS, SSAS).
- Develop dashboards and reports using Power BI.
- Support ETL processes and data transformation.
- Participate in unit testing and assist with system/UAT testing.
- Ensure compliance with CJIS architecture standards including JRA, NIEM, NCSC, and GFIPM.
- 5+ years experience with:
- Microsoft SQL Server 2019/2022 (Development & Administration)
- SSRS, SSIS, SSAS
- ETL processes
- Power BI dashboards
- Writing Views, Triggers, Stored Procedures, Functions
- Database performance tuning (indexes, constraints, keys)
- Windows Server 2019/2022
- PowerShell or Windows shell scripting
- Database design tools such as ERWIN or Embarcadero
- RUP / structured development methodology
- CONNX ETL tool
- Disaster Recovery / Business Continuity Planning
- Dice Id: RTX1d96e9
- Position Id: 8915640
- Posted 4 hours ago
Company Info
About Cognowiz
CognoWiz is an innovative and professional services provider firm with expertise on Analytics solutions. We serve you to make better business decisions. Since our founding by a team of ex-consultants, we have focused solely on Business Intelligence Analytics. Based on our background, we have built the company with an emphasis on process and methodology that enables us to deliver repeatable results of high quality to our clients. Our strong customer partnerships based on collaboration and quality of service have allowed us to grow and serve our customers better.
As a service provider, our team members, both internal and external, are the core of who we are as a company. Our team members have deep knowledge required to understand our clients’ needs and to deliver professionals with the right skills and experience for successful projects.
Our work environment is dynamic and challenging. We are focused on attracting and retaining top talent in the industry through an emphasis on entrepreneurship, creativity, innovation and stability.


Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs