Digital Marketing Internship

Role Overview:

As a Database Administrator, you will be responsible for the full lifecycle management of our MySQL or PostgreSQL database systems. This includes installation, configuration, performance tuning, security implementation, backup and recovery, and proactive monitoring. You will ensure the reliability, availability, and security of our database infrastructure, supporting our internal operations and client projects.

Job Responsibilities

• Installation and configuration of database software across diverse operating systems.
• Designing efficient physical database models derived from logical designs and application specifications, along with configuring database servers according to best practices and workload requirements.
• Establishing and implementing robust backup and recovery strategies tailored to data volatility and application availability needs.
• Implementing comprehensive security measures at the OS, database, and network levels to ensure authorized data access and maintain a rigorous security infrastructure with auditing capabilities for compliance.
• Fine-tuning hardware/VM resources for optimal database performance.
• Proactive monitoring of the database environment, including performance optimization through adjustments to data structures, SQL, application logic, or the DBMS subsystem.
• Configuration and implementation of database replication technologies (e.g., Master-Slave, Master-Master, Log Shipping, Mirroring, Always On).
• Automation of routine DBA tasks utilizing scripting languages such as Shell, PowerShell, Python, or GO.
• Proficiency in writing general SQL queries.
• Setting up comprehensive monitoring solutions for databases (OS and database levels) using custom scripts or third-party monitoring tools.
• Basic Cloud platform knowledge (AWS/GCP/Azure)

Qualification

Experienced DBA (4-8 years) with deep expertise in MySQL or PostgreSQL architecture, configuration, and management.

Proficient in SQL, backup/recovery, security implementation, performance tuning, and replication for both systems.

Skilled in scripting (e.g., Shell, Python) and Linux, possessing strong problem-solving, communication, and teamwork abilities with a proactive approach.

A relevant Bachelor's degree in Computer Science, Information Technology, or a related field.

We identify better ways of doing things.

Solver? Absolutely. But not the usual kind. We are searching for the architects of the

audacious & the pioneers of the possible. If you are the type to dismantle assumptions,

re-engineer ‘best practices,’ and build solutions that make the future possible NOW,

then you are speaking our language.

➔ Improver. Solver. Futurist.

➔ Great sense of humor.

➔ ‘Possible. It is.’ Mindset.

➔ Compassionate collaborator. Bold experimenter. Tireless iterator.

➔ Natural creativity that doesn’t just challenge the norm, but solves to design what’s better.

➔ Thinks in systems. Solves at scale.

This Isn’t for Everyone. But if you’re the kind who questions why things are done a

certain way—and then identifies 3 better ways to do it — we’d love to chat with you.

• Graduate/ PG from Tier-1 colleges (preferably MBA in Sales and Marketing)
• Minimum 3 years of experience in E– Commerce Marketing
• Thorough understanding of e-commerce marketing, including search engine optimization, keyword bidding and online tracking systems
• Ability to think strategically and structurally while solving growth problems
• A problem-solving mindset and willingness to challenge the established norms
• Experience with data analytics
• Extensive knowledge of Amazon Advertising (AMS), Amazon Display, DSP, Flipkart ADP and Flipkart PLA is required
• Understanding of Facebook Business Manager, TikTok Ads, etc. is a plus

A.P.T Portfolio, a high frequency trading firm that specialises in Quantitative Trading & Investment Strategies.Founded in November 2009, it has been a major liquidity provider in global Stock markets. 

As a manager, you would be incharge of managing the devops team and your remit shall include the following

• Private Cloud - Design & maintain a high performance and reliable network architecture to support  HPC applications
• Scheduling Tool - Implement and maintain a HPC scheduling technology like Kubernetes, Hadoop YARN  Mesos, HTCondor or Nomad for processing & scheduling analytical jobs. Implement controls which allow analytical jobs to seamlessly utilize ideal capacity on the private cloud. 
• Security - Implementing best security practices and implementing data isolation policy between different divisions internally. 
• Capacity Sizing - Monitor private cloud usage and share details with different teams. Plan capacity enhancements on a quarterly basis. 
• Storage solution - Optimize storage solutions like NetApp, EMC, Quobyte for analytical jobs. Monitor their performance on a daily basis to identify issues early.
• NFS - Implement and optimize latest version of NFS for our use case. 
• Public Cloud - Drive AWS/Google-Cloud utilization in the firm for increasing efficiency, improving collaboration and for reducing cost. Maintain the environment for our existing use cases. Further explore potential areas of using public cloud within the firm. 
• BackUps  - Identify and automate  back up of all crucial data/binary/code etc in a secured manner at such duration warranted by the use case. Ensure that recovery from back-up is tested and seamless. 
•  Access Control  - Maintain password less access control and improve security over time. Minimize failures for automated job due to unsuccessful logins. 
•  Operating System  -Plan, test and roll out new operating system for all production, simulation and desktop environments. Work closely with developers to highlight new performance enhancements capabilities of new versions. 
•  Configuration management  -Work closely with DevOps/ development team to freeze configurations/playbook for various teams & internal applications. Deploy and maintain standard tools such as Ansible, Puppet, chef etc for the same. 
•  Data Storage & Security Planning  - Maintain a tight control of root access on various devices. Ensure root access is rolled back as soon the desired objective is achieved.
• Audit access logs on devices. Use third party tools to put in a monitoring mechanism for early detection of any suspicious activity. 
• Maintaining all third party tools used for development and collaboration - This shall include maintaining a fault tolerant   environment for GIT/Perforce, productivity tools such as Slack/Microsoft team, build tools like Jenkins/Bamboo etc

Qualifications 

• Bachelors or Masters Level Degree, preferably in CSE/IT
• 10+ years of relevant experience in sys-admin function
• Must have strong knowledge of IT Infrastructure, Linux, Networking and grid.
• Must have strong grasp of automation & Data management tools.
• Efficient in scripting languages and python

Desirables

• Professional attitude, co-operative and mature approach to work, must be focused, structured and well considered, troubleshooting skills.
•  Exhibit a high level of individual initiative and ownership, effectively collaborate with other team members.

APT Portfolio is an equal opportunity employer

• Someone’s traveling to airport/office/home - can we suggest them public transport routes with first mile & last mile and accurate tracking of the individual leg of the journey
• Someone’s new in the city - can we help them travel from A to B in the most efficient way
• Someone’s planning to not use their private vehicle for the commute - can we design an efficient and reliable system to plan their commute with accurate information of public and private transport
• Transition people from private to hybrid multimodal commute
• Someone's traveling home late at night - can we give their friends, family peace of mind?
• Build a single mobile ticket for the entire journey

What you’ll do

• Build the backend and deploy systems powering the app
• Improve routing across 10+ cities for everything from walking to trains to electric scooters to metro to bus to auto to bike
• Integrate new private transport companies and new ways of getting about our cities
• Develop smarter ways of integrating the payment systems with the app
• Extract, process and crunch together departure times, travel habits, and pricing information and suggest reliable results to users
• Create experiences that delight your friends, family, and millions of new commuters when they come and visit your city
• Design and build systems that scale on demand and are secure
• Deploy and support your code on AWS
• Best practices: code reviews, tests, CI
• Teach us how to be better our Stack (Required) Java (Spring Boot), Postgres, MongoDB, ReactJs, Golang Microservice Nginx, API Gateway, Load Balancer, Kafka, Redis, Websockets, Docker, Kubernetes, Git, AWS - EC2, RDS, s3, lambda Optional Nodejs(Express)

Essential duties and responsibilities include the following.

• Design, create and maintain databases through multiple product lifecycle environments, from development to production systems
• Configure and maintain database servers and processes, monitor system health and performance, to ensure high levels of performance, availability, and security.
• Convert complex business requirements into technical specifcations to build scalable and reliable data solutions 
• Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Independently analyse, solve, and correct issues in real time on production, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes.
• Develop complex query, performance tuning, stored procedures and triggers, scheduled jobs, schema refinement.
• Flexibility to work after office hours for any production issue or production deployment.
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Qualifications include:

• 4+ years of database and backend development experience
• Good understanding of database systems and architectures
• Expertise in writing complex SQL queries and stored procedures
• Hands on experience with RDBMS and NoSQL data stores like  MySQL and MongoDB
• Experience working with Python scripting and application development
• Experience working with Cloud applications and data stores like AWS RDS is a plus
• In-depth understanding of data management and ETL processes

Experience

• 15+ years with deep expertise in Telecom domain spanning FTTx/PON, L2/L3 Packet Transport (Ethernet Switching and IP Routing) and Cloud networking from both traditional products and transformational products (disaggregated, virtualized, and based on open-source software).  

Key Responsibilities:

• Architectural (design and implementation) ownership of the Radisys BBA solution
• Architect product in consultation with PLM, pre-sales, and customers
• Contributing to and working on strategic deals, enterprise frameworks and comfortable presenting to senior leadership and Customers.
• Ability to quickly engage in proposals, work in a fast-paced environment and have the ability to multi-task.

Domain Skills Requirement:

• Deep knowledge of Telecom with FTTH solution is a must.. Hands-on experience in developing access solutions based on PON technologies
• Experience with deploying product at scale in a carrier-grade network
• Hands-on experience in developing Microservices in a container, orchestration, CI/CD-based environment.
• SDN and NFV 
• Wireline: ONF’s SEBA and VOLTHA Community and the challenges 
• CUPS (Control and User Plane Separation) 
• Wireline Access: OLTs, BNGs, ONTs, Residential Gateways (RGs) 
• PON Technologies: GPON, XGS-PON, NGPON-2, and Higher speed next gen PON standards (25G, 50G, 100G) 
• Ethernet Switching (L2) & IP Routing (L3); Software Defined Networking (ONOS, ODL) 
• Installing, running, and managing with Kubernetes (k8s) and Containers 
• Management and Orchestration (e.g., ONAP), Network Management, OSS/BSS, and TM Forum standards 
• Practitioner of Agile/SCRUM/SAFe

Qualification:

• Masters / Bachelor in any discipline of Engineering (Computer Science, Electronics preferred)