Database Developer- Lead

United States
Product Delivery – Product Delivery /
Contractor /
Remote
We PILLAR GLOBAL.
We build breakthrough software products that power digital businesses. We are an innovative product development partner whose solutions drive rapid revenue, market share, and customer growth for industry leaders in Software and SaaS, Media and Publishing, Information Services, and Retail. Our key differentiator is our Product Mindset. Our development teams focus on building for outcomes and all of our team members around the globe are trained on the Product Mindset’s core values – Minimize Time to Value, Solve For Need, and Excel at Change. Our teams apply this mindset to build digital products that are customer-facing and revenue-generating. Our business-minded approach to agile development ensures that we align to client goals from the earliest conceptual stages through market launch and beyond.
In 2023, 3Pillar Global India was named as a “Great Place to Work” for the sixth year in a row based on how our employees feel about our company, collaborative culture, and work/life balance - come join our growing team.

Responsibilities

    • "Partner with development teams to design data management and governance protocols, manage the information lifecycle, design infrastructure, and data integration controls
    • Understanding business strategy and cascades business intelligence needs to the database level
    • Design, configure, implement, and administer all databases for the respective parties involved
    • Develop and support complex models and logical database designs
    • Find and resolve all issues related to database systems to ensure that systems are online and without service interruption
    • Build and manage the database disaster recovery and backup plan
    • Can create and support stored procedures, views, tables, jobs, triggers etc.
    • Develop new and enhance existing standards, processes and procedures, and guidelines for database environments using industry experiences, best practices research, and business needs
    • Analyze and report the performance of database operations against the key database performance metrics
    • Database administration/development experience with RDBMS

Requirement

    • 7+ Years in IT service Bachelor’s degree in a related field Proficient with relational databases (e.g., Oracle, SQL Server, MySQL, PostgreSQL)
    • Experience in designing and implementing database structures Experience with automating DBA tasks Experience with data modeling and schema design.
    • Experience with Cloud-based DB solutions is a plus Experience with database Server backup and recovery techniques Proven experience in maintenance of SQL Server, MySQL, PostgreSQL.
    • Proven experience using Transact SQL, Stored Procedure and UDF Demonstrated experience in troubleshooting and resolving database problems Demonstrated experience in turning databases and its objects Understanding of database indexes Understanding of database design practices, including database normalization concepts.