Content Marketing

Years of Experience required: 4 years (Min)

 Mandatory:-

·  At least 3 years of experience in database or BI developer role

·  Microsoft accreditation(s) preferred

·  Proficient at design and development of ETL using MS SQL Integration Services (SSIS)

·  Experience with common ETL Design Patterns

·  Proficient at writing T-SQL, stored procedures and functions

·  Proficient with analysis of data quality and data profiling

·  Experience with writing technical documentation and communicating database design

·  Experience working with an Agile team to create and develop operational processes and software

·  Experience developing ETL of OLTP data for analytical/BI reporting; ability to perform as OLTP DBA is a plus

·  Proficient in Excel BI Tools, XML, JSON and Version Control Systems (TFS experience is a plus)

·  Experience in OLAP schema modeling for DWH

·  Tableau desktop and Server experience is a plus.

Electrum is looking for an experienced and proficient DevOps Engineer. This role will provide you with an opportunity to explore what’s possible in a collaborative and innovative work environment. If your goal is to work with a team of talented professionals that is keenly focused on solving complex business problems and supporting product innovation with technology, you might be our new DevOps Engineer. With this position, you will be involved in building out systems for our rapidly expanding team, enabling the whole engineering group to operate more effectively and iterate at top speed in an open, collaborative environment. The ideal candidate will have a solid background in software engineering and a vivid experience in deploying product updates, identifying production issues, and implementing integrations. The ideal candidate has proven capabilities and experience in risk-taking, is willing to take up challenges, and is a strong believer in efficiency and innovation with exceptional communication and documentation skills.

YOU WILL:

• Plan for future infrastructure as well as maintain & optimize the existing infrastructure. 
• Conceptualize, architect, and build:
• 1. Automated deployment pipelines in a CI/CD environment like Jenkins;
• 2. Infrastructure using Docker, Kubernetes, and other serverless platforms; 
• 3. Secured network utilizing VPCs with inputs from the security team. 
• Work with developers & QA team to institute a policy of Continuous Integration with Automated testing Architect, build and manage dashboards to provide visibility into delivery, production application functional, and performance status.
• Work with developers to institute systems, policies, and workflows which allow for a rollback of deployments. 
• Triage release of applications/ Hotfixes to the production environment on a daily basis.
• Interface with developers and triage SQL queries that need to be executed in production environments.
• Maintain 24/7 on-call rotation to respond and support troubleshooting of issues in production.
• Assist the developers and on calls for other teams with a postmortem, follow up and review of issues affecting production availability.
• Scale Electum platform to handle millions of requests concurrently.
• Reduce Mean Time To Recovery (MTTR), enable High Availability and Disaster Recovery

PREREQUISITES:

• Bachelor’s degree in engineering, computer science, or related field, or equivalent work experience.
• Minimum of six years of hands-on experience in software development and DevOps, specifically managing AWS Infrastructures such as EC2s, RDS, Elastic cache, S3, IAM, cloud trail, and other services provided by AWS.
• At least 2 years of experience in building and owning serverless infrastructure.
• At least 2 years of scripting experience in Python (Preferable) and Shell Web Application Deployment Systems Continuous Integration tools (Ansible).
• Experience building a multi-region highly available auto-scaling infrastructure that optimizes performance and cost.
• Experience in automating the provisioning of AWS infrastructure as well as automation of routine maintenance tasks.
• Must have prior experience automating deployments to production and lower environments.
• Worked on providing solutions for major automation with scripts or infrastructure.
• Experience with APM tools such as DataDog and log management tools.
• Experience in designing and implementing Essential Functions System Architecture Process; establishing and enforcing Network Security Policy (AWS VPC, Security Group) & ACLs.
• Experience establishing and enforcing:
• 1. System monitoring tools and standards
• 2. Risk Assessment policies and standards
• 3. Escalation policies and standards
• Excellent DevOps engineering, team management, and collaboration skills.
• Advanced knowledge of programming languages such as Python and writing code and scripts.
• Experience or knowledge in - Application Performance Monitoring (APM), and prior experience as an open-source contributor will be preferred.

• Good understanding and experience of HTML / CSS / Javascript / Webpack / Bootstrap.
• Hands-on experience with ES6 / ES7 / ES8 features.
• Expertise with Web Services / REST APIs.
• Proficiency in Linux and deployment on Linux.
• Familiarity with Redux Thunk / Redux Saga will be an added advantage.
• Skillful experience in Node JS / Express / MongoDB will be a plus.
• Understanding of mobile cross-platform frameworks like React Native.
• Knowledge of AWS services like S3, EC2 would be valuable.

• Automate deployments of infrastructure components and repetitive tasks.
• Drive changes strictly via the infrastructure-as-code methodology.
• Promote the use of source control for all changes including application and system-level changes.
• Design & Implement self-recovering systems after failure events.
• Participate in system sizing and capacity planning of various components.
• Create and maintain technical documents such as installation/upgrade MOPs.
• Coordinate & collaborate with internal teams to facilitate installation & upgrades of systems.
• Support 24x7 availability for corporate sites & tools.
• Participate in rotating on-call schedules.
• Actively involved in researching, evaluating & selecting new tools & technologies.

• Cloud computing – AWS, OCI, OpenStack
• Automation/Configuration management tools such as Terraform & Chef
• Atlassian tools administration (JIRA, Confluence, Bamboo, Bitbucket)
• Scripting languages - Ruby, Python, Bash
• Systems administration experience – Linux (Redhat), Mac, Windows
• SCM systems - Git
• Build tools - Maven, Gradle, Ant, Make
• Networking concepts - TCP/IP, Load balancing, Firewall
• High-Availability, Redundancy & Failover concepts
• SQL scripting & queries - DML, DDL, stored procedures
• Decisive and ability to work under pressure
• Prioritizing workload and multi-tasking ability
• Excellent written and verbal communication skills

• Database systems – Postgres, Oracle, or other RDBMS
• Mac automation tools - JAMF or other
• Atlassian Datacenter products
• Project management skills

• 3+ years of hands-on experience in the field or related area
• Requires MS or BS in Computer Science or equivalent field

• Design and plan how test automation will be used within the company, you will then need to execute the plan.
• Test simple to moderately complex application components based on functional requirements in production and dev environments.
• Work closely with the development team to identify, report, and troubleshoot defects; verify problem fixes in a detailed, efficient, and timely manner
• Conduct end-to-end testing to ensure deliverables meet requirements and expectations
• Perform SQL queries to analyze and manipulate data.
• Detects and tracks software defects and inconsistencies and reports them to development and project management teams.
• Working with product owners and developers to define acceptance criteria, identify risks, and plan testing coverage for upcoming features
• Work both individually and as part of a team.

 TECHNICAL SKILLS:

• 4 years of experience testing solutions in object-oriented design and web applications developed using Python, Django, and Web API. Strong working knowledge of architecture and GUI usability.
• 4-year experience using selenium
• Minimum 1 year of experience in database testing with the ability to understand, write and execute SQL queries.
• A good understanding of software fundamentals including software design, algorithm development, data structures, code modularity, and maintainability.
• Ability to understand and approach projects in a logical and systematic manner so testing is detailed, thorough, and accurate.
• Experience with scripting experience is nice-to-have.
• Ability to communicate well and comfort in working with multiple internal and external teams.

PERSONAL QUALIFICATIONS:

• Bachelor’s Degree in Computer Science/related field or relevant work experience
• Minimum 3 years of software testing experience through a full system development life cycle, including implementing test plans, test cases, and test procedures
• Ability to teach yourself new technologies, processes, and products at a fast pace.

• Develop new business opportunities with potential customers at all stages of the sales cycle to include targeting, prospecting and presenting business propositions.
• Should be able to understand manage and interpret customer requirements. 
• Work with team to develop proposals that speak to the clients’ needs, concerns, and objectives. 
• To meet prospective clients and give presentations on the company's services to clients. 
• Build and deepen client relationships through proactively suggesting new ideas and opportunities add value to our client’s businesses 
• Screens potential business deals by analyzing market strategies, deal requirements, potential, and financials.
• Establish a good relationship with prospective clients, closures of sales for revenue generation. 
• Communication with clients (after-sales) to maintain the client-relationship

Desired skills:

1. Strong work ethic, highly organized, and a self-starter
2. Excellent written, verbal and interpersonal skills 
3. Detailed and multi-task oriented
4. Mission-driven and highly entrepreneurial mindset
5. At least 3 years of sales and business development experience in the software industry