Job Description:
- This position will perform advanced database administration tasks for databases used by the applications with complex data models, workflows and reports. Assist the team in planning, creating, maintenance and monitoring logical and physical data models.
- This position will work on activities including but not limited to database tuning, indexing, data modeling, prototyping, customization, installations, troubleshooting, upgrades, patching, user management, security of data at rest and in motion, disaster recovery, clustering for high availability and load balancing, data backup, purging and archiving, implementation of database policies, data replication and backup to secondary sites like disaster recovery environments, procedures for the integrity, availability and confidentiality of the sensitive and business critical databases.
- This position will need hands on experience as a developer of relational databases in SQL server as well as experience in the management and administration of SQL databases.
- Has working knowledge of EIR Accessibility standards and assistive technologies.
- Ensures that user interfaces for database administration and inputting, viewing, outputting data (via reports) are compliant with accessibility standards.
- Provides support to users in obtaining data / information when EIR Accessibility issues arise.
Minimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
- 8 year required of Azure/SQL Server DBA Experience in an IaaS/PaaS environment
- 8 years required implementing and maintaining data security protocols for sensitive data & PII.
- 8 years required of Azure/SQL Server monitoring and performance tuning
- 8 years required of T/SQL, SQL, DML, DDL and DCL experience
- 8 years required of RDBMS admin/console tools such as TOAD or SSMS
- 5 years required of experience with Azure Data Factory and/or SSIS
- 5 years required of project leadership and implementation
- 5 years required of experience with data pipelines and ETL data structures
- Bachelor’s or advanced degree in a closely related field
- 3 years required of experience with Azure PaaS using Azure Data Factory
- 5 years preferred with Azure SQL Server installation, administration and maintenance
- 3 years preferred with knowledge of Agile methodology
Thanks & Regards
subhadra upadhyay
Source Infotech Inc.
subhadra@sourceinfotech.com
Phone: 609-945-0706