Pandoblox

Job Openings

Stay agile with leading-industry insights from our veteran CxO's

About Pandoblox:

Pandoblox is a global team of digital business builders working together to change the way developers work together and collaborate for business transformations. We focus on culture and transparency making sure that we create environments that bring out our collective brilliance as we build. We've altered our language to ensure that our build intentions are not tainted by marketing and sales efforts focusing on our true nature of building. You'll see the difference the minute you talk to our team and get to know our methodologies.

About the Role:

Are you an expert SQL DBA who is looking for your next career move? This role will be leading the DBA team in the digital transformation from an on-premise environment to the cloud. As a key member of the data warehouse team, you will be solving problems and partnering with the data architects and other teams to ensure system performance is solid.  

SQL DBA role oversees all the databases and database servers in production and test environments to make sure they are constantly running on optimum performance, they are secure and failures are addressed. This role would also act as a gate keeper to our production environments under lead DBA's supervision. In addition to this, this role takes ownership of all DBA related tasks and distributes those tasks accordingly to other DBAs based on their capabilities.

Responsibilities:

  • Organize the DBA assignments and manage the work plans

  • Manage Cloud resources including but not limited to: Azure SQL DB, AWS Redshift, Azure Data Factory and Stream analytics, etc.

  • Manage security for cloud databases

  • Maintain and monitor SQL Server Databases while maximizing availability of critical business data

  • Ensure corporate data is protected, secured, and backed up for safeguard

  • Oversee required actions to make sure all servers are patched, and the latest service pack has been applied to all the servers while maintaining an effective communication on Server Maintenance and build activities and issues

  • Engage with the data warehouse team to develop your capability to understand ETL and related source systems to Identify issues and partner with the team to solve them

Requirements:

  • Strong communication skills and willing to work in a team-oriented structure

  • Develop TSQL Queries and TSQL based objects

  • Identify slow running queries in and performance tune those queries

  • Identify server’s hardware bottlenecks that could affect SQL Server’s performance

  • Identify shortcomings in SSIS packages performance and address those issues

  • Work with database administrator to provide around the clock support

  • Willing to learn new technologies and new tools to better monitor/manage the environments

  • Manage security and access rights on SQL Server database servers

  • Database design and architecture knowledge and experience

  • Created scripts to automate administrative tasks

  • Familiar with cloud DB services (e.g. Azure SQL DB, AWS Redshift, Azure Cosmos DB and Azure Table storage) as well as Azure Data factory and Stream Analytics

  • Strong knowledge in Relational Data Management, SQL Server  

  • Strong knowledge over SQL Server jobs and job maintenance

  • More than 1 year experience working and troubleshooting SSIS packages

  • Strong knowledge on how SQL Server security works

  • SSRS knowledge is a plus

  • Minimum 4 yr. degree in Systems related field is a plus or equivalent experience as a DBA/Lead DBA

  • Microsoft SQL Server certification is a plus

  • Familiar with the backup/recovery strategy

  • Knowledge on Database Security (i.e. encryption of data)

  • Authorized to work in the US

SQL Database Administrator

USA

Full Time

Apply for this job

Thank you for your application! We will get in touch with you soon!

Upload File