03/12 Manisha Manaswini
Recruitment Team at Mu Sigma

Views:312 Applications:63 Rec. Actions:Recruiter Actions:1

Mu Sigma - SQL Server DB Developer (3-7 yrs) Premium

Bangalore Job Code: 386825

Description/Job Duties :

- Design, develop and implement database systems based on customer requirements.

- Optimize database systems for performance efficiency.

- Prepare design specifications and functional documentations for assigned database projects

- Perform space management and capacity planning for database systems

- Develop database tables and dictionaries

- Ensure data quality and integrity in databases

- Identify any issues related to database performance and provide corrective measures

- Create complex functions, scripts, stored procedures and triggers to support application development.

- Participate in database design and architecture to support application development projects

- Perform data back-up and archival on regular basis

- Test databases and perform bug fixes

- Troubleshoot database related issues in a timely fashion

- Develop security procedures to protect databases from unauthorized usage

- Evaluate existing database and recommend improvements for performance efficiency

- Develop best practices for database design and development activities.

- Secures databases by developing system access, monitoring, control, and evaluation; establishing and testing disaster recovery policies and procedures; completing back-ups; maintaining documentation

Required Qualifications/Experience

- Experience at Configuring, Maintaining and Troubleshooting :

1. SQL Server 2008/2012/2016

2. Create and deploy Cubes (Tabular & Multi-dimensional)

3. Azure SQL

- 5 or more years of extensive development experience with RDBMS

- Experience Azure Cloud Services and Big Data technologies

- Comprehensive SDLC experience (requirements, architecture, design, testing and deployment), Emphasis on Agile - a Plus

- Extensive experience with T-SQL and knowledge of stored procedures, triggers and functions in SQL

- In depth knowledge of Indexing concepts

- Good exposure to query tuning and optimization

- Analysis of execution plan and recommend development team about best practices

- Degree/Diploma in Computer Science, Software Engineering, Information Technology or related discipline

- Experience in application deployments and release management

- Experience with OO design and design patterns

- Experience with debugging server applications is an added advantage

- Experience with Scrum or Agile methodologies a plus

- Experience with LDAP, Redis, MS SQL Server (a must), MySQL, PostgreSQL (a must), Sqlite

- Good verbal, written communication and analytical skills

- Ability to work well in team environment

- Ability to multitask and juggle multiple critical issues

- Ability to quickly adapt to change

- Technical certifications in areas of expertise/ Certificates of training in associated fields/equipment a plus

- Project Management experience

Additional requirements which will be good from a solution architect point of view (optional)..

- Exposure to SSIS or any other ETL tool is a plus

- Architecture for Big data solutions (CI pipeline, Hadoop, Spark, etc.)

- Architecture and Design of Enterprise level advanced analytics applications with focus on SOA(Service-Oriented-Architecture)

- Big Data Application development (recommendation engines, Data ingestion)

- Platform and Infrastructure (AWS, Azure and Google Cloud Platform)

1. Data lake store

2. Data lake analytics

3. Data factory (Copy pipelines, transformation pipelines)

4. SQLDB

5. Tableau

6. Integration Runtime

- Languages: Python, R, Javascript, HTML, CSS, Shell

- Technologies: Docker, ElasticSearch, Prometheus, Cassandra, PostgreSQL, Django, Jenkins, NodeJS, Airflow, Apache Nifi, Kong(API gateway)

Add a note
Something suspicious? Report this job posting.