Senior SQL DBA Professional

Intelex Technologies Ulc

3 - 8 years

4 - 8 Lacs

bengaluru

Posted:3 weeks ago| Platform:

Apply

Skills Required

sql development github sql sentry cosmos analysis t-sql database administration redgate sql server stored procedures sql database design system written communication xml powershell ssrs data acquisition ssis mongodb communication skills jira

Work Mode

Work from Office

Job Type

Full Time

Job Description

Administer database systems across Production, Staging, QA, and Development environments
Recognize system deficiencies, diagnose performance issues, and implement effective solutions
SQL Server replication and cluster construction
Plan and implement disaster recovery
Database sharding and tuning
Monitor and report on database availability and performance
Optimize stored procedures, triggers, and functions
Optimize database schemas, views, and indexes
Data Warehousing, archival, and backup
Database change deployment process
Database maintenance and on call rotations
Generate code to extract, transform, and load data from/to production data sources from/to external sources (excel, text comma and tab delimited files, other Access, SQL databases, XML, etc)
Write code and create jobs to automate repetitive tasks
Work alone and in a group
Research problems independently
Establish and enforce coding standards
Implement, maintain, and audit database security and encryption
Plan growth and changes (capacity planning)
Resource governing
Experience, Skills & Education
3 years plus of experience as DBA expected
Light database administration expertise is acceptable given strong SQL development skills
Proficiency writing and optimizing Transact SQL, stored procedures, functions, performing bulk set operations (select/insert/update/delete) in MS SQL 2008 and newer
Detailed knowledge of relational database concepts
Recent experience with SQL Server 2008 (2019/2022 a plus)
Building and administering MS SQL Server Database Systems a major plus
Knowledge of SQL Server replication and clusters in Cloud environments a major plus
Knowledge of principles of database design, data acquisition, and data access analysis and design
Experience with SSIS and SSRS a plus
Strong verbal and written communication skills
Demonstrate ability to work in a small group setting to rapidly develop new and enhance existing systems
A BS degree in business or computer science, comparable work experience accepted
Additional experience welcomed:
Experience with JIRA;
Experience with Github, Teamcit
Experience with MongoDB,Cosmos DB
Experience with Redgate DLM, SQL Sentry, Powershell

More Jobs at Intelex Technologies Ulc

Software Engineering P16

Bengaluru

1 - 3 yrs

INR 3 - 5 Lacs

Industry Data Research & Validation P17

Bengaluru

1 - 4 yrs

INR 6 - 10 Lacs

Staff Mechanical Engineer

Bengaluru

8 - 13 yrs

INR 4 - 7 Lacs

Lead Embedded Software Engineer

Bengaluru

10 - 15 yrs

INR 11 - 15 Lacs

Staff Embedded Software Engineer

Bengaluru

8.0 - 13.0 yrs

INR 25 - 30 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.