DBA

5+ Yrs in SSIS, SQL
Bangalore
Immediate

• Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics
• Understand platform’s data model (table structures, linkages, optimal designs) for designing various planning use cases
• Review and analyse the data provided by customers along with its technical/functional intent and interdependencies
• Participate in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data
• Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery
• Create and execute test plans,document issues and track progress at resolving issues.

Primary Responsibilities:

• We need strong SQL database development skills using the MS SQL server.
• Strong skill in SQL server integration services (SSIS) for ETL development.
• Strong Experience in full life cycle database development project using SQL server.
• Experience in designing and implementing complex logical and physical data models.
• Exposure to web services & web technologies (Javascript, Jquery, CSS, HTML).
• Knowledge of other high-level languages (PERL, Python) will be an added advantage
• Nice to have SQL certification.

Good to have:

•             Bachelor’s degree or a minimum of 3+ years of formal industry/professional experience in software development – Healthcare background preferred.

We are looking for Young, Energetic and Experienced Professionals who can join our Team as Senior Database Developer.
• Experience in Database Development and Support in MS SQL Server environments.
• Hands-on End to End Database Development encompassing Database Design and Development
working with cross-functional teams.
• Hands-on experience of Transact SQL(T-SQL) utilizing SQL Server 2016 and above.
• Excellent understanding of T-SQL programming
• Hands-on experience in SQL - writing hands on experience in complex stored procedure, function,
triggers
• Sound knowledge of SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
• Develop, implement and optimize stored procedures and functions using T-SQL
Review and interpret ongoing business report requirements
• Analyze existing SQL queries for performance improvements.
• Develop procedures and scripts for data migration Provide timely scheduled manage

Requirements:

• Retrieve Data from Databases

SSRS developers optimize SQL server queries to retrieve data efficiently and quickly. As

teams submit requests for different ways of doing things, SSRS developers work with them to find solutions that meet their needs.

• Design Data Solutions

To create and design best-practice data warehouse solutions that support business reporting tasks. This is achieved using different programs and software, such as Microsoft Excel, MS SQL Server, and Tableau.

• Create and Maintain Reporting Processes

To maintain a record of the different reporting processes in place. Evolve ways & means for a more effective data management.

• Resolve IT and Data Issues
• Provide Delivery Plans and Estimates for Projects

Job description:

As a Database developer, you will be responsible for designing, creating database, stored procedure, functions, ETL etc.
and upgrade of database that are leading the way in assuring high quality of data visualization and products. You will be
challenged with systematic database development methodologies in concurrent computing software architecture
environment. The engineer will have the opportunity to work with software developers and the site support engineer ona regular basis.

Job responsibilities:

• Development of high-quality database solutions.
• Develop, implement and optimize stored procedures and functions using T-SQL.
• Review and interpret ongoing business report requirements.
• Research required data.
• Build appropriate and useful reporting deliverables.
• Analyze existing SQL queries for performance improvements.
• Suggest new queries.
• Develop procedures and scripts for data migration.
• Provide timely scheduled management reporting.
• Investigate exceptions about asset movements.

Job requirements:

• Should understand operating system, relational database, concurrent computing, and client/server architecture
and mobile environment.
• Should have excellent problem solving and trouble shooting skills
• Should have ability to excel in cross functional team environment
• Should have experience in Cross-Platforms (Unix/Windows) application testing environment
• Should have excellent written and verbal communication skills in English
• Should have attention to detail, positive attitude under stress
• Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the
target systems. Expert level knowledge of T-SQL, Stored Procedures, Data Modeling, Views, and Functions.
• Maintain source code for database
• Efficient in writing optimized SQL queries.
• Develop SQL scripts, table, views, indexes, and complex queries.
• Design & maintain the existing databases and ensure their stability, reliability, security and performance.
• Coordinate with software developers, review (and modify the queries if required) and approve the SQL queries
written by them for the production deployment.
• Strong knowledge in Database design, develop, test, implement, fine-tune, enhance and maintain new and existing databases.

Professional qualifications:

• 4 – 6 years of relevant experience
• Bachelor's degree in Computer Science, Engineering or a related subject.
• Excellent understanding of Microsoft SQL Server.
• 3-4 years of experience with SQL Server Reporting Services and SQL Server Analysis Services.
• Familiarity with the practical application of NoSQL\NewSQL databases.
• Sense of ownership and pride in your performance and its impact on company’s success.
• Critical thinker and problem-solving skills.
• Team player.
• Good time-management skills.
• Great interpersonal and communication skills

About Increasingly:Increasingly is an award-winning, fast-growing retail technology company focused specifically on the automation of cross-selling for online retailers. Our clients include large global corporations like Samsung & Canon to several small to medium size retailers across the globe. Our AI-based algorithms help a customer buying a TV on Samsung to find the matching soundbar & purchase both together. Increasingly is headquartered in London with offices in Lisbon & Bangalore. We work with clients in over 30 countries & 20 languages.We are looking to rapidly expand our technology & product development operations in India. And we need smart, ambitious people like you who enjoy a fun yet challenging work environment. We believe strongly that diversity & inclusion are the foundations for a lasting, incredible culture. We also believe that it's important to get the balance right between work & life.The job and its impact:- Be solely responsible for designing databases and ensuring their stability, reliability, and performance. Ensure that the database system is efficient and error-free. - Optimize your queries when a website is too slow due to database performance, write queries for heavy traffic databases, and design tables and indexes for the best database architecture and performance.- Lead a team of developers and successfully solve issues and make improvements to databases, while ensuring all work meets the necessary requirements.- Learn new technology. There's a ton of stuff in there that falls outside the classical SQL model, and learning how to use it will improve your craft.- Find a problem to solve and don- t be afraid to fail. Learn by making mistakes.- Be fluent in the current technology and able to learn how to correctly utilize new technology, often on the fly. As a result, you are must be the most versatile member of any team.- Everything changes so fast the fundamentals you learned five or 5 years ago may no longer be applicable. Architect skills. Developers must be architects these days. Understand the big picture of mapping. Try to find the next set of standards.What essential skills you need:- Schema design, data modeling, data upgrades, develop distributed and highly scalable applications with a focus on scalability performance availability reliability security and maintainability of the applications or technologies.- Code review, SQL query tuning, SQL patches, ownership, attention to detail ad-hoc queries & automation in support of internal and external customers data exchange and integration needs.- Research, troubleshoot, and resolve data issues impacting extract delivery, application design enhancements, development, debugging, and optimization with respect to data concerns and new product features.- Cloud-managed database engines such as Amazon RDS. NoSQL solutions such as Redis, Cassandra, MongoDB, make regular recommendations for system improvements.- Extensive experience with backups monitoring performance tuning and troubleshooting tools & techniques. Ability to identify bad SQL statements & optimize them.- Support QA & development team in project queries, test plans and test cases to improve the database with an ability to communicate effectively within a team.- Self-starter collects data, analyzes the collected information, designs algorithms, draws flowcharts and then implements code for the logic developed through algorithms and flowcharts.What are the benefits:- You'll get to work in one of the hottest & fastest growing retail technologies in Europe right now. - You'll get paid a competitive salary & be working directly with a super experienced team of people. - You'll get a great place to come to work every day. Varied, complex, challenging & with a great culture that you can shape & change.

We are looking for a Senior Software Engineer to implement functional software solutions. The goal will be to develop high-quality software/s that is aligned with user needs and business goals.Roles & Responsibilities :- Will own a complete platform from initial architecture, design of components, quality and deployment planning- Will act as an evangelist for the product platform. Identify right technologies for the business use cases. Will be involved in creation of user manuals, internal documents and customer API documentations.- Will understand requirements by studying information needs, discussing with the stakeholders, understanding workflow processes, data flows. Create design and architecture documents to explain, justify and evaluate design approaches.- Should be strong in design principles and have implemented them in existing projects.- Involved in troubleshooting existing applications in production. Identify and build tools for troubleshooting.- Will be involved in creating flowcharts and data flow diagrams. Will be involved in code review for peers. Should be able to identify and implement best practises.- Should be an advocate of automating daily tasks. Should have a high inclination towards building self managed systems.- Should be aware of the latest technology trends. Should participate in professional publications, conferences and events.- Will be involved in mentoring junior team members and aligning them towards company goals.- Identify and implement metrics for measuring platform stability and end user feedback.Requirements :- BS/MS degree in Computer Science/Information Science, Engineering or related field from reputed institute.- Experience of 4-7 Yrs- He/She has built distributed systems. Has the capacity to identify a problem and provide a solution- Has experience with scalable applications. Should identify probable bottlenecks and come up with approaches to mitigate them.- Has experience in working in cloud infrastructure. Should have exhibited capability in identifying and working with IaaS and PaaS providers.- Has a good understanding of OOPs and Functional programming concepts.- Has hands on working experience in one or more of the technologies like PHP (laravel, YII, Code Ignitor ), NodeJs (hapi.js express.js, socket.io), Golang, Java.- Have a working knowledge of web technologies like HTML, CSS and Javascript.- Has experience in identifying database solutions for a given problem. Should have experience working with one of RDBMS and NoSQL databases.- Has a good knowledge about API fundamentals.- Should have worked with third party APIs integrations.- Good written and verbal communication skills.- Should be a highly motivated and a quick learner.

We conceptualize, architect, build and run scalable and complex, modern day full stack technology platforms

NAV Consulting, Inc. is an independent global Fund Administrator for over 20 years which provides complete fund administration for hedge fund industry with reporting, investor services and back office support. NAV serves over 750 clients around the world, which have combined assets under administration over US$ 54 billion. NAV has been ranked as one of the 15 largest Fund Administrators globally. For the year 2014, NAV Consulting has been awarded as “Hedge Fund Administration Service Provider of the Year – USA”