Database Job Profiles - Video 1 | Databases | Data Science | Techie Vineet
Database Job Profiles Discussion - Video 1 | Databases | Data Science | Techie Vineet
In this video, we have discussed the following sample job profiles and the requirements listed for each job profiles:
Senior Database Developer
-------------------------------------------------------
Experience in Database Development and Programming of Databases.
Azure SQL Database
Microsoft Fabric,
Azure SQL DB,
Azure Cosmos DB,
Azure PostgreSQL,
Azure Data Factory,
Azure Synapse Analytics,
Azure Service Bus,
Azure Event Grid,
and Power BI.
PostGreSQL
Storage Engine and High Avaialbility
MongoDB (non-relational database)
Software Development Experience using C, C++, Rust or an equivalent programming language
SQL Server Architect
--------------------------------------
Design end-end to Solution and Data Architecture for enterprise data platforms that includes
Data Lakes,
Data Warehouses, etc.
leveraging SQl Server Design Data Model, Data Mappings that involves data transformation
Migration Experience from Oracle to SQL Server 2022
Build Database, Model the database and Optimize the database for performance tuning
Extensive experience with ETL tools like IBM Datatstage and building data ingestion pipelines.
Experience in large scale data integration projects involving multiple data sources and loading them in multitenant architecture.
Hands-on experience with complex data warehouse solutions on any databases like SQL Server platforms , DB2, Teradata,Oracle.
Strong understanding of SQL & Databases Experience and expertise on Design Document build and Architecture diagram build
Development of scripts using Procedure, Unix, . for loading, extracting, and transforming data
Analyze & translate functional specifications & change requests into technical specifications.
Senior Sql Database Administrator
----------------------------------------------------------------
The Database Administrator is responsible for supporting operational management of databases services which includes maintaining and managing our entire database environment including production, test and development database servers across the organization located in the different geography.
This includes supporting databases for third-party applications, and our in-house applications for routine maintenance, server administration and management, and addressing ad hoc requests.
Strong knowledge and experience with Microsoft SQL Server 2016 or higher version.
Good understanding of SQL Server Architecture, backups, indexes, jobs, Transaction Logs etc.
Hands-on experience in managing database backups, performing recovery/restore etc.
Hands-on experience with SQL Server installation, security configuration, applying service packs and patches.
Very good understanding and hands-on experience of building Microsoft failover clustering services and AlwaysOn infrastructure.
Microsoft Azure SQL and other components of Azure
Database Encryption
Database growth vs disk space available, audits, resource monitoring (I/O bottlenecks, memory pressure, CPU use)
Strong ability to write/develop SQL scripts for various database management activities and ad-hoc projects.
Hands-on experience with developing PowerShell scripts for various database administration activities
Good understanding of SQL Server security architecture.
Experience with DBCC commands for routine maintenance activities and writing scripts for database administration.
Good understanding of database monitoring tools, responding alerts as well as follow-up actions on alerts
Experience with other RDBMS product like Oracle and MySQL is a plus.
Experience with DevOps is a plus
Experience with any NoSQL product (MongoDB) is preferred.
Perform install, apply patches, build SQL cluster under the supervision of Database Manager/Architect.
Perform routine database administration activities like index management, transaction log management, update statistics, check database integrity etc.
Write and modify database code (T-SQL, stored procedure, views, triggers, user-defined functions) for our in-house applications as and when required.
Develop reports and/or write complex T-SQL queries for reports as and when required.
My Channel Page : / @masterdatasciencewithvineet
SQL Server Database Design Playlist : • SQL Server - Database Design Video Li...
Business Continuity Playlist : • SQL Server - Business Continuity
SQL Server Indexing Playlist : • SQL Server - Indexes
SQL Server Performance Tuning Playlist : • SQL Server - Performance Tuning
SQL Server Integration Services Playlist : • SQL Server Integration Services
SQL Server Tables Playlist : • SQL Server - Tables
