MS SQL Database Analyst (DBA)
On behalf of our client in the Consulting Sector, PROCOM is looking for a MS SQL Database Analyst (DBA)
MS SQL Database Analyst (DBA) - Job Description
Role : Configuration planning & deploying MSSQL servers on public cloud and on-premise servers.
Project : Reporting to the DBA Manager / Lead, the Database Administrator would be supporting the MS SQL Server on-premises as well as on public cloud.
As a member of the database administration group, you will assist in the team effort to maximize the availability, security, and performance of the databases.
The Database Administrator must be prepared to provide remote dial-in support, or occasionally on-site support in response to routine monitoring alerts and scheduled & unscheduled maintenance tasks occurring after hours and on weekends.
Typical Day in Role :
- Configuration planning & deploying MSSQL servers on public cloud and on-premise servers.
- Performance tunning, capacity planning and monitoring.
- Database maintenance / housekeeping including database rebuilds / re-indexing / expansion and archiving
- Trouble-shoot MSSQL server problems and assist in the resolution of application problems.
- MSSQL Server Software currency resolution including Patching / Upgrades / Migrations.
- Assist in database code promotions & data fixes following internal change control process.
- Disaster Recovery / High Availability (DR / HA) support with backup, recovery and failover / failback of local and remote replicated databases.
- Provide DBA support to development / implementation projects as assigned, doing
- Installations, database loading, migrations, testing, and go live support etc.
- Follow Database best practices, security and change control process of the bank.
MS SQL Database Analyst (DBA)- Mandatory Skills
- 8-10+ years of progressive technical working experience as a Database Administrator.
- 5+ years of experience working with MSSQL Server 2022 / 2019 / 2017 and prior versions DB Administration
- GCP Cloud SQL(MSSQL) and Azure MI / DBaaS / IaaS database administration
- AD, Firewall IP / Port, domain trust / authentication methods related to MSSQL / Windows database connectivity
- Logical & Physical Backup / Recovery / Compression techniques
- MSSQL Services (SSRS / SSAS / SSIS / PolyBase, R Service, Power BI etc.)
MS SQL Database Analyst (DBA)- Preferred Skills
- Microsoft and / or Google Data Platform certification
- Windows Servers 2019 / 2016 and prior versions.
- Application side tuning vs. server-side tuning.
- Setup MSSQL Always-On, Availability groups & Database Replication
MS SQL Database Analyst (DBA)- Assignment Start Date
ASAP 4 months to start (possible extension)
MS SQL Database Analyst (DBA) - Assignment Location
Toronto, ON Hybrid
MS SQL Database Analyst (DBA)
MS SQL Database Analyst (DBA)- Mandatory Skills. GCP Cloud SQL(MSSQL) and Azure MI/DBaaS/IaaS database administration. MS SQL Database Analyst (DBA)- Preferred Skills. MS SQL Database Analyst (DBA)- Assignment Start Date. ...
database analyst (DBA)
Test data models and database management systems. Operate database management systems to analyze data. Develop and maintain computer databases. Document reporting needs, queries, logic, results and recommendations to other information systems professionals. ...
database analyst (DBA)
Test data models and database management systems. Operate database management systems to analyze data. Develop and implement a strategic blueprint to follow when deploying databases within their organization. Develop and maintain computer databases. ...
SLFJP00005011 – Database Analyst/DBA – Senior
...
Int Database Analyst - to build/modify SQL/SAS Queries for a regulatory project at our large financial client - 52267
Int Database Analyst - to build/modify SQL/SAS Queries for a regulatory project at our large financial client -. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Interview Process: 1 round, potentially 2 (Webex or Teams) Work Loc...
database analyst (DBA)
Test data models and database management systems. Operate database management systems to analyze data. Develop and implement a strategic blueprint to follow when deploying databases within their organization. Develop and maintain computer databases. ...
Azure Data Engineer
Azure Data Factory , Azure Data bricks Spark (PySpark or scala), SQL. Any other certificate in Azure/AWS/GCP and data engineering hands-on experience in cloud. We leverage our holistic portfolio of capabilities in consulting, design, engineering, operations, and emerging technologies to help clients...
Database Analyst III
Database Analyst III // Hybrid // Toronto // 3 Months contract // Banking client. Review, evaluates, designs, implements, and maintains company database(s). Writes codes for database access, modifications, and constructions including stored procedures. ...
Data Analyst
As a Data Analyst, you are a sucker for data. In fact, you can’t get enough! The Data Analyst is engaged throughout the lifecycle of a campaign. Supporting the Senior Analyst, primary responsibilities include data analysis, development of digital reports, troubleshooting and testing tracking and pla...
Senior Data Architect
DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our client an Enterprise Fleet Management company. Provide technical leadership for architecture, design, documentation, and maintenance...