Jobs via DiceDice is the leading career destination for tech experts at every stage of their careers. Our client, Saksoft, is seeking the following. Apply via Dice today
Marysville, OH (Onsite)
Duration: 12 Months The SQL Server DBA provides a technical role in maintaining the operational stability and security of AHMs SQL Server database environment in a cost effective manner Additional responsibilities include providing DBA resources for database development projects funded by the application teams business act as liaison between the SQL Server database team and application teams heshe ensures that all project deliverables by the DBA team are completed within schedule and budget The SQL Server DBA also works closely with Data Architecture team in understanding project requirements leading to the design build and implementation of SQL Server databases
Meet with application teams to understand requirements and recommend high-level direction and approach to upcoming projects
Install and configure SQL Server instances on servers, ensuring proper settings and options are chosen based on the organizations requirements
Finetuning database systems to enhance performance, scalability, and reliability. This includes monitoring and optimizing database query performance, indexing, and database caching
Collaborate with developers and stakeholders to design and implement database schemas, tables, indexes and relationships
Attend ARB meetings to understand the new project requirements as related to database design, build, and implementation of SQL Server database applications
Manage other SQL Server DBA resources to ensure that their availability is aligned with project schedules, supply vs demand
Ensure that all DBA deliverables
Tuning, Monitoring and Patching
Monitor database performance using built-in tools and third-party solutions.
Identify and resolve performance bottlenecks through query optimization index tuning, and configuration adjustments
Configure and utilize monitoring tools to track database health performance metrics and security events.
Set ups to notify administrators of potential issues
Must understand and implement organizational policies and procedures related to the administration of the SQL Server database environment
Conduct regularly scheduled meetings with the team manager to understand Business Plans and Organization QCD metrics
Provide Status reports to the team manager: budget, finance status, project status, etc
Build and maintain good relations with other teams by fostering open communication between the application and database teams
Track job process failures, sev12 and conduct appropriate PDCA associated with all failures and 4Block analysis documentation and presentation
Track portfolio growth, including space management database counts, application counts, etc
Backup and Recovery and DR
Develop and implement backup and recovery strategies to safeguard data against loss or corruption. Regularly test backup and recovery procedures
Implement high availability solutions such as database mirroring, clustering, or Always On Availability Groups
Develop and test disaster recovery plans
Security and Compliance of the SQL Server database environment
Conduct Periodic Access Reviews monthly
Follow and enforce defined database access policies
Maintain daily backup metrics, ensuring all SOX database backups are monitored according to policies and procedures
Develop and maintain SOX documentation, security access backup procedures, and target ZERO SOX deficiencies
Participate in the implementation of PII initiatives as defined by Ent Architecture and application teams
Implementing and maintaining security measures to protect sensitive data and ensure compliance with regulatory requirements such as the General Data Protection Regulation GDPR
What Will This Person Be Working On
Ensure that all DBA deliverables to the projects are performed within the project schedule and budget
Develop and implement backup and recovery strategies to safeguard data against loss or corruption. Regularly test backup and recovery procedures
Develop and implement backup and recovery strategies to safeguard data against loss or corruption. Regularly test backup and recovery procedures
Implement high availability solutions such as database mirroring, clustering, or Always On Availability Groups
Position Success Criteria Desired WANTS
Bachelor's or Master's degree in Information Systems, Computer Science, software engineering, information technology, or equivalent industry experience
5-8 years of Microsoft SQL Server Database Administrator experience
2-4 years of experience in working large scale projects
Should know cloud computing concepts, virtualisation, and infrastructure as a service IaaS platforms
Other Job-Specific Skills
12 YEARS OF EXPERIENCE IN SOX-RELATED REQUESTS
Strong technical knowledge of SQL Server database administration, architecture design, and data analysis
MS SQL Server, MS SQL DB Administration
¿Te interesa este puesto?