Apply

Database Administrator

Posted 10 days agoViewed

View full description

💎 Seniority level: Senior, 5 years

🏢 Company: Simple Technology Solutions👥 11-50Information ServicesConsultingCloud ComputingInformation Technology

🗣️ Languages: English

⏳ Experience: 5 years

Requirements:
  • Bachelor's of Science Degree or Information Systems or equivalent experience is required
  • US Citizenship
  • Database Administrator with experience with PostgreSQL on AWS.
  • Experience with mission critical, complex environments, high availability and data security regulations for FISMA high environment.
  • Experience conducting database administration activies such as user account management, database maintenance, updates, data migration, data backups, data security, performance tuning, and upgrades as needed.
  • Experience with maintenance of data replication solutions.
  • Experience developing database automations and trusted language extensions.
  • Experience establishing and maintaining of security and integrity controls.
  • Collaborate with client technical staff, key partners, developers, product and program management.
  • Work in an Agile Environment and support multiple agile teams.
  • Manage and appropriately escalate data related, risks, issues, and challenges.
  • Address any issues related to database data, security and performance.
Responsibilities:
  • Provides database administration to include but not limited to: database details, database tuning, database query performance analysis, database replication, database schema updates, database backups, database user management, and database reporting of an Amazon Aurora PostgreSQL databases.
  • Develops automations with Cloud Formation and Lambda to provide consistent and repeatable provisioning, deployments, replication, and reporting.
  • Works on administration of the Development, Training, and Production databases and supports application deployments that may or may not involve schema updates throughout the environments.
  • Application of activity and data modeling, transaction/workflow analysis, internal control and risk analysis
  • Utilize modern business methods and performance measurement techniques
  • Provide technical direction to personnel performing systems analysis and system/ subsystem development tasks
  • Coordinate and perform logical and physical systems design
  • Review and prepare system documents and specifications
  • Prepare reports, studies, and documentation, deliver presentations, and participate in meetings
  • Be prepared to provide sound advice as to prioritizing projects or tasks and when to delay
  • Change and Configuration Management best practices
  • Enforce quality standards for engineered solutions and promote continuous improvement
Apply

Related Jobs

Apply

🧭 Full-Time

🔍 Software Development

🏢 Company: Kahuna Workforce Solutions

  • Expertise in Microsoft SQL Server 2019 on Linux: Advanced knowledge of administering SQL Server databases on Linux, including managing high-performance and high-availability environments.
  • Experience with Multi-Tenant SaaS Products: Proven ability to manage databases at scale across multiple regions and environments, particularly in a multi-tenant architecture.
  • Performance Tuning & Optimization Skills: Deep experience analyzing and resolving SQL performance issues, optimizing T-SQL queries, and using tools like Dynatrace for SQL Server monitoring.
  • Schema Management & Drift Control: Strong understanding of managing schema changes across hundreds of databases, ensuring consistency and preventing schema drift.
  • Index Management Expertise: Experience designing and managing large-scale index maintenance and optimization, ensuring databases remain performant and efficient.
  • Capacity Planning Skills: Ability to forecast infrastructure needs and lead capacity planning efforts, including assessing future growth and scaling database infrastructure accordingly.
  • Advanced T-SQL Proficiency: Mastery in writing, tuning, and optimizing complex T-SQL queries for high-performance database operations.
  • Familiarity with Azure Infrastructure: Experience deploying and managing SQL Server databases in Azure regions, including Azure virtual machines and disk storage options.
  • Experience with SDLC Database Management: Ability to manage databases across multiple development, staging, and production environments, ensuring database integrity at all stages of the software lifecycle.
  • Microsoft SQL Server 2019 (on Linux)
  • T-SQL query optimization and tuning
  • Dynatrace or equivalent SQL performance monitoring tools
  • Azure database management and scaling in multi-region environments
  • Index maintenance (fragmentation control, optimization)
  • Schema change management at scale
  • Capacity planning and infrastructure scaling for multi-tenant SaaS environments
  • Linux administration related to SQL Server environments (automation, shell scripting)
  • Automation of routine database maintenance tasks (backups, index jobs, reporting jobs)
  • Manage and optimize Microsoft SQL Server 2019 databases running on Linux across multiple Azure data center regions to support SDLC environments for a multi-tenant SaaS product.
  • Implement and maintain a scalable database infrastructure, managing hundreds of databases across development, staging, and production environments.
  • Analyze and troubleshoot SQL Server performance issues, using monitoring tools like Dynatrace, and apply performance optimization techniques to improve database speed and efficiency.
  • Oversee schema changes and prevent schema drift across hundreds of customer databases, ensuring consistency and accuracy in automated deployments.
  • Design and execute an effective index management and sql job strategy, handling index fragmentation, maintenance, and optimization at scale.
  • Conduct in-depth T-SQL analysis and query tuning to optimize the performance of critical database queries, ensuring optimal database behavior.
  • Lead capacity planning efforts to assess the need for additional servers, and proactively scale the database infrastructure to support growth in customer demand.
  • Collaborate with engineering and DevOps teams to plan and schedule database jobs (e.g., backups, indexing, statistics updates, and caching) to ensure smooth operation with minimal downtime.
  • Develop best practices and processes for managing SQL Server jobs (reporting, caching, backups, index updates) and document approaches to ensure consistency across environments.
  • Provide guidance and recommendations on SQL Server maintenance on Linux, including upgrades, backups, and disaster recovery planning.
  • Support multi-region failover strategies and high availability in an Azure environment.
Posted 1 day ago
Apply
Apply

📍 Tbilisi, Georgia, Warsaw, Poland, Podgorica, Montenegro, Belgrade, Serbia, Yerevan, Armenia

🔍 Software Development

🏢 Company: Cloudlinux

  • Proven experience of ClickHouse DB administration
  • Proven experience of PostgresSQL DB administration
  • Experience in configuring a database in a high availability architecture
  • Experience in database backup and recovery
  • Experience in database optimization for different load profiles
  • Intermediate level of English knowledge
  • Perform regular database maintenance, search for weak points (shortcomings) of the existing architecture, provide solutions or workarounds, and help implement them
  • Configure database backups and prepare recovery plans
  • Describe database infrastructure as a code
  • Document databases of existing services and applications
  • Maintain user access rights and security of databases
  • Define key database monitoring metrics and define action plans to avoid/fix possible problems
  • Write standard operating procedures for recurring tasks, maintenance, and recovery works
  • Advise users on the subject of database optimization and writing DB queries

AWSPostgreSQLSQLGCPKubernetesClickhouseLinuxTerraformAnsibleScripting

Posted 1 day ago
Apply
Apply

📍 US

🧭 Full-Time

💸 80001.0 - 120000.0 USD per year

🔍 Information Technology

  • Bachelor's Degree and 0-2 years of professional experience.
  • Understanding of Structured Query Language (SQL) to query, manipulate, and update data within databases.
  • Ability to design and implement database structures (schemas) to efficiently store and access data.
  • Basic knowledge of database management systems (DBMS) like Oracle, MySQL, or SQL Server, including backup procedures, user management, and performance tuning.
  • Ability to identify and address data quality issues, ensuring data accuracy and consistency.
  • Ability to clearly communicate technical findings and insights to both technical and non-technical audiences.
  • Implements and maintains smooth operation and physical design of databases.
  • Perform routine database maintenance tasks like data cleansing and archiving.
  • Assist with data migration activities between different systems or databases.
  • Check data for accuracy and consistency against established rules.
  • Write and execute complex SQL queries to retrieve specific data sets.
  • Monitor database performance and identify potential bottlenecks.
  • Maintain clear documentation of database structures, processes, and data definitions.

SQLData AnalysisOracleRDBMSData visualizationData modeling

Posted 5 days ago
Apply
Apply

🧭 Full-Time

💸 104750.0 - 112500.0 USD per year

  • Bachelor's degree (or equivalent) with 5 - 7 years of experience, or a Master's with 3 - 5 years of experience
  • Oracle, MySQL, or Microsoft SQL Certification
  • CompTIA Security + (IAT Level II or greater)
  • Depth of knowledge and experience in major relational database systems, languages, and applications, such as Microsoft Structured Query Language (SQL) Server, Oracle, and MySQL
  • Must demonstrate the ability to pay keen attention to detail, possess a strong customer service orientation, and have the ability to work as part of a team
  • Proficiency in SQL commands, stored procedures, and database optimization techniques
  • Strong understanding of database security, integrity, and backup recovery processes
  • Ability to troubleshoot and independently solve complex technical database challenges
  • Ability to communicate clearly and succinctly both written and orally, and present products and ideas in a business-like manner
  • Responsible for database server administration functions supporting a global Active Directory infrastructure in a mixed environment
  • Provide database administration (DBA) support services, to include Tier 2 level expertise, as well as the planning, implementation, and monitoring of patching services for physical and virtual solutions
  • Implement and maintain database operations, ensuring system performance, integrity, and security
  • Conduct performance tuning of indexes and databases to optimize efficiency and scalability
  • Review database design and system integration, providing recommendations for improvements
  • Perform backup recovery and enforce security and integrity controls
  • Develop and implement database policies, procedures, and standards
  • Monitor database transactions, utilization, and overall system performance
  • Create and manage stored procedures, triggers, and reporting systems using tools such as Crystal Reports
  • Administer and manage database systems, including Microsoft SQL Server and other DBMS
  • Audit, modify, and update database records using SQL commands
  • Oversee database project scheduling, transaction log backups, notifications, and database replication across multiple SQL Servers and remote sites
  • Assist in the development and creation of SQL and web-based databases
  • Review technical documentation, reports, and system designs to ensure accuracy and compliance
  • Research and implement new database technologies to improve system efficiency and security
  • Provide technical support to operational strategies aligned within your program and initiatives that optimize processes, enhance productivity, and ensure quality across all program functions
  • Ensure 100% of planned hours are worked and recorded
  • Identify and forward to your leadership any opportunities that could lead to growth within your work area
  • Participate in growth efforts as requested
  • Ensure all contractual deliverables are met or exceeded to the customer's satisfaction
  • Complete personal PDP and attend staff meetings and Storytime (with the camera on)
  • Build productive and positive professional relationships with clients within your program
  • Execute all contract requirements as assigned in accordance with the contract-specific LCAT and requirements
  • Perform other related duties as assigned
Posted 6 days ago
Apply
Apply

📍 Poland

🔍 Software Development

🏢 Company: Jamf

  • Minimum of 5 years experience managing large database clusters implemented using one of the most popular database technologies (MySQL Server, Oracle, PostgreSQL) (Required).
  • Minimum of 5 years experience managing NoSQL database instances and/or columnar-based databases(Preferred).
  • Minimum of 2 years Amazon RDS and EC2 knowledge (Required).
  • Minimum of 5 years Familiarity with Linux, Tomcat, and Apache (Required).
  • Minimum of 2 years experience with system and infrastructure configuration tools (such as Terraform, Cloud Formation. Ansible and Puppet).
  • Minimum of 2 years experience with modern monitoring tools (preferably Prometheus and Grafana, but others such as CloudWatch, New Relic, Datadog are also accepted).
  • Minimum of 2 years experience with major public providers: AWS (preferred), Azure, GCP.
  • Strong Communication Skills.
  • Excellent Interpersonal Skills.
  • Excellent Organizational Skills.
  • Proven Analytical Skills.
  • Ability to communicate complex technical terms in an easy to understand, non-technical manner.
  • Self-starter, energetic multi-tasker, highly motivated and team player.
  • Ability to engage with and establish trust and rapport with all levels of customers and employees.
  • Apple Platform.
  • Agile.
  • Ability to adapt and solve challenges quickly and efficiently.
  • Ability to work independently and as part of a team.
  • Provide technical guidance, strategic direction and operational mentorship.
  • Work with the rest of the DBA team and cloud leadership to design and implement the public cloud infrastructure that supports Jamf database systems.
  • Work with the rest of the DBA team and cloud leadership to design and implement Jamf database systems.
  • Participate in system administration duties, remote access, maintenance of server’s integrity, data backups and restoration, and offsite storage
  • Proactively monitor all databases and related cloud infrastructure to detect and resolve problems and ensure uninterrupted operations.
  • Work closely with JAMF Software Development team on interrelated products.
  • Estimate accurately both time to complete tasks and impact of changes.
  • Drive continuous improvements within the JAMF Cloud infrastructure.
  • Work with JAMF Software’s technical team to bring current industry best practices to scale our systems to meet ever expanding demand.
  • Track and follow and, when required, escalate events in a timely manner to the appropriate individual according to documented procedures.
  • Maintain the Online Services technical documentation of processes and procedures.
  • When required, participate in a 24x7 on-call rotation.
  • Identify techniques and tools that will enhance the capabilities of the team to be more effective.
  • Act as an active advisor to department management team.
  • Build a deep understanding of workflows that make a JAMF Software customer successful.
  • Other duties and special projects as assigned.

AWSPostgreSQLSQLAmazon RDSApache TomcatBashCloud ComputingKubernetesMySQLOracleGrafanaPrometheusNosqlCI/CDLinuxTerraform

Posted 12 days ago
Apply
Apply

🔍 Software Development

  • A minimum of 5 years' experience with large scale software database projects and processes
  • Intermediate level experience in SQL Server stored procedures, SQL, data replication and SSIS
  • Intermediate level experience with the development of dynamic sql, loop processing and cross-server database considerations
  • Intermediate level experience with SQL performance tuning
  • Intermediate level experience with data analysis and root cause identification
  • Intermediate knowledge of computer systems, operating systems, system security, database management and web platforms
  • Experience with database migrations including client to private cloud for MSSQL Server and POSTgres
  • Working AWS and/or Azure experience with SQL databases running on EC2 and RDS
  • Work with individual clients to understand their requests relative to internal procedures and system standards.
  • Understand the way in which different parts of the data flow process work together.
  • Monitor and verify the health of the data/database environments across servers.
  • Create system and technical documentation and specifications for database procedures and standard solutions.
  • Evaluate technical solutions and database deliverables for scope adherence and potential scope creep – communicate with team leadership on details and next steps.
  • Ensure that non-functional requirements such as security, performance, maintainability, scalability, usability, and reliability are being considered when developing database solutions.
  • Provide internal client feedback in a timely manner to ensure that development or modification meets the clients’ needs.
Posted 20 days ago
Apply
Apply

🔍 Software Development

🏢 Company: Excella

  • 5+ years of hands-on experience developing, monitoring and optimizing MS SQL Server and Postgres databases
  • Good knowledge of the major AWS Cloud services and tools
  • Experience designing and building databases within an AWS Cloud environment, including working with services like EC2, RDS, DMS, S3, and IAM
  • Experience using AWS auto-scaling services to automatically adjust capacity and maintain predictable performance at optimal cost
  • Experience using monitoring solutions like AWS CloudWatch
  • Experience using version control solutions like GitHub or BitBucket
  • Experience working in Agile delivery environment using frameworks like Scrum, Kanban or SAFe
  • Experience in database migration from on-prem databases into the AWS Cloud using AWS DMS
  • Experience in IAM DB Authentication to configure the roles/policies to database users
  • Experience upgrading MS SQL Server and Postgres databases
  • Experience with database backup and recovery using AWS Backup service
  • 2+ years experience mentoring and/or supervising technical team members
  • Developing, monitoring and optimizing databases for web applications
  • Develop SQL scripts for applications, canned reports, and ad-hoc requests
  • Lead migration efforts for legacy datasets
  • Serve as the main point of contact for enterprise data teams
  • Bring a DevOps mindset to database development by automating processes, fully utilizing source control for all DB tasks, and removing dark work.
  • Mentor developers in database practices, and serve as a database SME for multiple agile teams
  • Help set mid-long term technical roadmaps as it pertains to database development, maintenance and migration.
Posted 23 days ago
Apply
Apply

📍 United States

🧭 Full-Time

🔍 IT Consulting

🏢 Company: Enterprise Horizon Consulting Group👥 11-50Information ServicesConsultingInformation Technology

  • Active Secret Security Clearance.
  • Security+ or higher-level certification.
  • Advanced knowledge of Oracle database management.
  • Strong understanding of AWS architecture, networking, and security concepts.
  • Familiarity with cloud-native tools such as AWS RDS, Aurora, DMS, and CloudWatch.
  • Expertise in backup, recovery, and high availability solutions like Oracle Data Guard and RAC.
  • Scripting skills in Bash, Python, or similar languages for automation.
  • Understanding of government compliance requirements and ability to implement secure database architectures in AWS GovCloud.
  • Strong communication skills to collaborate with technical and non-technical stakeholders.
  • Ability to work independently and collaboratively within cross-functional teams.
  • Excellent problem-solving and troubleshooting skills.
  • Lead and support the migration of Oracle databases and applications from on-premises environments to the cloud, ensuring minimal downtime and data integrity during the transition.
  • Manage and maintain Oracle databases, including installation, configuration, patching, performance tuning, and troubleshooting.
  • Work with cloud architects and engineering teams to design secure, scalable, and highly available Oracle database solutions in the cloud, considering government compliance standards.
  • Continuously monitor database performance, troubleshoot issues, and apply best practices to optimize Oracle databases in the cloud environment.
  • Implement and maintain disaster recovery, backup strategies, and high availability solutions for Oracle databases, leveraging tools like Oracle Data Guard, AWS RDS, or EC2-based solutions.
  • Ensure all Oracle databases adhere to relevant security and compliance standards (e.g., FedRAMP, FISMA, NIST), implementing encryption, auditing, and access controls as needed.
  • Use automation tools and scripting (e.g., AWS Lambda, Python, Bash) to streamline database management tasks and improve operational efficiency.
  • Work closely with cross-functional teams, including cloud engineers, application developers, and security experts, to facilitate the smooth migration of on-premise applications and databases to the cloud.
  • Maintain up-to-date documentation on Oracle database configurations, migration procedures, disaster recovery plans, and security implementations. Provide detailed reports and progress updates to stakeholders.
Posted 23 days ago
Apply
Apply

📍 Poland

💸 7000.0 - 8500.0 USD per month

🔍 Software Development

🏢 Company: Housecall Pro👥 1001-5000💰 $60,000,000 Series D almost 3 years agoHome ImprovementHome RenovationSaaSAppsInformation TechnologyMobileSoftware

  • 5+ years of MySQL (8.0) and 3+ years of PostgreSQL administration and scaling experience
  • Strong experience with traditional OLAP systems, ETL and associated Data Engineering and Data Warehouse practices
  • Strong expertise in managing growing datasets using techniques like Partitioning, Sharding, Caching, Archiving, and Clustering
  • Proficiency in performance profiling tools (Percona Toolkit, pgBadger, pg_stat_statements) and backup, restore, replication, and disaster recovery patterns
  • Familiarity with at least one NoSQL implementation (e.g. Redis)
  • Demonstrated experience with infrastructure as code tools (Terragrunt, Terraform, CloudFormation)
  • Understanding of distributed systems and tradeoffs between consistency, availability, and partition tolerance
  • Enjoy a mixture of schema design, reliability engineering, query and performance tuning, and operations work
  • Build infrastructure in a public cloud using Infrastructure as Code techniques
  • Collaborate with release engineering and delivery teams to optimize schema and data migrations, as part of our Agile development process
  • Build, maintain, and monitor data persistence systems (ACID-compliant OLTP, OLAP, Search and KV/NoSQL) in our cloud environments with an eye to both flexibility and long-term viability
  • Provide technical assistance, architectural insights, and individual contributor work across engineering
  • Mentor, pair, and imbue delivery teams with techniques and data access patterns to improve our applications’ interface with our data tier
  • Work directly with feature teams to optimize the development experience

PostgreSQLSQLCloud ComputingElasticSearchETLKubernetesMySQLData engineeringRedisNosqlCI/CDAgile methodologiesDevOpsTerraformData modelingData management

Posted about 1 month ago
Apply
Apply

📍 LATAM

🏢 Company: Nearsure👥 501-1000Staffing AgencyOutsourcingSoftware

  • 5+ Years of experience working as a Database Administrator.
  • 5+ Years of experience working with SQL coding.
  • 4+ Years of experience working with NoSQL Databases (Couchbase would be ideal).
  • 2+ Years of experience working with AWS, DynamoDB, or Document DB.
  • Experience working with N1QL queries (Couchbase SQL).
  • Experience working with SQL Server.
  • Heavy Admin Work.
  • Advanced English Level is required for this role as you will work with US clients.
  • Lead, hire, and mentor a team of 3 database engineers, fostering a collaborative and innovative environment and ensuring they are set up for success.
  • Provide guidance, training, and professional development opportunities to team members.
  • Taking a hands-on role within the team to specify, design, implement and deliver technical solutions.
  • Own all database functions and engineering on the revenue technology side of the organization including being accountable for the associated spend (FinOps practices) and forecasted capacity needs.
  • Providing thought leadership for how components and services are developed, tested and progressed.
  • Collaborate with the team to design and implement scalable and efficient database architectures.
  • Oversee the development and maintenance of data models, schemas, and structures.
  • Document all relevant processes related to database design, configuration, and performance.
  • Lead monitoring and supporting database systems (IaaS / PaaS) to ensure optimized performance and automation wherever possible.
  • Perform debugging procedures on database scripts and programs, as well as resolving conflicts.
  • Promote and adhere to best practices in securely operating, storing, backing up, and archiving data. This includes the governance, quality and strategy of standards within the team.
  • Oversee the administration and maintenance of database systems, including backups, restores, and disaster recovery planning.
  • Ensure the team follows best practices for routine maintenance tasks and database security.
  • Assisting architects and development teams by designing new databases(or changing existing ones) to meet the organization's application and data storage needs.
  • Collaborate with cross-functional teams within the CTO organization: Compliance, Security, Cloud Operations and Engineering.
  • Lead database-related projects from initiation to completion, ensuring milestones are met and projects align with organizational goals.
  • Develop project plans, allocate resources, and manage timelines effectively.
  • Identify opportunities for process improvements and automation in database engineering.
  • Stay abreast of emerging technologies and industry best practices to enhance the team's capabilities.

AWSLeadershipProject ManagementSQLBashDynamoDBGitJiraAlgorithmsData engineeringNosqlCI/CDMentoringLinuxDevOpsTeam managementData modelingConfluence

Posted about 1 month ago
Apply

Related Articles

Posted about 1 month ago

Why remote work is such a nice opportunity?

Why is remote work so nice? Let's try to see!

Posted 7 months ago

Insights into the evolving landscape of remote work in 2024 reveal the importance of certifications and continuous learning. This article breaks down emerging trends, sought-after certifications, and provides practical solutions for enhancing your employability and expertise. What skills will be essential for remote job seekers, and how can you navigate this dynamic market to secure your dream role?

Posted 8 months ago

Explore the challenges and strategies of maintaining work-life balance while working remotely. Learn about unique aspects of remote work, associated challenges, historical context, and effective strategies to separate work and personal life.

Posted 8 months ago

Google is gearing up to expand its remote job listings, promising more opportunities across various departments and regions. Find out how this move can benefit job seekers and impact the market.

Posted 8 months ago

Learn about the importance of pre-onboarding preparation for remote employees, including checklist creation, documentation, tools and equipment setup, communication plans, and feedback strategies. Discover how proactive pre-onboarding can enhance job performance, increase retention rates, and foster a sense of belonging from day one.