Database Developer/Administrator
 


Database Developer/Administrator

paragon_recruit E-commerce software platform development

This role will help us evolve our e-commerce, fundraising platform for today’s modern consumer. We need curious, collaborative, interesting and creative technologists. People who believe in our purpose of fostering authentic human connections as the single most important driver of business and societal progress. We promise to inspire you, develop you, and empower you.

Prerequisites:

  • Minimum of 10 years’ experience in database design, optimization, maintenance and SQL development
  • Hands-on experience designing, maintaining and optimizing large, high volume transactional databases
  • Hands-on experience with cloud-based databases (Azure SQL Server, AWS RDS etc.)
  • Hands-on experience managing and maintaining database migration systems for development, QA and production application environments
  • Hands-on experience will widely-used database administration and development tools (RedGate Suite, Azure DataStudio, SSMS, SQL Server profiler etc.)
  • Hands-on experience managing low impact data migrations on mission critical database systems
  • Hands-on experience building ETL or other data migration applications

Bonus Prerequisites:

  • Hands-on experience optimizing non-relational databases (CouchDB, DynamoDB etc.)
  • Hands-on experience optimizing SQL generated by ORMs like Entity Framework, Hibernate etc.)
  • Hands-on experience designing and optimizing data warehouses, data lakes or similar large-scale data storage systems
  • Hands-on experience architecting redundant database systems (on premise clustering / mirroring and cloud based geographically separated clustered / mirroring)

Key esponsibilities:

  • Analyze and optimize existing SQL Server data structures used by a set of mission critical applications including batch jobs,e-commerce websites, web-based APIs and thick client applications
  • Identify poor performing queries and work with application development team to identify optimizations for application code generating SQL as well as stored procedures
  • Work with business stakeholders and application developers to identify requirements for new software development and be able to design highly performant and highly flexible database designs
  • Work with application development team to identify optimal migration strategies for new projects
  • Continually monitor the health of critical databases and proactively identify recommended areas for change in order to ensure high levels of reliability and performance
  • Develop database development standards for existing systems and new systems (naming conventions, data type usage, indexing/ optimization usage, data traceability usage)
  • Implement archiving schemes and ETLs for existing and new systems to allow for data audits while keeping database systems performant
  • Work with application development team on building one time and continuous migration systems between on premise and cloud-based databases
  • Review existing database system security implementation and implement necessary changes to reduce risk
  • Work with application development team to implement queries to be used in reporting systems

To apply for this job email your details to jen@paragonusa.com