| $50/hr) Sr. SQL Database Administrator with Mongo and PostgreSQL in PA/NJ/NY/CT-Onsite at Remote, Remote, USA |
| Email: [email protected] |
| Hello, Hope you doing well!!! Job Title : Sr. SQL Database Administrator Location : PA/NJ/NY/CT-Onsite Interview : Video Interview Job Description: Sr. SQL Database Administrator Minimum 8 years in SQL DB Administration domain. Oversee and administer databases across various platforms including Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server. Conduct database installations, configurations, and upgrades adhering to best practices and security standards. Monitor database performance, fine-tune queries, and troubleshoot performance bottlenecks for optimal scalability and efficiency. Establish and enforce database security measures, encompassing user access controls, encryption, and auditing. Design database schemas, tables, and indexes to ensure optimal performance and scalability. Collaborate closely with developers to enhance database queries and bolster application performance. Deploy database partitioning, sharding, and replication strategies to enhance data distribution and availability. Implement high availability solutions like failover clustering, Always On Availability Groups, and database mirroring for critical databases. Develop and maintain robust database backup and recovery strategies to uphold data integrity and minimize downtime during outages or disasters. Manage databases in Azure Cloud environments, including Azure SQL Database, Azure Database for PostgreSQL, and Azure Cosmos DB. Leverage Azure services for data storage and analytics, like Azure SQL Managed Instance, Azure Blob Storage, and Azure Data Lake. Monitor Azure resources, analyze performance metrics, and optimize database configurations for cost-effectiveness. Document database configurations, procedures, and troubleshooting guides for reference and training purposes. Maintain up-to-date documentation of database inventory, configurations, and change management processes. Fulfill any other duties as necessary and assigned. Experience and Skills: At least 5 years of experience in database administration, showcasing expertise in Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server. Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate, PostgreSQL Certified Professional, MongoDB Certified DBA, or Microsoft Certified: Azure Solutions Architect Expert are highly desirable. Proficiency in SQL query optimization, database performance tuning, and troubleshooting. Knowledge of database security, encryption, and compliance standards (e.g., GDPR, CCPA). Familiarity with cloud computing platforms such as Azure Cloud and AWS. Strong problem-solving abilities, attention to detail, and capacity to work autonomously or collaboratively. Excellent communication and interpersonal skills, enabling effective interaction with diverse stakeholders. Thanks & Regards Deepak Singh | Sr. Technical Recruiter [email protected] www.avanciers.com Disclaimer : This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you should not disseminate, distribute or copy this email. Please notify the sender immediately by email if you have received this email by mistake and delete this email from your system. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. -- Keywords: database information technology microsoft Connecticut New Jersey New York Pennsylvania $50/hr) Sr. SQL Database Administrator with Mongo and PostgreSQL in PA/NJ/NY/CT-Onsite [email protected] |
| [email protected] View all |
| Wed May 22 20:42:00 UTC 2024 |