Office Location: Goregaon Mumbai
Position description: 2+ years of experience in database development.
Primary Responsibilities:
- Understand requirements from front end applications developers
- Write advanced queries, stored procedures, cursors, functions & triggers
- Conduct code reviews
- Work with high-traffic application servers
Required Skills:
Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented.
Functional: MSSQL Development - TSQL, Stored Procedures, & Triggers, Advance Queries, Optimization, Indexes, Joins, Database Design, JIRA.
About A sports-focused digital media agency
Similar jobs
- Structured Query Language (SQL), e.g. SQL/PSM, Transact-SQL queries, writes SQL scripts in SQL Server 2000/2005/ 2012/ 2016, etc.
- 1+ years in Cloud Database services like AWS Dynamo DB / RDS
- Excellent Troubleshooting skills of existing functional implementation to derive leaner solutions and effective performance between applications software, systems software, and installed hardware.
- Database instance maintenance tasks such as DB Integrity Checks, Index Maintenance.
- High availability like clustering, log shipping, mirroring, replication.
- Backup and disaster recovery, Capacity planning and performance monitoring, Physical database structure, RDMS administration roles, instances, profiles, and security connectivity.
- Developing, implementing, maintaining, and following change control and testing processes for modifications to databases.
- Establishing backup and recovery or replication plans to minimize data loss and system downtime.
- Improving data quality through data analysis, monitoring, gap analyses, and working with the teams to provide solutions and resolve errors.
- Maintaining data integrity and security (manage roles and permissions of database users).
- Reviewing the security logs from the SQL Server Error Logs to determine if you had a breach or a violation in one of your policies.
- Ensures optimal database performance and availability.
· Creation & maintenance of Databases in AWS.
• 2 years of hands-on experience in Salesforce Sales Cloud, Service Cloud & Lightning
• Proven experience of Quality Assurance Testing for Salesforce core and system
integration
• Strong experience and knowledge of Salesforce configuration and standard Salesforce
functionalities
• Hands on knowledge of JIRA is must. Knowledge of testing tool like TestRail, Zephyr is
a plus
• Current knowledge of testing solutions using Lightning and LWC
• Basic idea about Apex, VF and Java script would be an added advantage
• Strong problem-solving skills and communication skills
• Ability to explore new tools, techniques, and approaches to enhance quality
assurance
• Salesforce Admin Certification, Salesforce App Builder Certification, ISTBQ Foundation
Certification, OR equivalent
• Engineering graduate/ MCA / MBA or equivalent
Must have Expert level (5-7 years of development and maintenance experience) in MS SQL Server
· Excellent skills in writing Stored Procedures, functions, triggers, queries, scripts, etc.
· Excellent in troubleshooting, performance tuning, debugging, and query optimization
· Excellent in indexing, finding and resolving potential for database deadlocks
· Strong in database migrations and upgrades.
· Has experience with analytics and reporting.
· 3+ years of experience with SSIS, SSRS.
· Has experience with Access DB.
· Have a MS SQL Server certification OR are willing to obtain in a short time frame.
- 4+ yrs of experience having strong fundamentals on Windchill Customization & Configurations, Reporting Framework Customization, Workflow Customization , Customer handling
- Strong Customization background around Form Processors, Validator, data utilities, Form Controllers etc.
- Strong Programming skills in Java/J2EE technologies – JavaScript, GWT, JQuerry, XMLs, JSPs, SQL etc.
- Deep Knowledge in Windchill architecture
- Experience in atleast one full lifecycle PLM implementation with Windchill.
- Should have strong coding skills in Windchill development and Customization, ThingWorx Navigate Development (Mandatory), Thing Worx Architecture Configurations Mashup creation, ThingWorx and Windchill Upgrade
- Should have Build and Configuration management (Mandatory) - HPQC \JIRA\Azure\SVN\GITHUB \ Ant
- Knowledge & Experience in Build and Release process
- Having worked on custom upgrade will be a plus.
- Understanding of application s development environment, Database, data management and infrastructure capabilities and constraints. Understanding of Database administration, Database design and performance Tuning
- Follow Quality processes for tasks with appropriate reviews. Participate in sharing knowledge within the team.
o Expertise in Software configuration management (SCM) using multi-site Rational ClearCase, ClearQuest ,Git, Gerrit, JIRA and CVS |
o Experience of working with continuous integration frameworks (like Hudson, Jenkins) and debugging |
o Expertise in build and release process and automation, build infrastructure setup |
o Build environment and build scripts (cmake / make, GNU Make) in-depth expertise and knowledge |
o Expertise and in-depth knowledge in scripting (Shell / Perl) is a must |
o Experience of working in UNIX-like environments (Linux/Solaris) and usage of operating system tools |
o Expertise in performing integration builds and release management |
o Experience of managing software licenses for different build tools |
o Exposure to Android , Open source development and code analysing tools like Blackduck and Coverity are added advantages |
- Suggest programmatic strategy and tactics that coordinate with and augment the overall media plan objectives for DB2B clients
- Create and actively manage and optimize programmatic campaigns in DSPs
- Be consistently curious and inquisitive – learn how platforms work, and more importantly, learn how to game them
- Manage campaigns across programmatic mobile, display, video, OTT, CTV, and audio
- Understand how data from various channels can help the overall customer journey for each client account
- Identify, suggest, and setup private marketplace deals
- Continually acquire knowledge by maintaining relationships with key programmatic vendors portfolio
- Actively monitor campaign KPIs via reporting
- Produce and present engaging campaign analysis to clients, demonstrating the effectiveness of planning, testing, and media optimization and management
- Provide insight and guidance to members of the integrated media team
- Maintain and stay current on industry news and research
Qualifications
- Hands-on experience with one or more of the following DSPs: Google DoubleClick Bid Manager(DV360), TheTradeDesk, DataXu, Amazon Advertising Platform, Adobe/TubeMogul, and Sizmek
- DoubleClick Campaign Manager/DoubleClick Bid Manager certifications are preferred but not required
- Strong written and verbal communication skills
- Detail-oriented and organized
- Able to multitask and work well under pressure
- Positive team player
- Proficiency in Microsoft Office applications
- Bachelor of Arts or Bachelor of Science degree
Primary Skills
● Exceptional problem solving skills
● Significant coding experience in C#
● Strong knowledge Unity Game Engine
● Good understanding of unity art pipeline specially 2D.
● Good experience in developing multi platform user interfaces.
● Strong Debugging and Optimization skills.
● Experience in integrating REST API
● Strong knowledge of Object Oriented Programming and Design Patterns.
● Strong understanding of Data Structures and algorithms.
● Good written and oral communication skills. Secondary Skills
● Good knowledge of 2D/3D maths, Linear Algebra , Matrices etc.
● Experience in using JIRA and Confluence etc
● Experience in using SVN, GIT etc.
Experienced in mobile development for iOS and Android
Experienced with mobile build systems (xcodebuild, gradle, etc.).
Job Description:
● At least 4 to 8 years of experience in software quality assurance manual testing
● Proven record of test strategy and planning, STLC, deployment, defect tracking, and test harness.
● High degree of initiative with a passion for learning technology.
● Must have strong hands-on experience on any programming language PHP, React Native JavaScript, HTML, CSS.
● Must be competent enough on API testing using Rest Assured and Postman.
● Performance testing experience with relevant automation and monitoring tools (e.g., JMeter, load runner).
● Responsible for coming up with and executing scale tests, performance, and longevity tests.
● Must have testing experience on cloud-based platforms and working knowledge on integration testing using CI/CD pipelines.
● Should have working experience with at least one of the MYSQL databases and NoSQL DB viz.
● Cosmos Db, Cassandra, MongoDB.
● Should have strong fundamental understanding of network topology and the TCP/IP stack and working knowledge of load balancing methods and deployment architecture
● Experience with GIT Hub, Maven, HP ALM, Jira, Jenkins, code coverage tools and CI/CD
● Exposure of sizing (estimating) the project and defining timelines
● Good to have knowledge of Platforms like Windows / UNIX / Mainframe.
● Work under the direction of the Game QA Lead to provide test support for two dozen experienced game designers, artists, and engineers.
● Perform daily smoke tests of game builds, using the build computer and the install scripts.
● Run through and write test plans for existing and new features. Become familiar with the project design by closely reading project documentation and reaching out regularly to our team of game developers.
● Verify that identified bugs are fixed in the database.
● Identify and bug new issues that occur in the HMD and tablet interface.
● Build on your own fundamental QA skills by learning the specifics of game development QA for mobile devices, VR headsets, and experimental technology.
● Engage in continuous improvement of the QA process.
● Maintains quality service by establishing and enforcing organization standards.
● Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of the-art practices; participating in professional societies.
● Contributes to team effort by accomplishing related results as needed
- Should have strong knowledge and hands-on with SQL, Java Selenium, and TestNG
- Good knowledge of the j-meter tool
- Hands-on with any of the defect management tools like Jira/Bugzilla
- Knowledge of Protractor, JavaScript, Soap UI is a plus
- Exposure to the usage of Testing Tools
- Hands-on JS/Scripting
- Knowledgeable in REST, XML/JSON, SOAP
- SQL Writing (Oracle DB)
Years of experience:
- 2+ years of actual QA experience comprising of both manual testing and creating automation frameworks.
Detailed Job Description:
- Experience in testing web-based applications.
- Experience in developing test cases and scenarios based on PRD/BRD/Use cases.
- Experience in testing Web Services
- Logging defects/bugs in the defect management tool
- Tracking the defects and retire them with appropriate test execution
- Good analytical and problem-solving skills
- Excellent written and verbal communication skills
To know more about us, please visit http://www.centiro.com/">www.centiro.com
Purpose
Working at Centiro is different. Inspiring, challenging and rewarding. We are on a rapid path of expansion and are looking for talents with a passion and drive to make a difference. This is an exciting time to be joining & strengthening the team and shape the future together.
What will you do?
As an Application Specialist (AS), you are responsible for analysing customer requirements, developing and maintaining system integrations and components, including but not limited to; application to application integrations, services, internal and external API, file transfer, and/or EDI and SQL queries. AS is fully responsible for participating in requirements analysis, design, development, internal testing, and the documentation of same for the application-application integrations.
Primary responsibilities will also include understanding product architecture, design dependencies, troubleshooting existing integrations and providing technical support to the development team.
Initially you will learn how our systems function and as you progress you can decide your area of specialization. You create your path; the possibilities are limitless. We work in self-organized teams with varied skills and as an organization follows/obeys a holarchy instead of a hierarchy. In a holarchy, each person’s value comes from his or her individuality and uniqueness instead of rank or seniority.
Who are you?
You are a tech-savvy person with an interest in integrations and how the world of digital affects the modern business. Always with the customer in focus.
You are expected to try, test, learn and implement. You are encouraged to seize opportunities and continuously develop with Centiro’s robust confidence in your ability. You are spurred by continuous improvements and seeing things from a new perspective.A collaborative mindset and aptitude are more important than prestige and personal priorities. With all tasks, everyone is equal in helping each other succeed.
What we are looking for:
- Degree in computer science, engineering from reputed institute
- 2-6 years of proven experience working with system integrations and worked with SQL, MS .Net, Database- MS SQL / Oracle, SQL Server Management Studio, Web services, SFTP
- Working Knowledge of different file formats like IFTMIN, XML, CSV, JSON
- Understands and learns the Software configuration and follows the steps to configure / implement / integrate company or 3rd party products and support client requests.
- Hands-on testing experience to validate integrations / solutions developed and implemented. Has worked with testing tools like SOAPUI/ ReadyAPI/ Postman
- Collaborate with business and technical partners to capture - understand requirements, estimate efforts, and deliver appropriate specification to drive the solutions
- Effectively communicate to management, business owners, and customer stakeholders as well as working closely with software developers.
- Able to define project requirements and manage/Lead small projects independently
- Proven problem-solving and troubleshooting skills and be able to organize their own workload by staying agile and responsive to team needs. Knowledge of JIRA, BMC remedy, Service Now.
Good to have :
- Working knowledge of Supply chain and logistics domain / supply chain ERP - solutions
- Exposure to release cycle, Power BI , Graylog, Grafana
- Experience working with Label scripting in languages like zebra and mark point
- Knowledge of C# , VB script