LanceSoft
Database Administrator (Postgres)
LanceSoft, Toronto, Ohio, United States, 43964
#
NIT001 Duration: Jan 2025 to Dec 2025 Hours: 37.5 hours (8 30 AM to 5 PM EST)
What You'll Do You will work in team of Database engineers, providing technical expertise in designing, managing, and administering Databases in Cloud (AWS & Azure) and on-premises to meet business operations demands. You will engage in modernization activities to migrate application databases to open source and cloud and will be part of automation efforts to enhance provisioning and operations of all types of datastores. This includes performing core PostgreSQL Server administration activities such as database creation, performance tuning, monitoring, backups/restore/recovery etc, Design migration strategy from on-premises Databases to RDS/Aurora (Postgres/MySQL/MSSQL RDS). You would be responsible for providing operational & engineering support for Firm-wide applications hosted across database platforms on premises & cloud (Oracle, MySQL, Microsoft SQL Server, Snowflake, Postgres & Neo4j). Evaluate critical Database tiers security issues (content, internal controls, access levels, etc.) and provide recommendations, such as infrastructure & application patching, upgrades to new versions or successor releases.
Qualifications
4+ years of experience with Database Administration on PostgreSQL Database on AWS/Azure Cloud 2+ years of working experience on AWS (Aurora/RDS) or Azure cloud database technologies Must have working knowledge of SQL & Python and ability to perform process automation & data analysis Experience in migrating On-Prem database (Oracle, MySQL, Microsoft SQL Server, Postgres) to AWS/Azure Ability and desire to learn new technologies in the DevSecOps area and work with the team to implement new solutions to improve productivity Understanding and ability to work with Infrastructure as code Terraform and CI/CD Pipelines Knowledge/experience on Snowflake data platform would be preferred Strong process management background, in developing and optimizing process Skills:
Da tabase Administration on PostgreSQL Database on AWS/Azure Cloud Working experience on AWS (Aurora/RDS) or Azure cloud database technologies Working knowledge of SQL & Python and ability to perform process automation & data analysis Experience in migrating On-Prem database (Oracle, MySQL, Microsoft SQL Server, Postgres) to AWS/Azure Understanding and ability to work with Infrastructure as code Terraform and CI/CD
NIT001 Duration: Jan 2025 to Dec 2025 Hours: 37.5 hours (8 30 AM to 5 PM EST)
What You'll Do You will work in team of Database engineers, providing technical expertise in designing, managing, and administering Databases in Cloud (AWS & Azure) and on-premises to meet business operations demands. You will engage in modernization activities to migrate application databases to open source and cloud and will be part of automation efforts to enhance provisioning and operations of all types of datastores. This includes performing core PostgreSQL Server administration activities such as database creation, performance tuning, monitoring, backups/restore/recovery etc, Design migration strategy from on-premises Databases to RDS/Aurora (Postgres/MySQL/MSSQL RDS). You would be responsible for providing operational & engineering support for Firm-wide applications hosted across database platforms on premises & cloud (Oracle, MySQL, Microsoft SQL Server, Snowflake, Postgres & Neo4j). Evaluate critical Database tiers security issues (content, internal controls, access levels, etc.) and provide recommendations, such as infrastructure & application patching, upgrades to new versions or successor releases.
Qualifications
4+ years of experience with Database Administration on PostgreSQL Database on AWS/Azure Cloud 2+ years of working experience on AWS (Aurora/RDS) or Azure cloud database technologies Must have working knowledge of SQL & Python and ability to perform process automation & data analysis Experience in migrating On-Prem database (Oracle, MySQL, Microsoft SQL Server, Postgres) to AWS/Azure Ability and desire to learn new technologies in the DevSecOps area and work with the team to implement new solutions to improve productivity Understanding and ability to work with Infrastructure as code Terraform and CI/CD Pipelines Knowledge/experience on Snowflake data platform would be preferred Strong process management background, in developing and optimizing process Skills:
Da tabase Administration on PostgreSQL Database on AWS/Azure Cloud Working experience on AWS (Aurora/RDS) or Azure cloud database technologies Working knowledge of SQL & Python and ability to perform process automation & data analysis Experience in migrating On-Prem database (Oracle, MySQL, Microsoft SQL Server, Postgres) to AWS/Azure Understanding and ability to work with Infrastructure as code Terraform and CI/CD