What are the responsibilities and job description for the SQL DBA/Programmer position at Creative Information Technology, Inc.?
Job Description :
Qualifications and Experience :
- Bachelor’s degree in computer science or related fields.
- 2 years’ experience writing, debugging, and testing PowerShell, SQL, and CMD scripts.
- Advanced knowledge of SQL Server views, stored procedures, scheduled jobs, and database backups.
- Experience with ETL of XML, Excel, and CSV files.
- Experience creating and supporting PowerApps applications and PowerAutomate flows in production use.
- Experience in evolving technologies.
- Experience creating and supporting Power BI visualizations, reports, apps, and dashboards.
- Experience in application support, server support, desktop support and customer service.
- Experience enforcing role-based security using Active Directory.
- Experience integrating SQL Server, SSRS, Oracle Database, Active Directory, UKG Workforce TeleStaff, SharePoint, and Power Platform technologies.
- Experience working with the Maryland State Automated Crash Reporting System (ACRS) data schema.
- Experience developing automated processes for employee directory services.
- Demonstrated creative use of data-driven techniques in disaster recovery.
Scope of Work :
Deliverables :
Continued progress in the full development lifecycle of various projects as needed. Support existing department processes such as DataBak, Color Teams, phone directories, and custom apps for business users.