Data Architect

Job Duties

Use DOS IT processes and work with other DOS IT staff to ensure compliance with DOS standards.

Assist in creating queries, interpreting data sets, and writing shell scripts to automate repetitive tasks in order to streamline workflow.

Participate in analyzing and developing PL/SQL packages and executing T-SQL and P-SQL queries.

Participate in analyzing business procedures and specific types of data to improve processes.

Assist in developing conceptual and logical data models, data collection systems, data analytics, and other strategies to optimize statistical efficiency under supervision.

Assist in providing Office of Elections Crime and Security (OECS) staff with data resources from election-related databases needed for case intake, investigation, and management, and transforming specialized data into formatted reports.

Assist in performing database patches, database upgrades, and implementing new features.

Assist in conducting basic monitoring tasks related to OECS databases, including reviewing access logs and observing performance metrics.

Work on database tuning as needed to address performance issues and participate in conducting proactive maintenance.

Participate in analysis and query execution plans and index utilization.

Work on developing new applications, including system design, creation of tables, and setting performance metrics.

Assist in implementing database schema modifications as required.

Help in maintaining records of database configuration updates, user access changes.

Assist in maintaining change logs for user accounts and ensuring security standards are implemented.

Location: Anywhere in USA

Please submit your resume and cover letter to: hr@kalpratech.com