Database Administrator - Bengaluru, India - 3 Dots Consultants
1 week ago
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).
- 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
Job Types:
Full-time, Regular / Permanent
Salary:
₹700, ₹1,200,000.00 per year
Schedule:
- Morning shift
Ability to commute/relocate:
- Bangalore, Karnataka: Reliably commute or planning to relocate before starting work (required)
Application Question(s):
- How many years of experience do you have as Database Administrator?
- How many years of experience do you have in SQL?
- How many years of experience do you have in SSIS?
- Notice Period in Days?
Experience:
- total work: 2 years (preferred)
Speak with the employer
More jobs from 3 Dots Consultants
-
Database Administrator
Bengaluru, India - 1 week ago
-
Inbound Telecaller Sales Exceutive
Remote, India - 4 days ago
-
Mis Executive
Mumbai, India - 5 days ago
-
Graphic Designer
Chennai, India - 5 days ago
-
Tableau Administrator
Bengaluru, India - 4 days ago
-
Automation Tester
Bengaluru, India - 1 week ago