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