Database Administrator - Bengaluru, India - 3 Dots Consultants

3 Dots Consultants

Verified Company

Bengaluru, India

1 week ago

Posted by:

Deepika Kaur

beBee Recuiter

Description

Qualification:
Bachelor's degree in computer science or related field or completion of a technical training program in software development programming language and 2+ years business experience

Required Skill:

Technologies required: SSIS, MS SQL Server 200
Design, create, and implement database systems based on the end user's requirements using SQL SSIS management studio.
Strong skills designing, developing and maintaining stored procedures, views, tables, T-SQL scripts, creating associated documentation
Perform data conversion and Server Migrations
High level of OLTP an OLAP/DSS database administration expertise
SSIS Advanced component experience is a good to have (transformation objects in data flow).

Job Description / Responsibilities

Provide administration of database systems including installation, upgrades, configuration, consolidation, monitoring, tuning, and maintenance
Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL process, documentation, and longterm preparedness.
Develop cross validation rules to ensure mapping accuracy.
Provide production support of existing ETL processes.
Document steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production.
Implement database backup, disaster recovery and highavailability solutions
Maintain reporting and data integration processes using SSRS and SSIS
Develop custom database objects (T-SQL scripts, stored procedures, tables, views, functions
Analyze relational and storage engine issues and provide appropriate solution
Implement monitoring solutions for analytical environment
Fix any issues related to database performance and provide corrective measures. Test databases and perform bug fixes.
Use Excel to cleanse data
Use SSIS to push data to DB. Use Transaction language to query DB and update data as required.
Resolution of queries through interaction with onsite team
Ownership of processes and client deliverables
Regular communication with client stakeholders to ensure smooth operations