03/12 Seema Tabassum
HR at Mu Sigma

Views:715 Applications:97 Rec. Actions:Recruiter Actions:1

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

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)


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)

This job opening was posted long time back. It may not be active. Nor was it removed by the recruiter. Please use your discretion.

Women-friendly workplace:

Maternity and Paternity Benefits

Add a note
Something suspicious? Report this job posting.