DBA - SQL, Postgres, MongoDb, Azure, PowerShell

SQL, Postgres, MongoDb, Azure, PowerShell
C2H W2, 6
Market
Work from home available

Job Description


Job Description:

Senior DBA (SQL Server, Postgres, MongoDb)

SMCI is seeking talent for an experienced senior level Database Engineer / Administrator is responsible for independently analyzing database performance characteristics and collaboratively changing the database design to improve performance and resource utilization. This role is a member of the engineering shared services team, responsible for translating product vision into commercialized projects. To fulfill this role, you will partner with application architects, software engineers, and dev-ops engineers to optimize system design including but not limited to data processing, storage, querying, reporting, and expiry.

Daily Functions / Duties:

  • Plan, design, build, transform, test, store and maintain data (SQL Server, Postgres, MongoDb).
  • Analyze, access, input, and retrieve data.
  • Report pertinent information and assist with tasks to support department operations.
  • Develop and maintain a solid understanding of the company products and market.
  • Adhere to established policies and procedures.
  • Ensure Customer Service delivery.
  • Adhere to the company Code of Conduct/Ethics and Core Values.

    Responsibilities:

  • Administers, manages and monitors all systems, including databases, in development, test and production environments.
  • Design and implementation of Azure cloud databases, high-availability solutions, replication, encryption, and disaster recovery solutions.
  • Data Partitioning, Purging and Archiving solutions in the Azure SQL ecosystem.
  • Migration of on-premises database to the Azure Cloud using SQL on VM, SQL MI, Azure SQL Database.
  • Azure CLI and/or PowerShell.
  • Writing T-SQL, including complex stored procedures, functions, views, and triggers.
  • Query analysis and troubleshooting Leadership responsibilities.
  • Provide technical leadership through example, develop innovation, strategies, processes, and best practices.
  • Monitor database performance, implement changes and apply new patches and versions when required.
  • Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
  • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
  • Perform scheduled maintenance and support release deployment activities after hours.
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
  • Own and manage uptime and performance SLAs.
  • Ability to work well with team globally specifically in India.
  • Work with Development and QA team, guide developers on following best coding practices to write optimal & efficient code.

    Skills:
  • 10+ years of DBA (SQL Server, Postgres, MongoDb) experience in a production environment
  • 3+ years supporting Azure SQL/Postgres cloud-based databases.
  • Nice to have experience of managing SQL Servers in AWS.
  • 5+ years in database tuning and project support, database server upgrades and migrations, writing and troubleshooting database stored procedures.
  • In-depth knowledge of security best practices including database encryption, column level encryption, SSL/TLS connection encryption, and service specific account permissions.
  • Experience with Azure databases specifically SQL Managed Instance and Azure Postgres.
  • Good understanding of DevOps and the role of database administration teams in DevOps.
  • Experience performing database deployments using .dacpac.
  • Advanced knowledge of performance tuning and administration, query analysis, performance monitoring and tuning, and maintenance routines
  • Experience with data warehouse and reporting technologies (specifically Power Bi) a plus.
  • Background in automating processes
  • Experience with creating and maintaining database infrastructure.
  • Experience interacting with customers on an as needed basis.


    Education / Certification:
  • Minimum of an undergraduate degree in Business, Engineering, or other related field
  • SQL Server, Postgres, or Azure Cloud certifications are a plus but not required.
    Required Skills: SQL;SQL SERVER; AZURE; POSTGRES; MONGO; AWS; POWERSHELL; SSL/TLS; AGILE.

    Don't hesitate! Submit your resume today.

    SMCI is an EEO employer. All qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, national origin, disability, age, genetic information, marital status, military, and veteran status. Members of minority groups, Vietnam Era Veterans and individuals with mental or physical disabilities are encouraged to contact us regarding employment opportunities. In addition, in order to support the provision of business to minority-owned and Women-owned businesses (MWBE), such MWBE are encouraged to contact us regarding subcontracting business opportunities with our firm.

    (No third parties, please)
    (H1 sponsorship currently unavailable)
    (Local candidates only, please)
  • Dice Id : 10518766
    Position Id : F210218
    Originally Posted : 1 month ago
    Have a Job? Post it