Database Administrator at Ascentech Services Limited

Responsibilities

• Work with the Enterprise IT Unit to design and develop capacity planning of the database infrastructure.
• Application (Designing schema, access patterns, locking strategy, SQL development, and tuning, Modifying the database structure, Optimizing application and end-user queries (reactive tuning), Archiving Data, Generating needed ad hoc reports by querying from the database, Proactive performance tuning)
• Access (Enrolling users and maintaining system security, Controlling user access to the database)
• Database (Parameter configuration and tuning, Cache management, Job scheduling)
• Monitor, maintain database systems, and resolve problems that may arise.
• Maintain data integrity and security (manage roles and permissions of database users).
• Use industry-standard tools for database tuning.
• Generate traces, execution plans, identify performance issues,deadlocks/contention, and resolve them.
• Create and manage constraints and indexes.
• Automation of tasks, installations, updates, maintenance task configuration, etc.
• Database unit testing frameworks like TSQLT
• Familiar with Git, Talend, ReDSHIFT, PowerBI, and other data tools
• Proactive housekeeping/archiving and shrinking of databases.
• Manage production, QA, and development database environments for all company solutions.
• Create detailed documentation including diagrams of database infrastructure.
• Learn relevant business processes and understand the data flow, criticality and dependencies.
• Effectively coordinate and communicate with all the stakeholders(internal teams and clients).

Requirements

• Candidates should possess a Bachelor's Degree
• The ideal candidate is required to have about 3 years of experience.

Core Skills:

• In-depth understanding of AWS and other cloud services
• Experience with cloud data security solutions
• Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
• Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Experienced in ETL (Extract-Transform-Load) development / data integration.
• Sound knowledge of RDBMS concepts, database architecture, and SQL/T-SQL.
• Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
• Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster, and various replication technologies would be an advantage.
• Knowledge of other databases like MySQL, No SQL databases, and In-memory databases and MCTIP certification will be an advantage.
• Ability to develop procedure documents and maintain detailed database-related documents.
• Working knowledge and experience with graph databases
• Good communication skills.