Senior Database Administrator (MS Sql)

MTBC

ایک سے زیادہ شہر، پاکستان

درخواست بھیجیں

مئی ۲۴, ۲۰۲۴ شائع ہوئی 246 نے دیکھا Report Job

PKR. 100,000 - 200,000/Month

RESPONSIBILITIES:

Installation and Configuration:
- Install PostgreSQL server software on appropriate hardware and operating system.
- Configure PostgreSQL settings such as memory allocation, connection limits, logging, and authentication methods.
Database Design and Schema Management:
- Design and create databases and schemas based on business requirements.
- Optimize schema design for performance and scalability.
- Manage database objects like tables, indexes, views, and sequences.
Backup and Recovery:
- Implement backup strategies to ensure data protection and disaster recovery.
- Perform regular database backups and test the restoration process.
- Configure and manage PostgreSQL\'s built-in backup tools like pg_dump and pg_basebackup.
Monitoring and Performance Tuning:
- Monitor database performance, resource utilization, and query execution times.
- Identify and troubleshoot performance bottlenecks.
- Tune PostgreSQL configuration parameters for optimal performance.
High Availability and Replication:
- Configure and manage replication for data redundancy and failover.
- Set up streaming replication, logical replication, or synchronous replication depending on requirements.
- Implement tools like pgpool-II or repmgr for automated failover and load balancing.
Security Management:
- Implement security best practices to protect sensitive data.
- Manage user authentication and authorization using roles and permissions.
- Configure SSL/TLS encryption for secure connections.
- Apply security patches and updates in a timely manner.
Capacity Planning and Scaling:
- Monitor database growth and plan for future capacity needs.
- Scale PostgreSQL horizontally or vertically based on workload demands.
- Evaluate and implement features like partitioning and sharding for improved scalability.
Automation and Scripting:
- Develop scripts and automation tools for routine tasks like backups, monitoring, and maintenance.
- Use tools like Ansible, Puppet, or Chef for configuration management and deployment.
Troubleshooting and Incident Response:
- Investigate and resolve database-related issues such as data corruption, connectivity problems, and performance degradation.
- Document troubleshooting procedures and maintain knowledge base for future reference.
Compliance and Auditing:
- Ensure compliance with regulatory requirements such as GDPR, HIPAA, or PCI DSS.
- Implement auditing mechanisms to track database changes and access.
Disaster Recovery Planning:
- Develop and maintain disaster recovery plans and procedures.
- Test disaster recovery plans regularly to ensure they are effective.
Documentation and Training:
- Document configurations, procedures, and best practices.
- Provide training and support to developers and other stakeholders on PostgreSQL usage and administration.

مہارتیں

Pg-stat-statements PgBadger PSQL PgAdmin

نوکری کی تفصیلات

صنعت:

انفارمیشن ٹیکنالوجی

شعبہِ افعال:

ڈیٹا بیس انتظام (DBA)

کل عہدے:

1 اشاعت

نوکری کی شفٹ:

دوپہر

نوکری کی قسم:

مستقل

محکمہ:

نوکری کا مقام:

اسلام آباد, راولپنڈی, پاکستان

جنس:

کوئی ترجیح نہیں

کم از کم تعلیم:

بیچلرز

ڈگری کا عنوان:

Information Technology / Computer Sciences / Software Engineering

کیریئر کی سطح:

تجربہ کار پیشہ ور

کم از کم تجربہ:

2 سال

اس سے پہلے درخواست دیجیۓ:

جولائی ۰۳, ۲۰۲۴

تاریخِ اِشاعت:

مئی ۲۴, ۲۰۲۴

MTBC

انفارمیشن ٹیکنالوجی · 1501-2000 ملازمین - اسلام آباد, راولپنڈی

پیروی کریں

pMTBC was established in 1999. Headquartered in New Jersey, USA, it is a dynamic and rapidly growing multinational healthcare IT Company. Deloitte Technology Fast 500 ranked MTBC in its list of fastest growing technology companies of North America. The Company has attained tremendous growth in the short span of a few years, which is testament to well-implemented, technology-based processes and which also lays the foundations for productivity. MTBC is following a formula of long-term growth by combining and utilizing labor force increase, investment activity and scientific and technological progress. MTBC offers American physicians customized solutions that reflect the very best in practice management services available in the industry today. Our services maximize the power of the Internet and technology to give medical providers better control over scheduling and billing, total access to all of their billing information, and comprehensive practice-management reports, all the while reducing the cost factor. The organization's management envisions reinvesting most of its earned profits mainly towards IT, and developing various technology-based solutions that will completely replace manual processes. MTBC operates 24/6 with a workforce of more than 1000 employees operating in three shifts in Rawalpindi & Bagh (AJK). The Company is providing a platform to young professionals to learn and practice their innovative ideas in a healthy work environment./p