System Analyst Resume

TECHNICAL SKILLS:

Server Operating Systems: Windows Server 2003,2008,2012

DBMS: MSSQL Server 2000,2005,2008,2012

ETL Tools: DTS (Data transformation services), Integration Services.

Reporting tools: MSSQL Server Reporting Services /SSRS/

Programming Languages: T - SQL, HTML, XML, PowerShell C++, and C #.

Network Topologies: TCP/IP, FTP, SMTP

Third party tools: Idera Diagnostic Manager, Spotlight.

Networking: SAN, NAS, LAN, WAN.

PROFESSIONAL EXPERIENCE:

System Analyst

Confidential

Responsibilities:

5+ years in - depth experience in managing multiple MS SQL Server servers with very large OLTP Databases in development, testing/QA and production environments.
Administration of 1000+ databases, across servers in a heterogeneous environment from standalone to clustered servers Sql server 2005 Sql server 2008, Sql server 2012
Logical and physical planning of relational databases; manage internal databases from planning and testing stages through implementation and support.
Experience with SQL Server Installation, Configuration, Migration, SSIS, SSRS and administration, apply periodic Service packs and hot fixes (cumulative updates) and complimentary third party tools.
Hands on experience and outstanding knowledge of High Availability and Disaster Recovery solutions, including SQL Server Log shipping, Mirroring, Clustering and Always on.
Expertise in automating maintenance Plans in Server agent jobs and task scheduler.
Expert in creating database objects and including databases, tables, indexes, views, stored procedures, triggers, functions (Inline & Multivalued Table) and cursors.
Extensively worked on VMware and Implemented SQL Server
Performed regular performance tuning to ensure maximum database responsiveness using the native
Monitoring tools, such as, Performance (System) Monitor, SQL Server Profiler, SQL Diagnostics manager,SQL Nexus, DTA, PAL, Activity Monitor, as well as, the SQL Server Dynamic Management Views.
Provided mentorship, SQL Server database object coding best practices and coding standardizations to the Offshore dba team and the development teams on a regular basis.
Installs new database instances and ensure database systems maintain a high level of recoverability thru the integration of warm/hot solutions, such as, Log Shipping, Database Mirroring and Transactional Database Replication.
Create and Maintain detailed documentation outlining the physical/logical structure of the various database environments, such as, database procedures and standards, management, security, maintenance and the administration of the database environments.
Responsible for the promotion of database related objects into the staging/production environments with an emphasis on adhering to corporate standards, as well as, maintaining a secure, pristine and responsive environment.
Sql server database migration from sql server 2005, sql server 2008 to sql server 2012 into virtual environment.
Fair understanding of VM Environment
Good with Sql server internals knowledge

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship