US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 19th Sep 2024
• Follow CLIENT IT processes and coordinate with other CLIENT IT staff to ensure compliance with CLIENT standards.
• Create queries and accurately interpret multiple data sets; write shell scripts to automate repetitive tasks in order to streamline workflow; analyze and develop PL/SQL packages and execute T-SQL and P-SQL queries; analyze business procedures and recommend specific types of data to improve processes.
• Develop conceptual and logical data models, data collection systems, data analytics and other strategies to optimize statistical efficiency; provide OECS staff with data resources from election related databases needed for case intake, investigation and management; transform specialized data into formatted reports.
• Proposes and implements failover strategies. Performs database patches.
• Performs database upgrades and implements new features. Schedules the monitoring of successful database back-ups. Performs database restores as required.
• Responsible for conducting low level monitoring, access control, and performance of OECS databases; overall solution configuration; database and related systems architecture, availability planning, including Disaster Recovery; monitor all database environments for capacity, integrity, and efficiency.
• Performs database tuning as needed to address performance issues; conducts proactive maintenance. Responsible for analysis and query execution plans and index utilization. Assists in the development of new applications, including system design, creation of tables, and setting performance metrics. Implement database schema modifications as required.
• Maintain change logs for all database configuration updates and changes for all database servers. Maintain change logs for user accounts and ensure security standards are implemented.