Procom

SQL Database Administrator (BB-E03C8)

Found in: Talent CA

Description:
SQL Database Administrator On behalf of our client in the Government Services Sector, PROCOM is looking for a SQL Database Administrator.SQL Database Administrator – Job Description Responsible to support the installation, configuration, security, operation, and maintenance of SQL Servers and new servers builds with special focus on SQL 2019 and Azure manage instance. Provides support in the creation and maintenance of 'big data' analytical platforms. Responsible providing support for SQL Server Big Data Clusters (BDC) Responsible for the development, execution and analysis of database expansions, re-organization and purging of SQL 2019 Develops systems and processes to monitor data quality or integrity, diagnose problems and implement solutions. Provides expertise in the support of complex cross-platform database migrations and data governance activities. Responsible for SQL high availability options (Log Shipping, DB Mirroring, DB Clustering) Resolves and debugs complex reporting and analytic application problems Participates in the creation and maintenance of the Enterprise Data Strategy Plan Participates in the long-term technical strategy and architecture for the Data Warehouse and Analytics Data Hub Responsible for managing the SQL databases on Azure Cloud, SQL Always-On and Clustering. Provides knowledge and direction assistance to support a hybrid environment of on premise and cloud-based database environments. Configure, manage, monitor and maintain database server performance, health, availability and security. Provide feedback and recommendations to management for best course of action where needed Participates in problem analysis and resolution, for example tuning of SQL query, deadlocks, data problems, access times, application recoveries, etc. Performs software review, evaluation, recommendations, design and implementation for database management tools. Leads database disaster recovery design, implementation and monitoring. Patching, and database backup including testing and execution of SQL database backup and recovery processes Planning long range needs for SQL database administration Provide guidance and reference to Tier 1 and Tier 2 Service Desk resources, as well as Tier 3 team members Working knowledge of Big Data (Hadoop), PowerShell scripting is an asset Working knowledge of Oracle, Informatica, and SAS is an asset Creates physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recoverySQL Database Administrator – Mandatory Skills Experience with one or more operating systems Experience with working on Azure technology Experience with one or more database technologies Experience in one or more programming languages Experience in the use of information retrieval packages and proficiency with query languages Experience in monitoring and enforcing database rules Experience in Incident, Change and Configuration Management procedures Experience with one or more communications protocols Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills A team player with a track record for meeting deadlinesSQL Database Administrator – Nice to Have Skills Experience with distributed data systems Experience with middleware and gateways Experience with researching and implementing cyber security vulnerability remediations Awareness of emerging IT trends and directions Experience with Computer Aided Software Engineering (CASE) tools Knowledge and understanding of Information Management principles, concepts, policies and practices Experience in Database Administration, Maintenance Optimization Additional Responsibilities/Skills for Data Warehouse including Oracle OBIEESQL Database Administrator - Assignment Start DateASAP – 12 months to startSQL Database Administrator - Assignment LocationMississauga, ON – Work Remotely

calendar_today6 days ago

report

info Contract

location_on Toronto, Canada

work Procom

Apply:
I expressly authorise the Terms and Conditions

Similar jobs